FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour ODBC
Posts: 300
Joined: Wed Jul 11, 2007 11:06 AM
ODBC
Posted: Thu Feb 14, 2019 07:25 AM

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

Posts: 990
Joined: Wed Oct 19, 2005 02:17 PM
Re: ODBC
Posted: Thu Feb 14, 2019 08:20 AM

Good morning Philippe !!!

Perhaps with TRY / CATCH / END

Best regards

Continue the discussion