Use the CONNSTRING clause in the USE command when opening the view:

USE mydatabase!Myview CONNSTRING posqlconn

Walter,


>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