Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changes not Saved
Message
From
16/02/2006 11:01:11
Robert Dinsmore
Dinsmore & Associates, Inc.
Lexington, Kentucky, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01095812
Message ID:
01096754
Views:
21
After further investigation, here is what is really happening:

Start system and run Form A. Changes are saved normally using a view and tableupdate().

Run Form B. This form updates the same base table as Form A but not as a view. It works fine.

Run Form A again. Now, the changes do not save. Here is the code:
x=tableupdate(.t.)
browse && the changes are there.
requery()
browse && the changes are gone.

So, it appears that the requery() is not working for some reason after Form B is run. The client tells me that changes do not get saved even if Form B is not run but I can't get this to fail.

Thanks for your help,

Robert
Previous
Reply
Map
View

Click here to load this message in the networking platform