Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multi user on SQL-Server
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00595863
Message ID:
00595866
Vues:
27
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform