Re: [libreoffice-users] libreoffice base: building query, need help with input parameter development

*correction* I can't find a way to get a form to execute a query.

On Aug 27, 2016 6:55 PM, "Alanon SR3" <alanon.sr3@gmail.com> wrote:

> thank you Bruce.
>
> I have the Query setup as well as the stand alone or unbound form with the
> listbox in it.
>
> I find a way to get the form to execute the Query.  In the controls
> window, I am finding where actions can trigger, but it only appears to
> allow me to add macros...I can't type anything in the text boxes next to
> the event items.  I've also tried adding a push button hoping a wizard
> would come up to build the action...no such luck.
>
> I'd prefer not typing in all 12+ categories in the Query criterion field
> as more categories will be added in the future on an as-needed basis.  Plus
> some are rather longly named.
>
> Can you or anyone assist with getting a form to execute a query?  The
> "help" was more like a dictionary than a how-to.
>
> thank you in advance,
> alanon
>
> On Aug 27, 2016 6:31 PM, "Bruce Hohl" <brucehohl@gmail.com> wrote:
>
> > > What would I need to write as a criteria so that when the QUERY is run,
> > it
> > prompts the user to select from a listbox
> >
> > You must create a form to use the List Box control.  If you really only
> > need a query you can add the choices to the query parameter name.  For
> > example: SELECT "F1", "F2" FROM "Table1" WHERE "F1" =
> > :enter_dog_cat_or_bird (see simple attached example).
> >
> > From the installed help see: Contents > Database Functionality > General
> > Information > Working with Queries (Query Design / Parameter queries) and
> > Working with Forms (Form Controls / List Box).
> >
> >
> > On Sat, Aug 27, 2016 at 3:14 PM, alanon <alanon.sr3@gmail.com> wrote:
> >
> > > Hi,
> > > Thank you in advance for your help!
> > > I'm trying to build a query that would list the records in a database
> > > where
> > > the user selects from an existing list of categories.
> > >
> > > IE
> > > there are 12 existing categories, each with a bunch of records.
> > > the user wants to review just the records under the category "gas", but
> > > he
> > > doesn't know that exact category name so he needs a listbox to show his
> > > existing categories to select from.
> > >
> > > What would I need to write as a criteria so that when the query is run,
> > > it
> > > prompts the user to select from a listbox so he can review the records
> > > for
> > > that said category?
> > >
> > > Thank you.
> > > Alanon
> > >
> > >
> > >
> > > --
> > > View this message in context: http://nabble.documentfoundati
> > > on.org/libreoffice-base-building-query-need-help-with-input-
> > > parameter-development-tp4191909.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-uns
> > > ubscribe/
> > > 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

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