Page 1 of 1

ODBC

Posted: Thu Feb 14, 2019 7:25 am
by Jack
Hi,
I use ODBC to communicate with a filemaker database .

When i sent a wrong SQL instruction (oDbc:Query() , fivewin give an error dialog box .
If i hit enter, the program continue .

In place of the dialog box, i 'd like to write the error in a txt file and bypass the dialog box .

How to ?


oODBCK := TOdbc():New("DBNAME", "user", "password")
oDbfa:=oOdbc:Query("SELECT Numobj,dtedeb,numnat,numdesc FROM Objet WHERE Modif_Dte>=date()-1 ")

Thanks
Philippe

Re: ODBC

Posted: Thu Feb 14, 2019 8:20 am
by Baxajaun
Good morning Philippe !!!

Perhaps with TRY / CATCH / END

Best regards