V4MD: case insensitive ORDER BY

[Ruslan Zasukhin]

On 3/21/05 2:55 PM, "Martin Pallett" <martinpallett at netscape.net> wrote:

Hi Martin,

> this should be really easy, but I haven't been able to come up with the
> answer.
> 
> Here's what I want to do:
> 
> SELECT * FROM names WHERE recID >0 ORDER BY lastname asc, firstname asc
> no_case

No_case -- can be used only with LIKE

 
> which doesn't work, so I tried
> 
> SELECT * FROM names WHERE recID >0 ORDER BY upper(lastname) asc,
> upper(firstname) asc

This is almost correct.

Just you need define in your Table BaseObject Method (calculated field)
With such formula

        upper( fld )

Then you will use this method in the ORDER BY.
    
    ORDER BY fldUpr


> which also doesn't work
> 
> Unfortunately, I can't force the case of the names stored in the table,
> and some of them are only a first name.
> 
> Is there an easy way to do this, or do I have to create duplicate fields
> in the database in all uppercase and order by them?
> 
> Thanks in advance for any suggestions.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------