Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Suresh Ramtekkar
  Where is Suresh Ramtekkar?
 Nagpur
 India
 Suresh Ramtekkar
 Tags
Subject: RE: Remote View of Oracle Database
Thread ID: 248780 Message ID: 248830 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 23, 2009 5:13:53 PM         
   


> 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
Use
REQUERY('Viewalias')
instead.

-Anders

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