Delete last row of table...

[stlrain95]

Need to delete the last row of a table.

I know i need to use recno(), but in what capacity?

 

[Mike Gagnon]

You can use the renco(), only if you know what it is. If you need to delete the "last entered" record, try this:

SELECT myTable
SET ORDER TO && Puts it in the order it was entered
GO BOTTOM
DELETE

 

[DSummZZZ]

Just for clarification, RECNO() is the current record number. RECCOUNT() is the total number of records. Keep in mind, deleting a record does not physically remove it from the table either, it just flags the record as 'deleted'.

Dave S.

 

[stlrain95]

Understand, just needed to get the last one out. I "PACKED" afterwards so I could get that out.

Thank you again for all the help.

 

[Neil Toulouse]

...and to clarify further RECCOUNT() includes those records marked for deletion regardless of the state of SET DELETED "I love work. I could sit and stare at it for hours..."