|
Kheri_ Wanderer
Joined: 11 Oct 2005 Posts: 58
|
Posted: Tue Feb 14, 2006 12:18 am
Delete Last Record |
how do i delete the last record in the database?
or atleast change it's name. |
|
|
|
MattLofton GURU
Joined: 23 Dec 2000 Posts: 4834 Location: USA
|
Posted: Tue Feb 14, 2006 1:22 am |
Assuming that you do not know the exact position nor the content of the record, you will have to use the following:
#DBFIRST //ensures you start at the beginning
RecordNum = 0 //syncs your counter
#WHILE (!%null(%rec)) {#add RecordNum 1;#dbnext}
#DBDELETE @{Recordnum}optional 2-character identifier of database |
|
_________________ EDIT: I didn't like my old signature |
|
|
|
Kheri_ Wanderer
Joined: 11 Oct 2005 Posts: 58
|
Posted: Tue Feb 14, 2006 4:04 am |
well last, record i mean.. that last row, that last last 'last' row. on my 'list'
1eq
2eq
...
36eq - last row, record.
that's what i'd like to rename/delete. i can do this to other rows. using edit, #DBDELETE 4eq.
but that last row.. i can't figure out a way to make it's number -36eq- change. and i cannot delete it. |
|
_________________ Old |
|
|
|
Slaem Apprentice
Joined: 20 Sep 2005 Posts: 135
|
Posted: Sun Feb 19, 2006 5:31 am |
Within the db module, you should be able to select the row and either right-click or select from one of the menus to delete the row.
|
|
|
|
|
|