 |
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.
|
|
|
|
|
|
|
|
