Takes one parameter, a top query destination variable
Description:
Used to merge multiple records in a work query into a single string. Often times this command is very useful for creating the DB attributes for dynamic drop down menus using the [!] Limited Selection List.
Usage:
[New] DropdownMenuOptions | RawStream$
Example:
Building a drop down menu with a dynamic number of options using the work query:
Rem 'Get our data
LoadTable "Comp.Charge.Type"
KeepIf "Comp.Charge.Type.IsAdhoc"
EndRem
Rem 'Build the dropdown menu options
WorkWith "Comp.Charge.Type"
KeepFields "Alias Name"
NewFields "Output"
'Formatting the [!] Attribute with '{Field01} Field02' will create the option tags with values different than the text being displayed
Build "Output", "`, {", "Alias", "`} ", "Name", "Alias" 'format each work query to contain the string of
KeepFields "Output"
End WorkWith
[New] CSVFeeOptions | RawStream$
EndRem
Rem 'Build the dropdown menu
NewFields "MyDropdown"
SetNew "MyDropdown#Attr", ("`[!] " & CSVFeeOptions)
EndRem