Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Here's my connection:
lcConnStr="DRIVER={Microsoft Visual FoxPro Driver};" + ;
"SourceDB=myDatabase.dbc;SourceType=DBC;UID=;PWD=;"
THIS.lnHandle=SQLSTRINGCONNECT(lcConnStr)
User saves the changes by clicking a save button:
xSuccess=TABLEUPDATE(0,.T.,'cMyTable')
If I do a browse in command window, the changes will only show if I click/select the record that had just been changed.
In my .exe application,
another user will see the change only if he click on the save button on the same record & refreshes the screen.
Am I not using the correct way to update the cursor?
I don't remember why I did not use remote view & VFP8 is very new to me: I don't know how to utilize the cursoradapter (I don't know how to work it).
>On the form where you are editing the data, are you saving it? You don't show your connection statment, but are you using automatic transactions?
>
>Also, to refresh the view you don't need to requery, you should be able to use the Refresh() function...
>
>Refresh()
>ThisForm.Refresh()
>
>If you browse the data in enterprise manager, do you see it change as soon as you save that changes on the from where the edits where made?
>
>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