Subject Re: autoincrement problem
From Charlie <tm@tc.com>
Date Tue, 17 Oct 2023 15:48:07 -0400
Newsgroups dbase.getting-started

yes..  sorry

fl.beginAppend()
      fl.fields["category"].value = form.category1.rowset.fields["cat"].value
                fl.save()
                return

Ken Mayer Wrote:

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