General information
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only