Script Not Working (finding empty records)

[skrying]

I was running this script yesterday, and I could have sworn it was working... now it doesn't.

Show All Records

Go to Record/Request/Page {First}

Loop

  If [isEmpty {Comic::Notes}]

    Omit Record

  End If

  Go to Record/Request/Page {Next; Exit after last}

End Loop

Show Omitted Only

I want it to find & display all records where Comic::Notes is empty, but it doesn't seem to find everything, and occasionally finds things it shouldn't.

Any ideas?

Edited October 26, 2005 by Guest
clearer subject

[Breezer]

Try this simpler method of finding empty fields.

Go to the layout with the notes field, enter find mode. In the notes field while in find mode, type the equal sign "=" without the quotes and this will find all the empty fields.

Now go to scriptmaker, and use:

Perform Find []

and click on retore and your script will appear as:

Perform Find [Restore]

where restore is comic::notes:[=] in the specify find request window.

You can then set up error capture.

Edited October 26, 2005 by Guest

[skrying]

Thanks for the quick reply!

So that works like you said, but what if the Comic::Notes field was a value list, and the only way to enter information in the layout was through a pop-up list? (because then I can't enter the =)

[edit]

Also, what if Comic::Notes was a number? Then entering the = in the Find view won't work.

Edited October 26, 2005 by Guest

[skrying]

Also, suppose I'm viewing a layout which shows, say, a Member table and related info from a Roles table in a portal. So we have

Member(ID)

Roles(ID, memberID)

as our schema. How would I find all Member records that don't have an associated Roles record? I was trying to use the script above to do this -- i.e. If [isEmpty{Roles::ID}]

[skrying]

Well, what do you know... apparently Omit Record will advance to the next portal. That was my problem .

[Sanjai]

Yes, omit record makes the subsequent record as a current record. Hence by using go to next record after the omit record, you would not be able to check all the records.

Your script should be

show all records

Go to Record/Request/Page {First}

Loop

If not [isEmpty {Comic::Notes}]

Omit Record

else

go to next record()

End If

if(status(currentrecordnumber)=status(currentfoundcount))

If not [isEmpty {Comic::Notes}]

Omit Record

End If

exit script

end if

End Loop