You’re offline. This is a read only version of the page.
2,845
I am getting the status as 916 when I am running this this dexterity code. Anyone know, what is 916?
*This post is locked for comments
I am glad , I was helpful. Now please verify my answer so I get some points . :*O)
Thank you so much Almaz.
It is a cross DB query and that user not have access to that DB. Your suggestion gave me a key to to verify this. Thanks again.
this comes when there is some permission issue. Check if your user have permission to the tables , views you are accessing in your sql statement.
Definitely there is something different for user to user that's why you are getting error, and that's why I wanted to see your sql statement.
Almos,
It is working fine for another user. I only need what is the meaning if status is 916. If you know the please share.
There is no SQL_connection and SQL_Statements code please share complete code.
Also, I am getting this error only for specific user. For others it is working properly. I have verified the role of them. both are same. Little confusing...
SQL_Statements = "USE " + 'Intercompany ID' of globals;
status = SQL_Execute(SQL_connection, SQL_Statements);
if status = 0 then
SQL_Statements = I_tQuery;
{Execute the SQL statements.}
status = SQL_Execute(SQL_connection, SQL_Statements);
if status = 0 and I_iMode = 1 then
{Retrieve data from the first results set.}
status = SQL_FetchNext(SQL_connection);
if status <> 31 then
status = SQL_GetData(SQL_connection, Opt_I_iColumn, l_sResult);
Opt_O_sResult = l_sResult;
else
share your code.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (