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]