ADO's date format (Delphi 7+Informix+ADO)

From: Eduardo Martinez (eduardom_at_nospamieqsa.com.mx)
Date: 12/15/03 

Date: Mon, 15 Dec 2003 13:51:44 -0600

Recently we started using above combination to replace Delphi
5+BDE+ODBC+Informix, but recently found that if we want to use a date
literal to post a query it only accepts yyyy/mm/dd format instead of
Informix's standard of mm/dd/yyyy which we've using.

Is there some way to change the format that the ADO driver uses for dates?

Any help is welcome.

Thanks in advance

Eduardo Martinez

Relevant Pages

  • Re: Next vresion reporting
    ... consolidated updates available and many issues addressed... ... you can still use active data connectors to get data directly from Delphi ... > I'm totally amazed to see demand for Crystal Reports. ... > have to start over just to change the original query (and it deletes all ...
    (borland.public.delphi.non-technical)
  • Re: Sharing data between forms
    ... In Delphi the current record in the ... dataset bound to the grid is the one selected in the grid. ... Where DM1 is the name of the datamodule, Qry1 is the Ado query that is bound ... The second form requires setting the query parameter before ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Cannot Read Certain DBase Fields with Delphi
    ... Query: SELECT * FROM PSDEBIT ... Vassiliev V. V. ... > I have a DBase table that I cannot read properly with delphi 5 or delphi ...
    (borland.public.delphi.database.ado)
  • ADO parameters are not recognized by SQL Server Mobile 3.1
    ... I am trying to use ADO select query with parameters in Delphi 7 to ... I can successfully query the .sdf database file from Delphi, ... using the ADO Insert query or the following ADO Command ...
    (microsoft.public.sqlserver.ce)
  • Delphi and Crystal 10 (Parameter passing)
    ... Using Delphi v5 and Crystal 10. ... I want to create an ADO query which I can then use within a Crystal ... Report written (initially based on a stored procedure which I created ... myReport: IReport; ...
    (comp.lang.pascal.delphi.misc)