sorting

Classic Servoy
1

Don’t know if this question should be dropped here but:

When I give in a standard sort in the properties window sorting is done with uppercase words first and lowercase after that. How can I do a sort with no regard to upper- and lowercase?

Thanks,

Marcel

2

Hello Marcel,

I get the same here ! ! ! ! ! ! ! ! :shock: :shock: :shock: :shock:

Sorting sequence is case sensitive
First capital A-Z then Lowercase a-z
resulting in:

Arrow up
Button prev
Inform
Warning
arrow down
button next
window

Is there anyone out there who found an solution for this? ? ?
Code used:
controller.sort(‘NAME asc, GROUP asc’)

I was kind of hoping that a # before the field would resolve it but that didn’t help either.

Rene

3

This is controlled by the database, please check your database properties

4

Hello Jan,

Jan Blok:
This is controlled by the database, please check your database properties

I use the default firebird dbase engine 1.0 wich came with Servoy. How can I set these database properties??

I also have another question about sorting through a method.
I`m storing the users actions like finds and sorts in my solution in a user settings table.
Then I want to set the sort sequence through a variable.
example:
var Sort = ‘'DOCUMENT_NUMBER asc'’ \returns ‘DOCUMENT_NUMBER asc’
forms..controller.sort(Sort)

Is this possible??

Also tried to place the Sort between and placing the complete function in a variable and just call the variable.

Thanks in advance Rene

5

http://www.ibphoenix.com/a502.htm?a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID=‘104’
According to Firebirds knowledgebase, you have to set the charset to ISO8859_1.

No need to add the (escaped) quotes.

var Sort = 'COMPANY_NAME asc'
controller.sort(Sort)
6

Wow, thank you maarten…