Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: ho me
  Where is ho me?
 
 Philippines
 ho me
 To: Suresh Ramtekkar
  Where is Suresh Ramtekkar?
 Nagpur
 India
 Suresh Ramtekkar
 Tags
Subject: RE: Remote View of Oracle Database
Thread ID: 248780 Message ID: 248782 # Views: 1 # Ratings: 2
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 23, 2009 10:51:28 AM         
   


> Hi Friends,
> I using vfp9 (front end) and oracle 10g (backend). While working with remote views, I run my application on LAN Network and application run simultaneously.
> Problem is that I facing that If one user modified particular one record of remote view. That updates to ORACLE Database but not displaying modified record to another user on LAN Network. I update record with TABLEUPDATE() by force (TABLEUPDATE(.T.,.T.) and refreshing records by REFRESH() command. No error occured while updating record.
> Please give me solution.
> Thanks
>
> Regards
>
>
> Suresh


Hi,

How about REQUERY()?

ENTIRE THREAD

Remote View of Oracle Database Posted by Suresh Ramtekkar @ 12/23/2009 10:46:33 AM
RE: Remote View of Oracle Database Posted by ho me @ 12/23/2009 10:51:28 AM
RE: Remote View of Oracle Database Posted by Stefan Wuebbe @ 12/23/2009 11:03:14 AM
RE: Remote View of Oracle Database Posted by Anders Altberg @ 12/23/2009 5:13:53 PM