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