Delete every record in a table after the 40th record

[eddyb2]

Bit of a strange one. I run an import from an external source which gives me around 260-270 records.

i am always only interested in the first 40 records.

The import is scripted. Is there an easy way to add into the script a command to delete every record after the 40th record? I am not quite sure how I would go about this other than going to the 41st record, delete record, and looping.

Is there a way to omit all records after 40 then show omitted, delete all ??

Thanks

Ed

[mr_vodka]

How about:

Show all records

Go to Record [ First]

Omit Multiple [40]

If [ Get ( FoundCount ) ]

Delete All Records

End If

[eddyb2]

Omit Multiple... New one for me but works great thanks!

What is the reason for IF(Get (foundcount)) in the script?

[mr_vodka]

If there are only 30 records for example, there will no found set, so no point in trying to delete.

[bcooney]

Does the sort order matter? I mean, which 40 to keep is determined by creation order?

[mr_vodka]

I just assumed because the OP said first 40 records in each table.

[bcooney]

Well, you know what Felix would say...