Insert Text command for search

[dangkevin]

Hi all,

I have been trying to using the Insert Text command in a find to set the field in Find Mode and then do the find. The steps are like this:

1) Enter Find Mode

2) Insert Text [table:targetfield;$variable]

3) Perform Find

In the second step, when I tried to use the variable, it looks like this:

2) Insert Text [table:targetfield;"$variable"]

It add the " " with the $variable and cause the $variable text to be insert instead of the value inside the variable itself.

Does the Insert Text Command second field accept only string?

If the Insert Text Command only accept string in the second field, is there a work around for this to do a search with a variable?

Any help would be appreciated.

Thanks.

Edited February 8, 2009 by Guest

[LaRetta]

If the Insert Text Command only accept string in the second field, is there a work around for this to do a search with a variable?

Insert Text[] pastes a text value into the field, as you've found out. It also requires that the field be on the layout and will only work when inserting into a text field (won't work for dates or numbers). Instead, use Set Field[], such as:

Enter Find Mode [ uncheck pause ]

Set Field [ table:targetfield ; $variable ]

Perform Find [ ]

Also, when using a variable, you can not use stored find requests which also only accept static data or field values. Set Field[] is usually a better choice and should always be used whenever possible.

LaRetta :wink2:

[dangkevin]

Thanks LaRetta, that works. ;)