Constrain using a Variable?

[Digitalbrit]

Hello. Does anyone know if it is possible to use the constrain found set but to specify criteria as a variable?

pseudo code example ...

action omit records | criteria mytable::myfield: [$$variable]

What I suspect is happening is the literal "$$variable" is being entered into myfield rather than the contents of $$variable.

I'd prefer to get this working rather than using enter find mode, set fields and omit records ... I'll spare you the details.

So, can you use a variable to constrain a found set? If so, how??

Cheers

Tim

[comment]

What I suspect is happening is the literal "$$variable" is being entered into myfield rather than the contents of $$variable.

That is correct. Stored criteria can use only constants, not variables or calculations. Why can't you use Set Field[] like the rest of the world does?

[Digitalbrit]

Thanks for clearing that up.

Sorted now and way and yes I used setfield.

Cheers