Information générale
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement