ADO + ClientDataSet + Sybase = no Time fields

From: Warren (Warren_at_Actsoft.com)
Date: 04/20/04 

Date: 20 Apr 2004 06:15:03 -0700

I'm having a problem with ADO, ClientDataSets and Sybase. For some reason all fields will post updates to the database EXCEPT for time fields and the time part of datetime fields.

I am using Delphi 6 with Sybase ASA 8 on a WinXP machine.

I have the ADO query doing a simple 'select * from table' statement. The clientdataset is connected to a datasetprovider which is linked to the ADO query. If I remove the ClientDataSet and just call a post on the ADO query, the time fields post correctly. When I add the ClientDataSet and call a Post and then ApplyUpdates(0) all fields update except for time fields and there is no error raised.

I would greatly appreciate any help anyone can offer.
Thank you,

Warren

Relevant Pages

  • Strange ADO.NET/Sybase/Sybase OLEDB problem
    ... we have developed in VB.NET and that accesses a Sybase database using the ... Sybase OLEDB driver via ADO.NET. ... Every morning about 5am, the windows service checks a specified directory, ... MergeData stored proc has started to finish prematurely before it has ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Dateadd in SQL statement not working
    ... Omigod, I thought you said you were using SQL Server, which is what my ... version of SQL used by Jet, which is the database usually used by Access): ... But my confusion is not totally resolved: Why are you using a Sybase ODBC ... driver to connect to either a Jet or a SQL Server database? ...
    (microsoft.public.inetserver.asp.general)
  • Re: Decouple SQL queries from class in OOP design
    ... then the arguments to the storeCart stored procedure have to be rather ... I have to be familiar with database schema, ... > support returning arbitrary numbers of rows through SELECT statements. ... > SYBASE does support that, and with SYBASE you have a lot of room to ...
    (comp.object)
  • Re: Sybase Market
    ... relational database management systems and database-related products. ... "Sybase" is also commonly used to refer to Adaptive Server Enterprise, ... a deal with Microsoft to share the source code for Microsoft to ...
    (comp.databases.sybase)
  • Re: Zombie handles when trapped by a signal
    ... Now that I know that the Sybase ... The concept is to do the execute with a timeout. ... > database server automatically is not correct. ... even after the DBD-Sybase bug is fixed. ...
    (perl.dbi.users)