CollationAttribute( EVColAttribute.kStrength ) problem or bug?

[Stan Busk]

I use a SQL Query

gCursor = myDatabase.SQLselect( "SELECT * FROM myTable WHERE myField  
LIKE 'a%' )

Stan

> Hello Stan,
>
> Wednesday, March 1, 2006, 7:20:51 PM, you wrote:
>
>> Hi,
>
>> I have a little problem with CollationAttribute
>> ( EVColAttribute.kStrength ). I set it to kPrimary right after
>> converting databases from v1 to v2 format. Use to work for 99% of my
>> customers so far. However with the remaining 1% the attribute is
>> applied partially. In other words, some tables will be set to that
>> attribute and others not. In that 1 % customers the line:
>
>> myDatabase.CollationAttribute( EVColAttribute.kStrength ) =
>> EVColAttributeValue.kPrimary
>
>> only set the attribute to some tables but not all. I have pinpointed
>> the problem to one table so I used:
>
>> myDatabase.myTable.CollationAttribute( EVColAttribute.kStrength ) =
>> EVColAttributeValue.kPrimary
>
>> but it has no effect. Queries on that table continues to be
>> UCOL_IDENTICAL (when loaded in Valentina Studio)
>
>> Pinpointing up to the field I wrote:
>
>> myDatabase.myTable.VarCharField("myFieldname").CollationAttribute
>> ( EVColAttribute.kStrength ) = EVColAttributeValue.kPrimary
>
>> and then BOOM, it is set to primary.
>
>> So my question is, is the myDatabase.CollationAttribute() global? If
>> not, why some table are not set properly.
>> or... is myDatabase.myTable.CollationAttribute() table wide?
>
> Database's  collation  attributes are inherited by all tables.
> So it is strange.
>
> What kind of query is used?
>
> Seems to be a bug.
>
>
> -- 
> Best regards,
>  Ivan                            mailto:ivan_smahin at valentina-db.com
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina