Read Field Value AsDateTime

[FarshadV]

I am connecting to a SQLite3 database with the UniDAC components (ver 3.00.0.7), and when I try to retrieve a column's data which contains Date and Time value I get an error.

My code is:

Code: Select all

TmpDate:= dmECOE.qryGeneral.FieldByName('OrderDate').AsDateTime;

The generated error is:

EConvertError "2010-03-26 00:00:00" is not a valid date and time.

Your help is very much appriciated.

Regards,

Farshad R. Vossoughi

Code: Select all

[bork]

It seems like the "OrderDate" field does not have the DateTime type in the database. If the "OrderDate" field has string type in the database then you should get this field as FieldByName('OrderDate').AsString and convert to the TDateTime format manually.

[FarshadV]

Thank you very much

Best Regards,

Farshad R.Vossoughi