Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- dBsee 4.6 - The Library - Norton Guide http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]

   The key fields of Primary keys will be evaluated in the data entry forms,
   depending on the mode of operation that is set in in this environment.

   The modes of operation that can be selected for these key fields are:

     . No control

     . Automatically increasing

     . Entered but not repeated

No control

   No control will be performed on the data entered. Any value is accepted.

Automatically increasing

   Using this mode, the key field's value will be automatically increased
   upon each insertion in the file. The field cannot be edited on the form,
   but its value can be displayed.
    The step with which the value is increased, is set using the Key step
   option (see next paragraph).

Example:

   A data entry manages input on a Customers file. The CusCode is a primary
   key field (type character, length 5). Upon the insertion of new customers,
   the customer's code is computed by the system (from 00001 up) and cannot
   be edited.

   dBsee also handles automatically increasing codes on composite indexkeys.
   The automatically increased code is computed for the last field in the
   indexkey expression.

Example:

   Primary key CatCod+ArtCod with CatCod (Article's category code)
   entered, and ArtCod automatically increasing.

   The system will generate a progressive code within the same category:

     CatCod  ArtCod
      FOOD    0001
      FOOD    0002
      FOOD    0003
      SOFT    0001
      SOFT    0002
      SOFT    0003

Entered but not repeated

   The value entered is verified against the data contained in the file, and
   no duplicate entries are allowed.

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson