Subject Re: BOOKMARK From Charlie <tm@tc.com> Date Mon, 30 May 2022 15:40:48 -0400 Newsgroups dbase.getting-started OK thanks.  As long as they don't duplicate should be fine.  I am using it as a type of bookmark using both oodml and xdml.  I don't think gaps will affect my use.  Thanks this will come in handy! Akshat Kapoor Wrote: > 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