GUI / SQL backend / Valuelist

Classic Servoy
1

I have a table for orders, and a table for accounts. I have created a valuelist in the orders form that display’s a listing of account names sorted by name from the Account Table. When the account is selected the account ID is inserted. So far this is what I want.

The problem I have is that there are 2400 account names in the listing, and it is only displaying the first 200 records. What I want to accomplish is a way for the user to type the first few letters of the account name and it would scroll to the section of the listing which alphabectically matches what is typed.

This was easy to accomplish in filemaker, but I am having trouble understanding the architechure. I have played around with several methods, and I could not even get the value list to display all 2400 records.

I am guessing that there will need to be some sort of SQL select statement embedded in a method.

Thanks for everyones patience, I have tried the help section, and read the documentation, but I guess this is a development design issue, and I need to better understand the development enviorment.

2

ebrandt:
This was easy to accomplish in filemaker, but I am having trouble understanding the architechure. I have played around with several methods, and I could not even get the value list to display all 2400 records.

I am guessing that there will need to be some sort of SQL select statement embedded in a method.

Have you tried using a SQL query, storing the result in a variable and create an array to populate the valuelist?
I don’t remember the syntax (and I can’t check it right now), but I think this option could do what you’re asking…

3

OK, Thanks, thats a place to start, I am still trying to understand variables and array’s and how they are used. This should be a good way to better understand the Servoy tool set.

Thanks Again,
Erich

4

having a valuelist of more then 200 values is really not a good UI design
You should give the user a search dialog where he can search for that contact. That’s a much better approace.

That you only see 200 is a bit strange because the limit we have is 500 when you are displaying non distinct values (that you de because we are doing a distinct select when what you show is the same as what you return but you have name/id combinaton)