Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery not working
Message
 
 
To
16/02/2006 15:14:23
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:
01096862
Message ID:
01096882
Views:
20
>This concerns a form that updates a table via a view and tableupdate.
>
>The use starts the system and goes to Form A adds records and it works fine.
>
>They close this form and go to Form B. Form B updates the same base table as Form A but not with a view. They close this form and return to Form B which no longer saves new records or changes to records. They then exit the system, re-enter and it works OK.
>
>I placed code in Form A as follows:
>
>=tableupdate(.t.)
>browse && Record is there
>requery()
>browse && Record is gone
>
>This is driving me (and my client) crazy. Anybody have any ideas?
>
>Robert

Make sure the table is not tablebuffered (only the view should be buffered, otherwise you would have double buffering).
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform