"08/27/2009" is a double-quoted string. I am sure Firebird supports the casting
function somehow. If the data collected from the Paradox table, for the field
"exp_dt" is of type string, and "exp_dt" is a datetime field on the server, you
would have to Cast('08/27/2009' as datetime) when inserting data into the
datetime field. You could also change the field type of "exp_dt" into string
type, and supply the string value for "exp_dt", if there isn't any arithmetical
operation performed on the datetime field. HTH.
Emmanuel
--- In [email protected], "tony_bat" <tony_...@...> 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
>
> Tony
>
