script to ommit records

[wenzelj]

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

[Damocles]

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

FileMaker Version: 6

Platform: Windows XP

Omit Records with blanks.zip

[wenzelj]

is there anyway that you can allow me access to see the script steps or how to put it in my db. the script seems to do what I need it for but there is no way to get access to it.

thanks.

[Damocles]

This should do it. Here are pictures of the scripts, and I re-inserted the FM file. Check again to see if you have access to the scripts.

(Ignore Layout #3 and any reference to "Serial". I'm playing with this file.)

Paul

Omit Records with blanks.zip

[wenzelj]

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

[wenzelj]

sorry about the last post. Missed the check box.

thanks for everything

[Damocles]