Your server has fixed date formats it recognizes. Your client is locale
specific and respects your local settings only.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Stephen Lee-Woolf" <s.lee-woolf@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Monday, April 29, 2002 7:03 AM
Subject: Re: [IBO] DateTime and IBOQuery


> Helen
>
> I've upgraded to IBO 4.2.Ha. I modified the IB_constants.pas file as you
> suggested and then performed the installation.
>
> On re-compiling my code I still get exactly the same error message as
> before - the DateTIme format simply isn't being recognised by IBO.
>
> Anything else I can try?
>
> Steve
>
> In article <5.1.0.14.0.20020425231937.081d42f0@...>,
> helebor@... says...
> > At 02:04 PM 25-04-02 +0100, Steve Lee-Woolf wrote:
> > >Perhaps someone can point me in the right direction here. I am using an
> > >app written in Delphi 6 with IBO to access a FireBird 1.0 database and
> > >am having trouble with datetime fields.
> > >
> > >If I use an external SQL tool to insert data into a DateTime field
using
> > >the SQL statement:
> > >
> > >insert into table1 (test1) values ('2002-04-23 23:15:21') - where
> > >test1 is a DateTime field
> > >
> > >there is no problem, the data is correctly inserted.
> >
> > Yes, because you have used a date literal representing a date format
which
> > Firebird recognises.
> >
> > >BUT if I use the
> > >same statement in an IBOQuery *albeit as a paramaterised query with the
> > >datetime value read from a DBGrid connectd to a .CSV text file, I get
an
> > >error message:
> > >
> > >'2002-04-23 23:15:21' is not a valid date and time
> > >
> > >Can anyone tell me what is wrong here? the same code worked fine on the
> > >original database (MYSQL) but is causing problems when I try and port
it
> > >to Firebird.
> >
> > IBO's default date format is MM/DD/YY. Simply go to ib_constants.pas
and
> > replace this line:
> > DT_DateFormat = 'MM"/"dd"/"yyyy';
> > with
> > DT_DateFormat = 'yyyy"-"MM"-"dd';
> >
> > If you are using an Eval version, you probably don't have the source for
> > ib_constants.pas. If this is the case, send me a private email, telling
me
> > which exact version of IBO you are using (read the Version property of
your
> > TIBODatabase in the IDE) and I'll send you the .pas file.
> >
> >
> > regards,
> > Helen Borrie (TeamIBO Support)
> >
> > ** Please don't email your support questions privately **
> > Ask on the list and everyone benefits
> > Don't forget the IB Objects online FAQ - link from any page at
> > www.ibobjects.com
> >
> >
> > ------------------------ Yahoo! Groups Sponsor ---------------------~-->
> > SALE --> Wireless Video Cameras
>
> --
> Steve Lee-Woolf
> University of Salford
> Manchester, U.K.