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.