[libreoffice-users] Re: Can I reload a form based on a parameter query?

Friday, January 27, 2017, 6:05:01 PM, you wrote:


-----BEGIN PGP SIGNED MESSAGE----- 
Hash: SHA1 

Am 27.01.2017 um 16:21 schrieb ptoye: 
> Hi Robert, 
>
> I've had a look at some of your forms now, especially 
> filter_without_macros and I'm a bit puzzled. I see that the table 
> in the Display part of the form is populated by the "filterquery" 
> query, which references "filter". The table "filter" has one entry 
> - the selection(s) I made in the listbox. But I can't see how the 
> listbox selections get put into the "filter" table. Can you please 
> help me there? 

Could be this is a special behavior of Base-forms. There are two forms 
beneath each other. One form for "filter" and one for "display". I 
change values in "filter". I move to a button in "display". The 
content of "filter" will be saved when I push the button in "display" 
before the action of the button will happen. So there is needed only 
one button, which should refresh the form "display". The query for 
this form will be filtered by the entries in the table "filter". 
But how is the listbox connected to the table? The only connection I can see is by the name. I 
think it would be strange to say that a control with a name it automatically linked with at table 
of the same name. Also, the "ID" field in the "filter" table is set to YES, while its default is 
NO, which implies that something is changing it.




> I also can't understand why there are two columns in the 
> "listbox_n_simple", but that's of less importance. 

Most listboxes will show some text-content, but are linked to a table 
by an Integer-primarykey. So queries for listboxes look like 
SELECT "name", "ID" form "table_names" 
"name" will be shown. "ID" will be saved in the column of the form.
The query is SELECT "Sys.", "Sys." FROM "searchtable" GROUP BY "Sys." ORDER BY "Sys." ASC
So both columns will have the same contents.

 

You must have a look in the properties > data of the listbox. The 
"bounded field" will be '1' by default - and '1' is (a little be 
confusing, because it begins with '0') the second field. 
Some people start with 0, others with 1. It gets confusing when they're both working on the same 
project.


If the same content should be shown as it will be saved you could set 
this to '0' - so there must be only asked for one field. 

You could also set this to '-1'. This will save the numer of the row. 
I have never used this, but it works ... 
I've not heard of that. Thanks. Could be useful.


Regards 

Robert 
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-----BEGIN PGP SIGNATURE----- 
Version: GnuPG v2 

iQIcBAEBAgAGBQJYi4ucAAoJELDKYwaoS9AITnoQAKhjm6204tHi/aeQy2N9cIZp 
jzmXXg6NnQDwy6nGgSMjdoBjtFBMbwwfl76qNJMAQKtN5qigKPah3mBlnR04Yize 
NWRCpFuQdYXyv6FqChXh3EdGktfS4eMwpMAgLDaey3Zcbno7tXtetQ7YlJc7iGjd 
0eVEw/4Bk0TtDJ3hBLQ3aBe61RKwZnt2h+1V8rJQfvPbWPiSMNr/YznotaKIXSbJ 
zLrm6u97BeIcXd5E2K+lXxdmvDHacH5zKbv6j8B3h+D3JrHo5OzG62hYpYptmuh8 
dpKgC1D9Wpe3x96Of/5vz82E+csMJqk7VNrT0WgULdrPUy6oqxGoRZviKnS9QwmQ 
Et8mDm2PPZGdnvcns4lIaGLwkCPU9ZRyk08Oq1aeWvLp6I5E8M1KKblEURDbMr9W 
CTKJVkrEEiVj+MJux+b02GPrLCWIMv0TSoV7L8yiOQLSCb2EPh0DOsm/w3SMYo+t 
qV/+nXgdwHztVMZ5F8y33CaWl6LuMMiQJCHZAIY3Wu4qEQlD668J/zVDOA+I/m7I 
UG0K96RKNtXGYvf8tWidBhCLaBxaxadmmgfb0yD2r6pWipL6kBJdRWDSlOBczHJT 
/BEJQixwe0RgleThXF9AO9hWepq811WOXUF7Sr/XXrIt3ojzYhVgopqHttf5ofJ3 
93NMpdUU7TC9gmjU8JVp 
=u2Z4 
-----END PGP SIGNATURE----- 

-- 
To unsubscribe e-mail to: [hidden email] 
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted 




If you reply to this email, your message will be added to the discussion below:
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206382.html
To unsubscribe from Can I reload a form based on a parameter query?, click here.
NAML



-----
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-reload-a-form-based-on-a-parameter-query-tp4206066p4206441.html
Sent from the Users mailing list archive at Nabble.com.
-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted