[delphi-en] Sql insert date problem

[tony_bat]

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

Tony