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.