search with variable over foreign key

[knopf]

Hi.

Somehow I can't get this to work: I have two tables: A, B. Table A is related to table B via the key X, which is of type Text.

I would like to display all records of table A that equal to the text "dummy". In SQL this is equivalent to "select * from A where X = 'dummy'".

I can get this to work as long as I enter the text directly in the find window in the script editor, however, I can't get it to work when I use a script parameter or a variable.

How do I get it down statically:

// works

A::X =dummy

How do I want to get it done:

// doesn't work - I checked, it's the right parameter there

A::X =Get(ScriptParameter)

// doesn't work either

Set Variable ($dmy, Value:Get(ScriptParamter))

Find ( A::X = $dmy)

This works, but I would like to do a direct query:

Enter Find Mode[]

Set Field ...

What can I do, please?

Thanks.

[knopf]

Btw. this does also not work

Set Variable[$dmy, Value:"Dummy"]

Perform Find[A::X =$dmy]

sorry, but I have no clue...

[comment]

Perform Find[] only works with static (stored) criteria. Try:

Enter Find Mode []

Set Field [ A::X ; "Dummy" ]

Perform Find []