Script Delete Blank Records

[sicSRT8]

How would I go about setting up a script to auto delete records with a a blank value?

[mr_vodka]

I guess you can do this on layout load, but you can find the records that are empty. Something like... Be careful with the error trapping.

Enter Find Mode []

Set Field [ YourField; "=" ]

Set Error Capture [On]

Perform Find []

If [ Get (LastError) <> 401 ]

Delete All Records

End If

Edited April 3, 2009 by Guest
fixed error trap

[LaRetta]

If [ Get (LastError) = 401 ]

Hi John, I believe you mean otherwise - only delete if any records found? :wink2:

[mr_vodka]

Hi LaRetta. Yes that is definitely what I meant. Thanks for the quick and and catch.