tony_bat wrote: > I retrieve data from paradox table then construct sql statement for insertion > into firebird table. > > 'insert into expense > ( exp_seq, description, amount, type, exp_dt, invoice_no, miles, obsolete ) > values > (1,'Transfer Tape ','17.8','1',"8/27/2009",'737198-00',0,'False')' > > If I use double qoute around date I get unknown column error. If I use single > quote around date I get arithmetic exception, numeric overflow error. > > using firebird driver 2.00.00.144
You shouldn't be constructing an SQL statement like that in the first place. You should be using a parameterized query. Set the parameter values and let the underlying DB-access code figure out how to send it to the database engine. -- Rob
