Sql error in a odbc command

[shewif]

Hi there,

I'm developing a c# window's solution with an interaction with a filemaker's odbc connection.

This application may send some sql request on inexistent tables or columns.

Is there specific code or message in the filemaker's reply? My goal is intercept this code, message to make an identification of the error's type and write a comprehensive message to the user.

[edit]

I find a code and a message send by mysql.

for a unknown column, filemaker says

• Message "Error in Result Column"
• SQLState : HY000
• NativeError : -203

The SQLState is always the same for the different kind of errors (HY000), but the NativeError number changes.

Where may i find a list of this code? I've nothing found in Filemaker' doc

Thanks a lot...

[/edit]

Thanks and sorry for my english....

Shewif

Edited August 28, 2008 by Guest

[Josh Ormond]

Are you looking for FM error codes?

If yes, try here .

If you are talking about MySQL, what version are you using? I haven't seen a comprehensive list, I always just search the site. Slowly compiling a list of my own (Only have a few right now).

Edited August 28, 2008 by Guest

[shewif]

Yes, I've already seen this list, but it seems to be a filemaker's user list. I search a filemaker's sql error list.

for example, a request that make a duplicate key(with unique clause) is associate to a SQL message "Field failed unique value validation test" and a SQLNative error -511.

This list have an another message for error 511;(

I hope that i don't need to test all possibilities to do my own error's list message (in french)...

I don't use another DBMS. But i don't look if Mysql error number is the same.

thanks