General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I'm now using VFP data, but will be using SQL in the near future. I was hoping that all I had to do was change the connection handle when we are ready for the upgrade.
xSuccess is fine. The table updates OK: I checked through the command window (browse) & the field that was changed got changed (after screen refresh). I also checked, if I retrieve the changed data via a regular SQL SELECT statement (not SQLEXEC), then the cursor reflects the changes. But not if I use the SQLEXEC SELECT. How do I make VFP 'forget' what it retrieve via SQLEXEC SELECT, & retrieve a brand new 'changed' data?
FLUSH & GO RECNO() seems not to work.
I tried to put that in after TABLEUPDATE, but did not do the job.
Please help. Thanks!
>>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