Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4914 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I need a script to search for a text string, but I only want results returned if the string occurs within the first 50 records of the table. For practical purposes, each record consists only of a text field. I'm probably overlooking something, but I can't think of a simple way to limit the search. (BTW, I have no control over the fields defined in the table, so adding a "search me" indicator is not possible.)

Thanks in advance for any help.

Posted

Find the 50 records, then constrain. E.g.:

Show all records

Go to record 51

Set error capture(on)

Omit multiple[no dialog;99999999]

Constrain Found Set

Posted

Omit multiple[no dialog;99999999]...

"Omit several records from the found set, starting with the current record ... "

That works perfectly. I had never used Omit Multiple Records before.

Thank you.

This topic is 4914 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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