Needing to move a query from one section to another section choosen by the user.
Need to prompt the user with a lookup drop down list box, and in the list box i would like the keywords to appear.
They will select the query they want then run a agent to move it to a different section, which will be in the drop down list.
Subject: RE: Dblookup using with @prompt
You want to use @DbLookup to retrieve a list of values, then use @Prompt to let the user choose from the list.
Questions like this always make me nervous, because this is really, really, easy stuff you’re asking about. All you have to do is read the documentation of the functions, and provide the arguments in the correct order. This is the easy part. Here’s an example of doing that.
_choices := @DbColumn(“”; “”; “nSubjectAreaCategory”; 1);
_resp := @Prompt([OkCancelListMult]; “choose, you!”; “choose your category”; “”; _choices);
@Prompt([Ok]; “your choice revealed”; "You chose: " + @Implode(_resp; ", "))
Your description of what you want to do with the choices once the user has made them is vague, and that’s the complicated part. You haven’t described the task well enough for me to address it. Are they selecting documents from a view, or editing a document, or just viewing a document? Do you want to prompt them once for all documents, or ask them separately for each document? Can you get all the choices with a single @DbLookup, or do you have to read them from multiple sources?
If the above does not solve your problem, we need more information about what you’re doing. If you’re not sure what information to supply, the C R I S P Y document might help you.
Useful blog: Best Practice Makes Perfect