Try the date in english format..

MM/DD/YYYY in string when put ThisDate and ThatDate params in delphi.

On Sat, Jul 2, 2011 at 2:10 PM, Opcode Software <oppenhiemerb@...>wrote:

> **
>
>
> Hi Thomas -
>
> thanks for the reply. No, makes no difference if I remove the "invoice"
> clause.
> Actually - its in Delphi 2009 that I first noticed the problem and used
> IBExpert to check the sql was returning data (was previously compiled in
> Delphi
> 2005 so suspected the development tool was to blame.)
>
> I think I have found a solution in Delphi (which is my main concern) so not
> gong
> to delve deeper at this point.
>
> Thanks again for your feedback :)
>
> Dave.
>
>
> ----- Original Message ----
> From: Thomas Clarke <thomas.p.clarke@...>
> To: firebird-support@yahoogroups.com
> Sent: Sat, 2 July, 2011 16:46:40
> Subject: Re: [firebird-support] Date format problem Windows 7
>
> On Sat, Jul 2, 2011 at 9:11 AM, oppenhiemerb <oppenhiemerb@...>
> wrote:
>
> > **
> >
> >
> > Hi -
> >
> > I recently moved to WIndows 7 from windows XP and am experiencing some
> odd
> > behaviour with regards the database I am using.
> >
> > Specifically, the interpretation of the date on the 2 versions of windows
> > seems to be causing problems.
> >
> > I am using Firebird 2:0 and IBExpert (latest versions.)
> >
> > ON the XP machine on the same database - this query works (returns data.)
> >
> > SELECT TRANSID,TRANSDATE,INTERNAL_REF,DELIVERYITEM,ARCHIVED from INVOICE
> > WHERE INVOICETYPE = 'INVOICE' AND (TRANSDATE BETWEEN :ThisDate and
> > :ThatDate) ORDER BY TRANSID DESCENDING;
> >
> > ON the WIndows 7 machine (using the same database and same software) the
> > same statement does not return any rows.
> >
> > I have checked the Display format and regional-specific settings in the
> > Windows control panel and it all seems correct a.
> >
> > Any help would be much appreciated.
> >
> > Thanks.
> >
> > Dave.
> >
> >
> >
>
> Dave,
>
> I run similar queries on Win7 machines all of the time with Firebird 2.5.0
> and it works fine regardless of the windows data format or of the IBExpert
> date format. Are you sure there is not something else going on. I would
> remove the condition
>
> INVOICETYPE = 'INVOICE'
>
> and see what happens.
>
> Regards.
>
> Thomas Clarke
> Cyber Sea Incorporated
> #6 Kingston Terrace
> Flint Hall
> St. Michael
> Barbados BB11070
>
> voice: (246) 234-9692
> email: tclarke@...
> web: http://cybersea.biz
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>



--
Ricardo...


[Non-text portions of this message have been removed]