General information
Title:
Changing the connectionhandle for the update.
Hi,
I am using SPT to work with SQL Server Data. My approach is as follows:
I create a connection and use SQLExec to retrieve the results in a cursor.
When I have the cursor I use cursorsetprop to set the buffering, Tables, UpdateFieldList and some other properties to make the cursor behave like a remote view. After that I can make changes to the cursor and use tableupdate to update the SQL Server Data.
This all works fine, if the connection that created the cursor stays open. This is because the cursor needs the same connectionhandle, you used to retrieve the data, if you call tableupdate. The connectionHandle is stored in the ConnectionHandle property of the cursor, and is readonly.
Does anybody know how I can tweak this behavior (for example: set the readonly ConnectionHandle property) so I can open a connection, retrieve the data, close the connection, and reopen the connection only if I want to call tableupdate?
TIA,
Stefan
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