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

Robert,

Sorry not to have been back sooner  - I got distracted by some more important work than managing my 
wine.

I've worked out now how your  filter_without_macros works now, and am in the process of adding the 
procedures into my database. 

I've also found your Base handbook on the LO website. It's really useful, and a pity it wasn't 
there when I started working with Base (some years ago now).

So double thanks.

Best regards,

Peter
mailto:lo@ptoye.com
www.ptoye.com

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


> 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: [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-tp4206066p4207833.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