ODBC

Post Reply
Jack
Posts: 249
Joined: Wed Jul 11, 2007 11:06 am

ODBC

Post 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
User avatar
Baxajaun
Posts: 853
Joined: Wed Oct 19, 2005 2:17 pm
Location: Gatika. Bizkaia

Re: ODBC

Post by Baxajaun »

Good morning Philippe !!!

Perhaps with TRY / CATCH / END

Best regards
Post Reply