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=;"
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
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