Information générale
Titre:
Multi user on SQL-Server
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement