Subject Re: BOOKMARK From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 30 May 2022 11:55:17 +0530 Newsgroups dbase.getting-started Good Morning Charlie, > Hi Akshat..  I saw found this old post of yours.  I am in the same boat right now because I use xdml for functions.  I am trying the recno field.  But I don't understand your comment....'> The only fault is that if you delete some rows then renumbering of this >> field will not take place.' > > I am not finding that happening.  Could this be because the last record is deleted? In XDML if you deleted some rows and packed the table the recno() value of that row used to change automatically. It was dynamic in nature. There is no equivalent of recno() in oodml In dbf files autoincrement is the nearest that you have to recno. As the name says, the value is incremented automatically. So no chances of duplicates or hassle of generating a next number. Hence ideal for use with findkey(). Create a temporary table with an autoincrement field. Add 2 or 3 rows. Browse You will find all recno fields in ascending order. Now delete last row. Pack Append another row Now browse and check the values There will be a gap in values. And these values cannot be changed. Regards Akshat