` Printed Icetips Article

Icetips Article



Par2: Manual control of autoincrement/autonumber keys
1998-05-18 -- Steve Parker
 
This is particularly appropriate for a form not called by a browse.

Where TES:SysID is the field to be autonumbered:

WindowManager Method Executable Code Section
  PrimeFields
    ()
       If ~TES:SysID
         Access:TestFile.PrimeRecord 
         Access:TestFile.PrimeAutoInc 
       End 

You may wish to try the TryPrimeAutoInc method.

Strictly speaking, the test for the value in the field may not be necessary.

In the Cancel button's Accepted, Before Generated code embed:
  Access:TestFile.CancelAutoInc



Printed May 7, 2024, 10:33 am
This article has been viewed/printed 35111 times.