Retrieve Recno() of a newly inserted row into a table

What would you do with recno() It is not a saved value. Instead it is a calculated value (calculation is done by physical position of a record which may change).

If table is not used by any other user (opened exclusively) then you could get it by:

select top 1 recno() as Oid from [TableName] order by 1 desc

Or even in case of multiple users a stored procedure might do the insert and return current recno() which is the recno() it inserted.

But it is not valid as an objectId (Oid menat that ). The moment table is packed and there is a deleted record(s) before it then it would change. Sorting on a particular order would also change it. Anything that touches physical order of records would change it

Instead use a column or a combination of columns that uniquely identifies a row within a table (primary key).

Dear dni,

do u mean insert command will insert a new record immediately after the current record and not at the bottom e.g. if my dbf contains 100 records and i use following code

use tmp.dbf

go 50

insert into .........

is it not possible to find the new record no. with the following command

calc max(recn()) to oid

or

go bottom

oid = recn()

use tmp.dbf

go 50

insert into .........

New record number is 101 (or greater than 101 if there are multiple users inserting records at the same time).

in a multiuser environment.

This one wouldn't even work in a single user environment:

because it's dependant on current order of the table.

Dni,

I think you know that it's a command that should be avoided even in single user situations and would not work in multiuser.