odbc catch clause

(0) Share

Report

Posted on by Community Member

I am using odbc to retrieve data.

Code looks like :

    OdbcConnection  odbcConnection;
str sql;
int res;
...
Statement statement;

try
{
 sql = 'bla bla';
new SqlStatementExecutePermission(sql).assert();
//Prepare the sql statement.
statement = odbcConnection.createStatement();

res = statement.executeUpdate(sql);
}
catch
{
info(CLRInterop::getLastException());
res = -1;
}
...

I have wrong sql, but AX through an exception, without reaching the catch clause.

How can I catch wrong sql in odbc?

Thanks :)

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Jesus R. ABASCAL 1,450 on at

Like (0)

Report
Copy link

Link copied!

Try this catch code:

catch(Exception::CLRError)

{

CodeAccessPermission::revertAssert();

perm = new InteropPermission(InteropKind::ClrInterop);

if (perm == null)

return;

perm.assert();

e = ClrInterop::getLastException();

msgError = e.get_Message();

CodeAccessPermission::revertAssert();

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

When there is a mistake on the sql I cannot catch it even on Exception::CLRError, as your suggestion.

Thanks :)

Was this reply helpful? Yes No
Suggested answer

Malcolm Burtt 1,475 on at

Like (0)

Report
Copy link

Link copied!

I'm not sure which exception you would need to catch for this but the error information can be retrieved using the statement.getLastError() and statement.getLastErrorText() methods.

Was this reply helpful? Yes No