Jump to content
Sign in to follow this  
Mandu

Flagging the found set

Recommended Posts

I need to set a flag field in each record of a found set to 1; then set the same flag field to 0 in the omitted set. The number of records is around 10000 and growing, and the found set is 10-20 records. What is the quickest way to do this? BTW - most records in the omitted set will already contain flag=0.

It needs to be fast.

(The reason for doing this is that I'm going to tell MS Word to select all records having flag=1 and generate a form letter - Word's ability to select FM records is limited to matching on a constant.)

Share this post


Link to post
Share on other sites

By script you would need to show all records, then loop over all of them to set the field to zero, then perform the find, and then loop over those set the field to 1. But a quicker way would be by calculation field, using If or Case.

Share this post


Link to post
Share on other sites

By calculation field, do you mean something like

If["WorkshopID"=g_WorkshopID,1,0] ?

Share this post


Link to post
Share on other sites

Yes, provided that your only find criterion is the If condition you state.

Share this post


Link to post
Share on other sites

The danger in flagging a found set this way is in multi-user files. If multiple users have different found sets and each try to flag records, they will walk all over each other's found sets.

-bd

Share this post


Link to post
Share on other sites

The danger in flagging a found set this way is in multi-user files.

Thanks for pointing that out. Even though there will only be one person using these files, I would guess that MS Word counts as a second user. This is obviously not a very good way to pass a set of records to Word's Data Merge manager.

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  

×

Important Information

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