Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi user on SQL-Server
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00595863
Message ID:
00595866
Views:
28
I've had this problem before and solved it, but cannot find where it is. If I remember correctly, I set the Grid's recordSource property to NULL, then refresh the local cursor, then set the recordsource property back to the local cursor name.

>Hi,
>
>I am using a SQL Pass Through connection to access a SQL Server Database with stored procedures.
>
>I use the SQLEXEC function to call my stored procedure and store result in a cursor. A grid's recordSource is set to this cursor at design time and the cursor is created in the form 'load method, so, when my grid is loaded datas are displayed. I'd like to put a refresh button on my form, so datas entered by other users are displayed in my grid. I plan to use the SQLGETMORERESULTS function, but it doesn't work. When I use another SQLEXEC to retrieve datas in my cursor, I loose my grid design.
>
>Any help will be welcome.
>
>Thanks
>Thierry
Thanks,
Dan Jurden
djurden@outlook.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform