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

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

Recommended Posts

Posted

I'm trying to construct a simple script to clear a text field in the last 10 records of a 20-record table, but the script always clears the field in all of the records.

Enter Browse Mode []

Go to Record/Request/Page [No dialog; 11]

Loop

Replace Field Contents [No dialog; Table::Field; ""]

Go to Record/Request/Page [Next; Exit after last]

End Loop

This is my first attempt to use looping in a script, so I've obviously missed something very basic. I just haven't been able to locate a relevant example to get me on the right track.

Posted

The "replace field contents" step replaces everything in the found set.

Use your script and change "Replace Field Contents" to "Set Field[Table::Field; ""]

Hope that does it!

Posted

Although your loop will execute quite quickly you can still keep the script you are using but use the "omit records" script step to leave out he first 10 records and then use the replace.

Like I say 10 records is pretty quick, but 10,000 would be quite different.

Only a "heads up" on technique.

This topic is 6765 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.