How to clear the ODBC error code?

[stephen bu]

Hi, guys.

I am a beginner,and I want to judge that whether the ExecuteSQL works fine by using the function of Get(LastODBCError).But everytime the function will get the last ODBC error code, regardless it worked fine or not.So I have to clear the ODBC error code before the ExcuteSQL script runs.

And my question is how to clear the ODBC erroe code? Is there any script or function in the FileMaker can do it?

And sorry for my bad english :

Edited March 14, 2008 by Guest