ADO, Sybase and ClientDataSets, Oh My! Time and DatTime fields not working.

From: Warren (warren_at_actsoft.com)
Date: 04/19/04 

Date: 19 Apr 2004 11:51:02 -0700

I am using Delphi 6, Sybase ASA 8 on a WinXP 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
simple:

ClientDataSet.Post;
ClientDataSet.ApplyUpdates(0);

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
error?

Thanks for any help.

Warren