Board index » delphi » ADO, Sybase and ClientDataSets, Oh My! Time and DatTime fields not working.
ADO, Sybase and ClientDataSets, Oh My! Time and DatTime fields not working.
2004-04-20 02:51:02 AM
I am using Delphi 6, Sybase ASA 8 on a Windows XP Pro machine.
In my application I have an ADO query(TADOQuery) doing a basic select
* from table where id=:id. Connected to this I have a DataSetProvider
which my ClientDataSet links to. I am able to insert, edit, and update
my table successfully for the most part. However, time fields, and the
time part of datetime fields will not save. The post and apply code is
No errors, and all string, integer, and date fields save the changes
to the Sybase database. Anybody know why the time and time part of
dattime fields will not save with my other changes and not raise an
Thanks for any help.