Subject | Re: [IBO] Parameter looses value on reorder |
---|---|
Author | Lucas Franzen |
Post date | 2002-11-12T18:25:20Z |
Florian Hector schrieb:
As Andreas and Thomas told you before (in the german NG):
don't apply DateParams as String.
IB_Query1.ParamByName('Datum').AsString :=
DateToStr(DateTimePicker1.Date);
The problem ist that you store dates in Timestamp fields.
Either store them as DATE (in dialect 3) or make sure that you cut the
timestamp field before saving (sth. like trunc ( ....) in the Before
Post)
Then you can assign the param like:
IB_Query1.ParamByName('Datum').AsDateTime :=
trunc(DateTimePicker1.Date);
and all your problems are gone.
Luc.
>So much ado about so little things.
> Helen,
>
> I've tried now for a couple of days but didn't get any further. I've put
> together a little test application, if you care to have a look, you can find
> it here: http://florianH.dyndns.org/test.zip
As Andreas and Thomas told you before (in the german NG):
don't apply DateParams as String.
IB_Query1.ParamByName('Datum').AsString :=
DateToStr(DateTimePicker1.Date);
The problem ist that you store dates in Timestamp fields.
Either store them as DATE (in dialect 3) or make sure that you cut the
timestamp field before saving (sth. like trunc ( ....) in the Before
Post)
Then you can assign the param like:
IB_Query1.ParamByName('Datum').AsDateTime :=
trunc(DateTimePicker1.Date);
and all your problems are gone.
Luc.