Problem with b12 and RB

[Stan Busk]

Hi,

For example, with the Database I have attached to mantis report  
#0003906 the following two SQL queries return the same result on my  
development computer (3 records) which is correct, but different  
results on the clean computer, 3 records for the first query and 0 for  
the second.

SELECT * FROM tblTransactions where ( Transaction_AccountDebited = 18  
OR Transaction_AccountCredited = 18 ) AND Transaction_Deleted = false  
AND Transaction_Enabled = true AND ( Transaction_Year = 2009 AND  
Transaction_Month = 1 ) ORDER BY Transaction_Date

SELECT * FROM tblTransactions where ( Transaction_AccountDebited = 18  
OR Transaction_AccountCredited = 18 ) AND Transaction_Deleted = false  
AND Transaction_Enabled = true AND ( Transaction_Date >= '1/1/2009'  
AND Transaction_Date <= '12/31/2009' ) ORDER BY Transaction_Date

Transaction_Date is a VDate, it holds the record date.

Stan

> On 1/14/09 11:41 AM, "Stan Busk" <maxprog at mac.com> wrote:
>
>> Hi,
>>
>> Yes they are the same. Yesterday I tried to reinstall the full
>> Valentina package and create the application again. No change.
>
> Do you use SQL binding ?
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina