ValueList disappears in Find

Classic Servoy
1

Hi,

I have few problems with the value list.. I need your help..

Problem:1

I have a seperate table called “valuelist” for storing all the values used in the valueList as records.

I have created a global field for each valuelist (eg:g_category, g_position,g_title etc..) and sets values for globals as exactly the same name as the valuelist

I created global relations for each value lists like:
g_vl_category (g_category::value_list~value_list_name)
g_vl_title (g_title::value_list~value_list_name)

I have attached the value lists to the correct fields on the form. It works fine when I’m in the browse mode.

But I go to the find mode the valuelist on the fields disapper. This happens for only the valuelists which uses relationship. If I use custom values it displays in the find mode as well..

Any work arounds with the existing situation?

Problem 2:

I have a field called languges with the display type checkbox and a value list with the languages are attached to it.

I checked 3 languages (English, French, Germen) for a record. But when I go to find mode and check only English, no record found though there is a record with a value English.

I don’t understand why.. The same thing I used to do in FMP without any problem. Also if the user searches (checks) 2 languages say English & Germen (1 &3) I want to find the record which got both these languages. I don’t want to allow the user to use the menus.

Can you guide me pls? Sorry.. Am I going too Filemakerish??

Thanks

2

Problem 2) That’s because you do an EXACT search of the language: English

So only records where you select English only, will show up!
(BTW: place the same field, as an TEXT-field next to it, and see what values are in it! Most of the time it is easier to read and check)

If you want this different you have to make a search method of your own: like this:

controller.find()
field = ‘#%English%’
controller.search()

Now you will find values which contains the value: English

Hope this helps

3

Problem_1:

As far as I know it is expected behaviour that the related valuelist is not showing up in ‘find mode’.
I think you still do your find’s like in Filemaker: first a find request, filling out values followed by search F3 or Enter (a button with a search method does not work here).
Best thing to do is handle your find’s in one method: (add # and %% to the globals if you like, and use a ‘find dialog or form’ )

find
field1=gfield1
field2=gfield2
search

Problem_2:

If you do a find like this (and I think you did) it should work:

Find
Check one or more languages
Search by pressing F3 or Enter.

Even if you fill out ‘English’ (= EXACT) in your languagefield (text) it should work.
This will only work if only one language is checked.

This is my experience, and that’s why I do not understand Harjo’s post.
But as HJK is far more experienced in Servoy I must have missed something. :lol:

Plse allow me to bring up another problem:

  1. In Ahmad’s example I can not UNCHECK all the checkboxes once I
    have checked one (or more).
    The only way is deleting the (remaining) language in the text field!

  2. Is it possible to position the checkboxes horizontally, and if so how?

4

if you do a manuall find and in Find-mode you select only: English
you will find only the records that has only selected: English.

So if you have a record with selections on: English & French you will not find this one, with the above example!

Hope this makes it clearer.

5

Crystal clear Harjo.
What do you think of MY problems. :wink:

6

Hi Ron ,

1.) you can not uncheck? Never seen this before. What is the field? Text or integer?
maybe you can post an example?

2.) checkboxes can be set horinzontally by setting the scrollbar horizontally to: never!

7

I am pretty sure this is a 2.1RC4 bug.
I tested it in the CRM.
In eg. 2.0b9 there is no problem.

8

You ment the VERTICAL scrollbar. :wink:
Is a somewhat hidden feature but it makes sense and no need to add
another property.

9

No !
I ment the horizontal scrollbar. Set this one to: never and you have your checkboxes horizontal!

10

1.) you can not uncheck? Never seen this before. What is the field? Text or integer?
maybe you can post an example?

I have had this problem before and it was resolved when the the valuelist is set to allow null values. HTH

11

I think we are both right Harjo!!! Hi, hi…
At least one of the horizontal or vertical settings has to be NEVER.
And then it depends on how you draw your field (does the checkboxes fit in
horizontal or vertical).
This means you can have this settings:

  1. V:wn H:n (most likely a vertical scrollbar occurs when the field is too
    narrow)
  2. V:n H:wn (possibly you will see a horizontal scrollbar: if you make the
    field too
    short you can even get a situation where you only see the scrollbar)
  3. V:n H: n (probably the best way to do it, no scrollbar hassle)

BTW did you test the checkbox (bug?)?
If you can’t reproduce it I’ll post a demo, but it is rather simple to do it yourself I think.

TIA

Ron

12

I have had this problem before and it was resolved when the the valuelist is set to allow null values. HTH

I think this solves your problem!

13

Sorry guys the NULL was allowed.
I report it as a 2.1rc4 bug.

14

Ron:
Sorry guys the NULL was allowed.
I report it as a 2.1rc4 bug.

In the valuelist dialog, in the lower left, there is a checkbox for “allow empty value”. That’s the one you need to CHECK so that you can UNCHECK the value in the valuelist. If you DO NOT check it, there needs to be at least one value in the valuelist.

Bob Cusick

15

Yep, THAT checkbox, OK, OK.
I had no problems in v.2. because this is an added feature in 2.1RC..
We NOW have to check ‘allow empty value’ to have the same behaviour.
In v.2 there was an ‘add empty value to list’ - checkbox’, which is replaced by the current one.
Anyway, I am glad it works now.
Thanks for your help guys.

Ron