have you tried to set up the field types that you are passing as Parmameters.
I would suggest creating properties or local variables of that you want to use,
cast the type of the data passing in to the correct datatype of the insert
using something like
ltDate : Date Time if the field type is a Date Field
or if the field is a string type
I would do :stDate := sql component name ParamByName('exp_dt').asString
don't hard code the values.
--- On Thu, 8/27/09, tony_bat <[email protected]> wrote:
> From: tony_bat <[email protected]>
> Subject: [delphi-en] Sql insert date problem
> To: [email protected]
> Date: Thursday, August 27, 2009, 3:56 PM
> 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
>
>
>
> ------------------------------------
>
> -----------------------------------------------------
> Home page: http://groups.yahoo.com/group/delphi-en/
> To unsubscribe: [email protected]!
> Groups Links
>
>
> mailto:[email protected]
>
>
>
