Jump to content
Sign in to follow this  
dangkevin

Insert Text command for search

Recommended Posts

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 by Guest

Share this post


Link to post
Share on other sites

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:

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Tattwam 
×

Important Information

By using this site, you agree to our Terms of Use.