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