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
Previous
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