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