Subject Re: autoincrement problem From Ken Mayer <dbase@nospam.goldenstag.net> Date Tue, 17 Oct 2023 11:39:23 -0700 Newsgroups dbase.getting-started On 10/17/2023 9:10 AM, Charlie wrote: > OK..  I put it into a program to run only once which I didn't understand before. > >   close tables >>> set procedure to :dUFLP:DBF7File.CC >>> oDBF7File = new DBF7File( "floss.dbf" ) >>> oDBF7File.SetNextAutoIncValue( 293 ) >>> oDBF7File = null >>> close procedure :dUFLP:DBF7File.cc >>> return > > The button event is essentially.... > > fl.fields["category"].value = form.category1.rowset.fields["cat"].value > fl.save() > return Are you using beginAppend() before this? fl.beginAppend() ??? > I also tried this in command after running the little program line by line: > > use floss.dbf > append blank > edit > > But it always reverts back.  This time lr was 5 as it was probably my 5th time.  Hmmm  a 5th sounds pretty good right about now!  :) Is this after you had set the next autoincrement value? > Possibly it has something to do with the table as this is the directory that was trying to create tables as .db instead of .dbf. > > The reason I am using the autoinc in the first place is because i am using bookmarks a lot in this program. > Bookmarks don't need autoincrement fields ... they are their own marker and independent of anything. Your responses are hard to follow sometimes, because you jump around a lot. Try going step-by-step, and explain EXACTLY what you're doing. Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm dBASE DOS to Windows Tutorial: http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm