You can't. It always closes and opens the cursor again. What I do when I need to keep the cursor open (grids come to mind), is I append a "tmp_" in front of the cursor name then I zap the original cursor and append the data from the tmp_.


>Hi All,
>
>I am currently using SQL Pass through with updatable columns. I managed to create and update the tables in the SQL server. How would I refresh the current cursor for the changes that I made on the server without closing and opening it again? TIA