I am using 16 bit BDE. I have a paradox 5 table with a Time/Date field (@).
If I try and post the following:
Table1.FieldByName('DateField').AsDateTime := Now
I get an error saying '2000 11:00:00' is not a valid integer.
I can post the date only to the field, ie 00:00:00, 29/02/2000 but if I try
and post time+date, I get the same error or some variation of the error. I
have tried accessing the field as a string with the same problem.
My short date style is set to 'dd/mm/yyyy'. In the BDE Date Mode is set to
1,
FOURDIGITYEAR = TRUE and YEARBIASED=TRUE.
Any ideas?
Thanks
Dom