How would you delete multiple records in a script? Also, how would you know where in the table you are? I see no funtion that allow you to move the record counter to the top of the file. Using SQL deleting records is easy enough. But in FM 6, do I have to find the records I want first, then delete them?

An example: Say i wanted to delete all the records that didn't have a company name. So Company Name field is blank.

Thanks..

Delete All Records is the command -- it actually deletes the FOUND set of records. So yes, find first, then delete all.

Another option would be to loop through and delete each record that matches your criteria.

Move the record counter? Uh... Go to record(e.g., First, Last, etc.)

Hey thanks.. I missed the Go To Command. Thanks again.