Exception on date fields
Posted: Tue 19 Dec 2017 03:46
I had program based on IBX components and it works fine. Now I changed to IBDAC, everything
works fine also, except date fields. For example code like:
dpBirthdate.Date := FieldByName('BIRTH').AsDateTime
works fine with IBX, but the same database, the same records with IBDAC giving me exception with the message something like "-757894579 is invalid timestamp" though in IBX and IBExpert program there is valid values in this field.
Also in DBGrid date fields are showed in strange format like '12.06.632327' though in fields properties I setup clearly date format
Is there some secret parameters I need to change to make it work?
Thanks in advance
works fine also, except date fields. For example code like:
dpBirthdate.Date := FieldByName('BIRTH').AsDateTime
works fine with IBX, but the same database, the same records with IBDAC giving me exception with the message something like "-757894579 is invalid timestamp" though in IBX and IBExpert program there is valid values in this field.
Also in DBGrid date fields are showed in strange format like '12.06.632327' though in fields properties I setup clearly date format
Is there some secret parameters I need to change to make it work?
Thanks in advance