>I have a VFP DBC that has only remote views and a "connection" to SQL server database.
>Now, I have to get the handler Id number when a VFP database container uses the "connection" to connect SQL server, idem when I use:
>
>myHandler = SQLCONNECT(...)
>
>Why ?
>I need to execute a store procedure in SQL server that apply roles, e.g.:
>
>myHandle = SQLCONNECT("mySQLdatabase","myUser","myPwd")
>liResult = SQLEXEC(myHandle, "exec sp_setapprole 'myRole', 'myPwd'")
>
>But,
>
>It's only works in the current session, that's why I need the number.
>
>How can I get this number Id ?
>
>Thanks in advance.
? cursorgetprop("ConnectHandle","rvAlias")