Problem with b12 and RB

[Stan Busk]

Hi,

As part of the database creation function I do:

myDatabase.CollationAttribute( EVColAttribute.kStrength ) =  
EVColAttributeValue.kPrimary
myDatabase.DateFormat = EVDateFormat.kMDY
myDatabase.DateSep ="/"
myDatabase.Flush()

Stan

> Hello Stan,
>
> Wednesday, January 14, 2009, 12:23:11 PM, you wrote:
>
>> 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.
>
> Please check date-format settings.
> Judging on '1/1/2009' and so, you should firstly issue something like
> these:
>
> set property DateTimeFormat OF DATABASE TO 'kMDY';
> set property DateSeparator OF DATABASE TO '/';
>
> -- 
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina