Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLExec: as a user changes data, how can others see it?
Message
From
25/02/2004 11:59:56
 
 
To
24/02/2004 10:18:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00879984
Message ID:
00880751
Views:
18
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
Map
View

Click here to load this message in the networking platform