Information générale
Titre:
How to commit all RVs & SPTs by one ConnectionHandle number?
Versions des environnements
Dear All,
Having a problem as follow.
I'm using both RVs and SPTs in my application.
At first i establish the connection :
open database mydatabase share
*!* ("mydatabase" is holding all the remote views by a connection string called "myConnection")
posqlconn = sqlconnect('myConnection')
The problem exist when i send SQLCOMMIT().
Everytime when i use a remote view, I got a new different "ConnectionHandle" number and meanwhile the "posqlconn" is also holding a separate connection number.
So when I commit a remote view :
lnhandle = getcursorprop("ConnectionHandle")
lncommit = SQLCOMMIT(lnhandle)
I've to submit every particular views as I opened.
For the SPT statements, I always use like :
sqlexec(posqlconn,"update myTable set custID='A0001' where orderID='0001'")
Therefore, I have to commit the "posqlconn" also.
Because of this, I'm having "Transaction Log" problem.
Is there a way getting a same connection handle number for all remote views?
Or any way to commit alltogether at once by using same connection handle number?
I do appreciate so much if somebody give me suggestions on this matter.
Thanks in advance
Mya
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