Collection.GetByname is case insensitive

[Paolo F Cantoni]

The help doesn't say so but experiments I've done seems to suggest that the Collection GetByName method is case insensitive.

Can anyone (preferably Sparx) please confirm this?

If it is case insensitive, what happens if more than one object has the same name?

How are case sensitive languages such as C# handled?  CHours and CHOURS are differnt classes, but GetByName (for class "chours") will only find one - the small amount of experimenting I've done suggests the choice by EA is arbitrary...

Reported,
Paolo

[Geert Bellekens]

Paolo,

I can indeed imagine that GetByName is case insensitive.
If there are multiple elements with the "same" name then I think it will return the "first", but the order doesn't seem to be guaranteed.
That is one of the reasons why I never use GetByName(), and I try to avoid using the EA.Collection alltogether.

Geert

[alesliehughes]

I can confirm that the code is case sensitive.

The case insensitive appears to be a database issue.  
For example, take the following SQL statement

Code: [Select]

SELECT * from table where Name = 'chours'.On an EAP file, it will return the first record that is matched, whereas Postgres will not.

For DBMS's this case sensitivity usually can be toggled to suit your needs.  Remembering that EA API doesn't handle GetByName where the number of elements is greater than 1.

[Paolo F Cantoni]

[size=18]...[/size]
On an EAP file, it will return the first record that is matched, whereas Postgres will not.

For DBMS's this case sensitivity usually can be toggled to suit your needs.  Remembering that EA API doesn't handle GetByName where the number of elements is greater than 1.

Well, in the testing I was doing (admittedly not thorough), the first element matched differed on different runs of the test where there were multiples...

Paolo

[alesliehughes]

Sorry, my mistake.

EAP files will return a record whereas postgres would not.

Alistair.