> Where column 2 is the date column.
> I've just tested the same query in Delphi 3 with Version 4.54 of
> ODBCExpress
> and it works perfectly.
>
> Does anyone here use ODBCExpress, and come across the same problem?
> Any ideas on how to fix it?
Yeah, I've used ODBCExpress for a while. Use it mainly for web
development in Delphi. My guess with the date is it's probably
something to do with the default date format in Interbase. Try
using .AsString (if your using OEDataset) and date to string
conversion instead of .AsDateTime. It's not ideal but it could work.
It could also be a possible bug in ODBCExpress too...
Cheers,
Lukas
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz