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
Sorry I don’t understand.
Can you explain a little more?
Thank you.
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.
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?
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.
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.
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%.
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
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,
usare qualcosa di poco ingombrante come lo e’ il combox quando non
viene attivato ( nel senso che non mostra in atto il suo contenuto)
immettere in esso il lemma del cliente: Es. %ROSS% (nota 1)
vedermi apparire nel COMBOX solo e
soltanto i nomi clienti che contengano il lemma
%ROSS%
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:
Here’s a sample solution attached, hopefully pointing you in right direction.
morenas.zip (307 KB)
cuoredisardegna@tiscali.i:
:
- 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.- In questo form introduco il lemma “A”. Mi appaiono tutti i clienti il cui nome principia per A.
- 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
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
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
Dear Mr. Maarten,
I have downloaded Your work.
Please could You help me?
Tanks in advance
Gianni Pinna
Only thing you have to do is:
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
There’s a section "Latest releases on this forum, where you can always get the latest beta version of Servoy.
I created this solution with rc13.
That’s why you can’t import it with your (earlier) version.
you need to update youre servoy version to the latest one (RC13)
see the thread in latest release forum.
You have saved the dynamicValuelist.servoy.zip als a zip file
you should save it as dynamicValuelist.servoy
(it is a zip so youre browsers wants to save it as a zip)
Don’t unpack it just click on that file itself when importing (after you have upgraded)
To Mr Maarten and to Mr Jcompagner,
tanks and compliments for Your work. It seems difficult that who knows Servoy style can go away from its world.
Gianni Pinna
Successfully downloaded Servoy new version; and imported ,o Jcompagner, in accord to Your attention, the solution that You ,o Maarten, have wonted create.
I have seen the effect, it is that was intended and followed. Well done!
Have you, in Your life problems the same promt and intelligent availability, You have wanted have with me in this one.
Now I have to study the causes of the effects of Your program.
Happy Sunday
Gianni Pinna
Dear Mr Maarten,
Enrico Arata wrote me, about Your work. He saied two about it:
1.) “..very tachnique”;
2.) “.. perfect”
I am studiing and learning it in all its virtuality.
Best regards.
Gianni Pinna.