Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec: as a user changes data, how can others see it?
Message
From
25/02/2004 14:27:18
 
 
To
25/02/2004 11:59:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00879984
Message ID:
00880816
Views:
23
>Here's my connection:
>lcConnStr="DRIVER={Microsoft Visual FoxPro Driver};" + ;
>"SourceDB=myDatabase.dbc;SourceType=DBC;UID=;PWD=;"

Why are you using SQL pass thru with foxpro data? You should be using native data access.

>User saves the changes by clicking a save button:
>xSuccess=TABLEUPDATE(0,.T.,'cMyTable')

That looks right... does xSuccess contain a number greater than 0?

>If I do a browse in command window, the changes will only show if I click/select the record that had just been changed.

You may have to use FLUSH.

I think we used to use:

GO RECNO()

This would update and FoxPro caching.

BOb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform