odbc catch clause

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (3)

Answers (0)

Suggested answer

Malcolm Burtt 1,475 on at

Like (0)

Report

RE: odbc catch clause

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: odbc catch clause

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

Thanks :)
Suggested answer

Jesus R. ABASCAL 1,450 on at

Like (0)

Report

RE: odbc catch clause

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();

}