converterror 0.0 not a valid timestamp

[danios]

this code doesn't running since my last compo.upg. I've receive a error msg:
converterror 0.0 not a valid timestamp !!!!
What's wrong ? I didn't change anything since my last compilation ?

dm.tRappel.SetVariable('im_id',dm.tImmeuble.fieldbyname('im_id').asvariant);
dm.tRappel.Active := true;

 

[Marco Kalter]

Is the 0.0 value correct? Is the variable and/or the field a date?

------------------
Marco Kalter
Allround Automations

 

[danios]

thk fot you help,
If i don't initialise my variable, like this code : (put line in comment)
my prog is running without any problems.
this variable type is integer !
and I dont see why i've got this type of casting problem.

// dm.tRappel.SetVariable('im_id',dm.tImmeuble.fieldbyname('im_id').asvariant);
dm.tRappel.Active := true

 

[Marco Kalter]

So this expression:

dm.tImmeuble.fieldbyname('im_id').asvariant

causes the conversion error?

------------------
Marco Kalter
Allround Automations

 

[Dmitry Golovanov]

I have this problem too.
Error was in my data in table. Table has date field. And for 1 record value of this field was '00.00.0000' (dd.mm.yyyy).
This record was imported by BDE from interbase database.
I solve this problem:

update table set data_field = NULL where data_field < to_date('01.01.0001','DD.MM.YYYY')