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

-----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".


> 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.

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.

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 ...

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: 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