Hi Aye,
ASESSIONS() fill array with all VFP data sessions
ASQLHANDLES() fill array with all ODBC handles
AUSED() fill array with all use alias for session
CURSORGETPROP("ConnectHandle","alias") return odbc handle for remote view/SPT
CURSORGETPROP("SourceType","alias") return type of source type (must be = 2)
CURSORGETPROP("SQL","alias") return SELECT command for RV (must be fill, if empty, then it is cursor created by SPT)
MartiJ
>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