Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement