Is it possible a searched combox effect?

[cuoredisardegna@tiscali.i]

Trought a combox united to a valuelist united to a field_name, i obtain theese effects:

1.) I see in the combox many items of that field_name
2.) I can select one item
3.) I can input it in the database.

But now i ask, is it possible to have in combox only “%name% presearched in 0 so that the working sequence will be 0, 1,2,3 and not 1,2, 3 ?

If it is impossible with a combox, does anyone know another direct way?

Tanks in advance
Gianni Pinna

[maarten]

Sorry I don't understand.
Can you explain a little more?

Thank you.

[cuoredisardegna@tiscali.i]

Dear Mr. Maarten,

tank You for Your continuous availability.

Suppose that we have :

a form : example_form ;

a field placed on that form : field_1 with theese property values:

displayType : COMBOX
data Provider : field_1
valuelist : valuelist1 defined as:
Database Values;
All values from: repository_server (table) items;
show in field/list (yes) : items_name
Return in dataprovider.

Suppose now that in items_name we have two records : A and B
Wen we exit from Designer mode if we click on field_1 :

Screen display us a combox_rectangle in wich we can see two names A
B
;
and then, if we click on A, A is inserted in field_1, and this is our end.

But now suppose that we want the same thing, but with a little difference: that is that the screen display us combox_rectangle only with A and not A + B.
Is it possible? Is it possible possible with COMBOX or in another manner?
Tanks in advance
Gianni Pinna.

[jcompagner]

it is not clear to me what you exactly want.
But do you want a combo that only displays record A als a value that you can choose but not record B?

Based on what? What is the filter that filters out B?

[cuoredisardegna@tiscali.i]

I have to premise that the end wich is firstly in my mind is to dislay in a combox only those records thath match a string: for instance : %.A%.

“But do you want a combo”
I exactly want :

1.) A combo . The reason for wich i want a combox i that it “becames a box or rectangle” only when i click on it .Therefore, before that i click on it, it does not occupyes area box on the box.

“that only displays record A as a value that you can choose but not record B? “

2.) That only dislays record A , and not record B, as the result of a search with the precedent string %A% and not string %B% .

Tank for Your answer. I am available for any other specification or, if necessary for expressing again the question.

[cuoredisardegna@tiscali.i]

Excuse .For a mistake i repeat the replay:

I have to premise that the end wich is firstly in my mind is to dislay in a combox only those records thath match a string: for instance : %.A%.

“But do you want a combo”
I exactly want :

1.) A combo . The reason for wich i want a combox is that it “becames a box or rectangle” only when i click on it , and before that i click on it, it does not occupyes area_box on the form.

“that only displays record A als a value that you can choose but not record B? “

2.) That only dislays record A , and not record B, as the result of a precedent search with the string %A% and not string %B% .

Tank for Your answer. I am available for any other specification or, if necessary for expressing again the question.

[Riccardino]

Excuse .For a mistake i repeat the replay:

I have to premise that the end wich is firstly in my mind is to dislay in a combox only those records thath match a string: for instance : %.A%.

M-^SBut do you want a comboM-^T
I exactly want :

1.) A combo . The reason for wich i want a combox is that it M-^Sbecames a box or rectangleM-^T only when i click on it , and before that i click on it, it does not occupyes area_box on the form.

M-^Sthat only displays record A als a value that you can choose but not record B? M-^S

2.) That only dislays record A , and not record B, as the result of a precedent search with the string %A% and not string %B% .

Tank for Your answer. I am available for any other specification or, if necessary for expressing again the question.

If I understand well, you want to attach the result of your search to a combo, for instance: suppose you have a valuelist based on db values from table "names", containing
Antonio
Alberto
Armando
Beatrice
Berengario

If you pre-select "A", the valuelist must show you only
Antonio
Alberto
Armando

Is that correct?

If so, what I don't understand is where you make the pre-selection that activates the search that will create your valuelist (in this case, where do you put the "A"?: in another field?

Ciao, ric

[cuoredisardegna@tiscali.i]

Gentile Riccardino,

ho ricevuto con letizia la Tua risposta. In essa Tu mostri cautela. La Tua apprensione del problema , forse da me malamente posto e' perfetta.
La domanda tuttavia cerca un mezzo per il fine e non necessariamente il raggiungimento del fine attraverso quel mezzo (combox).
Cosi' in ordine alla Tua domanda seguente:

"If so, what I don't understand is where you make the pre-selection that activates the search that will create your valuelist (in this case, where do you put the "A"?: in another field? "

provo ad esprimere il fine remoto da cui ha originato la domanda, certo che Tu, saggio del settore, al contrario di me che con il bello aiuto delle ottime persone Servoy provo ad apprendere i rudimenti di questo, a me pare, prezioso software, saprai trovare, se gia' non l'abbia trovata, la soluzione al problema magari banale.

Il mio fine e' quello di potere, essendo per esempio, in fase di fatturazione, giunto a dovere rintracciare il cliente,

1) usare qualcosa di poco ingombrante come lo e' il combox quando non
viene attivato ( nel senso che non mostra in atto il suo contenuto)

2) immettere in esso il lemma del cliente: Es. %ROSS% (nota 1)

3) vedermi apparire nel COMBOX solo e
soltanto i nomi clienti che contengano il lemma
%ROSS%

4) non vedermi apparire i nomi di tutti i clienti, come invece accade nel
caso di un campo che abbia per displayType COMBOX e per valueList il
collegamento ad una colonna di data base: ad es. clienti.
Un grato, lieto ed umile saluto
Gianni Pinna


Nota 1 Riesco ad immettere ed ottenere il cliente o clienti selezionati, in
un modo che non e' soddisfacente perche' mi costringe ad andare in una
altra pagina. Il modo e' il seguente:
1) Associo ad un label_button sito nel form fatturazione e di nome cliente il
metodo vai_a_ricerca_cliente che mi porta nel form clienti.
2) In questo form introduco il lemma "A". Mi appaiono tutti i clienti il cui nome principia per A.
3) Fra i clienti apparsi, seleziono quello desiderato e, attraverso un metodo, esso viene inserito nel field del form fatturazione che e' sito proprio al di sotto del label button(di nome cliente) dello stesso form.
Sintesi: E' vero che in questo modo io ho potuto preselezionare ed inserire
un cliente, ma e' anche vero che cio' ha esigito il ricorso ad una altra form.
Invece il ricorso a qualcosa di simile al combox apparrebbe utile per il suo non ingombro e per la sua immediatezza. Ove naturalmente fosse possibile. Questa infatti, Riccardino, spero che Tu sia daccordo, e' in ogni genere di problemi circa lo scibile o l'agibile umano la prima delle questioni :"Se sia" ( Utrum sit).

[maarten]

Here's a sample solution attached, hopefully pointing you in right direction.

[Riccardino]

:
1) Associo ad un label_button sito nel form fatturazione e di nome cliente il
metodo vai_a_ricerca_cliente che mi porta nel form clienti.
2) In questo form introduco il lemma "A". Mi appaiono tutti i clienti il cui nome principia per A.
3) Fra i clienti apparsi, seleziono quello desiderato e, attraverso un metodo, esso viene inserito nel field del form fatturazione che e' sito proprio al di sotto del label button(di nome cliente) dello stesso form.
Sintesi: .

Ciao, Gianni

Since the language of this forum is English, I'll reply accordingly. If you have problems understanding my suggestions, let me know and I'll write you a private message in italian.

----
What you're asking for is not so easy (not impossible, anyway), but I think you must consider a couple of options:
using the ShowFormInDialog function or using a tabpanel

If the main problem is that you don't want to switch to another form when choosing the customer, you can use the showformindialog function, that lets you show a form as a floating window, without losing the focus of the document you're into (in this case, an invoice).

Using a tabpanel, instead, lets you put a form into another form: so you can search you customers remaining in the invoice form.

Ofcourse, in both cases you've to build an extra form, but you don't need to leave the invoice form to search the customer.

Buon lavoro

[cuoredisardegna@tiscali.i]

Dear Riccardino,

tank You very much for Your prompt replay, for Your general vision with wich You with true define the limits of the question, for Your contingent solution, for Your suggestion about Forum_language: - i had a different information-. Excuse me.
Now i am going to work in accord to Your, for me preciouses specifications.
Compliments
Gianni Pinna

[cuoredisardegna@tiscali.i]

Dear Mr. Maarten,

i have seen Your precedent reply after a following reply, and so i tank You for Your very wished solution with a not ordered time. Excuse me. Now i'll try to experiment in accord to Your specifications. Compliments for Your precious Servoy and work.
Best regards
Gianni Pinna

[cuoredisardegna@tiscali.i]

Dear Mr. Maarten,

I have downloaded Your work.
Please could You help me?

1) Where have i to place two directories export and Meta-inf?
2) Then what have i to do in order to -i tink- importing, seeing, Your work?

Tanks in advance
Gianni Pinna

[maarten]

Only thing you have to do is:
1) open servoy
2) open File>Repository
3)click on import button
4) point to the directory where you downloaded 'dynamicValuelist.servoy' and open it.

[cuoredisardegna@tiscali.i]

Dear Mr Maarten,

excuse me.

When, aften steps from 1 to 3 a execute 4:

I have topossiblities: 1) tipo file [Servoy File]
2) tipo file [tutti i files]


If i choose 1:

I see only two directories: export; Meta-inf, and if i click on
one of theese two nothing is displayed.

If i choose 2:

I see also dynamicValuelist.servoy.zip , and if i try to open,
so, this file an error message advise me in details:
"Import with XML version 5 is not supperted. Upgrade Servoy
R20 rcl3-build 272 to import this solution"

Considering that i have downloaded Servoy approximatively two months ago, what have i to do?

Tanks again