Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Stefan Wuebbe
 To: Suresh Ramtekkar
  Where is Suresh Ramtekkar?
 Suresh Ramtekkar
Subject: RE: Remote View of Oracle Database
Thread ID: 248780 Message ID: 248783 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, December 23, 2009 11:03:14 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
Hi Suresh,

When you say the TableUpdate() attempt on one client did succeed, did you check whether the new/modified row actually arrived on the server (e.g. by doing an SQL Select in a third instance like Toad or a Vfp IDE instance)?
IOW, can you track down whether the issue is located in the commit part of your client.EXE code, or rather in the Refresh/Requery part, or if it's perahps a simple timing problem?



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