Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refresh on updateated SPT cursor
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Refresh on updateated SPT cursor
Miscellaneous
Thread ID:
01528590
Message ID:
01528590
Views:
71
I am accessing SQL Server 2000 data from FoxPro. I am making my connection to the SQL server with SQLSTRINGCONNECT. I use SQLEXEC to make the SQL Select that builds my cursor. I then use the appropriate CURSORSETPROP calls to make the SQL Pass Through Cursor updateable. However data in this cursor never updates if some other user makes a change to the table. Let's say another user adds a new record from a different workstation. The cursor on this one doesn't show that new record. I have SET REFRESH TO 0,5. Shouldn't it update the data in the cursor every 5 seconds from the SQL server? What am I missing?
Don Knoup
don.knoup@ticomix.com
Ticomix, Inc.
Next
Reply
Map
View

Click here to load this message in the networking platform