Auto Search Date Problem

rbuser

Hi,

I am designing a report that reports off of a Pervasive database, the
problem I am having occurs when I try to setup an auto-search entry on a
date field. When using Pervasives SQL to view the records in a table I am
able to do a 'where "StartDate" = '2003-06-19'' statement successfully.
However when I come to add the date in the Value box in my dade query I get
an invalid syntax error. If I change the date format to dd/mm/yy I get an
invalid date value.

Is it something obvious that I'm doing wrong??

Any help would be greatly appreciated,

Thanks
Martin Smith

digitalmetaphors

You should enter it matching the date format that the machine regional
setting are configured to. What is it set to in the windows regional
settings? How is it set on your database when you run your database
manager? Try making them the same to see if that solves the problem.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim,

I have tried entering the date in the same format as my regional
settings, I have tried changing my regional settings to the same as my
database manager and re-entering the values, none of which work. I keep
getting 'invalid date, time or timestamp value'.

If its any help my database manger expects the date format to be
'yyyy-mm-dd'

Thanks Martin

digitalmetaphors

Look in daSQL.pas and place a breakpoint in TdaSQL.ResolveCriteria to see if
RB is changing the date format. What Dade plugin are you using? You may have
to modify the code in this routine to support your date formatting. You can
see that this routine already formats the date for Oracle and MS SQL
Servers.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim,

Thanks for your help, I have now added in some code to format the date
correctly, just so you know I am using PDAC tables (from Pervasive) and just
the standard report builder components. In the designer, data settings
section I am setting the database type to dtOther.

Thanks
Martin