General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only