Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow tableupdate
Message
 
 
To
06/06/2003 14:00:10
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00796511
Message ID:
00797644
Views:
24
Craig,

Are you talking about a SQL backend like SQL Server or SQL commands running against VFP tables?

Requery( "TheView" ) will get you updated data content without the need to close/reopen it.

>In looking these questions I have one regarding updating a files from SQL via ODBC by one person and I would obtain the updated field via VFP.
>
>(e.i. Through ODBC I have a person updating the file from there application say SQL statements and I need to see the updated field from VFP. However, I have to close the file and reopen it from VFP before I can see the updated field). Is there a way to do a flush or buffering through VFP without closing the file to see the updated field? Also, I update the another field which he can not see unless I close the file and reopen it as well.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform