Query "Starts With Parameter"

vinsnash

I've copied a query I want to use slightly different from the original. I've changed the attributes displayed and the attribute to asked for at run time with a "starts with".

Everything works as expected but the label on the pop up for the "ask at run time" parameter remains the same as the original. How is that changed or do I have to create the query from scratch to change that?

5.3/1528

Vins Nash

[deleted]

Edit the query and modify the caption field.

vinsnash

I don't see a "caption field" anywhere in the query edit dialog for the run-time parameter pop up. I don't see it on the first screen. In the details section I can modify column headers. I don't see anywhere that I can modify the label which is the attribute name of the attribute being used for the selection criteria.

Originally it was

UntiTable.UnitCode Starts with <Ask at run-time>. The label on the pop up for entering the run-time parameter was "Unit Code".

That was changed to

UnitTable.DrillState Starts with <Ask at run-time>. The label on the "pop up" is still "Unit Code" although the query works selecting on UnitTable.DrillState entered.

rocketman

edit the query to be

UntiTable.UnitCode Startswith ?'replace this with whatever you want'

Ask at runtime will simply use whatever the attribute is called whereas enclosing some text in single quotes will put the text on the screen in the dialog box ie:

UntiTable.UnitCode Startswith ?'Enter the code'

vinsnash

Had no idea that was a possibility. The drop down 'criterion' doesn't show a "? 'Any Text'" possibility.

The problem was after copying and modifying the query 'Starts with' and '<Ask at Run-time> continued to use the name of the previous attribute used as the test criteria for the pop label.

It was easy enough just to recreate the query from scratch which then used the correct attribute name of the new criteria.

It even changes "DrillState" to "Drill State" which is a nice touch that I don't believe I've seen documented anywhere. I just noted it so I've continued to structure attribute names that way.

Thanks