Jump to content

script to ommit records


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

Recommended Posts

I have a db that has names, comments and a status for each. Looking to run a script that will ommit the records that do not have any info in the comments or status fields.

help would be great

FileMaker Version: 5

Platform: Windows 95/98

Link to comment
Share on other sites

Good morning,

This was made using FM6, but it should work fine for you.

Here are two methods....

One loops through all your records and omits any that have a blank in either field.

The other finds all records with either field blank, then shows the ommitted records.

I'm not sure which is faster, since I only created 6 records, but I suspect that the "find and omit" will be faster for large numbers of records.

Let me now if this is not the solution you need, or if I misunderstood the question.

Paul smile.gif

FileMaker Version: 6

Platform: Windows XP

Omit Records with blanks.zip

Link to comment
Share on other sites

I cant seem to find the [exit after last,next] part for the end of the loop. Right now the script continues to run until I esc. I'm using fm pro 5.5 v1 so i dont know if it isnt present in the version or what?

any suggestions?

FileMaker Version: 5

Link to comment
Share on other sites

This topic is 6479 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
 Share

×
×
  • Create New...

Important Information

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