FastFormField nuAutoNumber: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
The FstForm field nuAutoNumber is for storing number sequence that can be incremented for each new record. It is by default a VARCHAR(1000) field but should have the last one as a digit that gets incremented. | The FstForm field nuAutoNumber is for storing number sequence that can be incremented for each new record. It is by default a VARCHAR(1000) field but should have the last one as a digit that gets incremented. | ||
BIGINT works if manually changed at the table level in a MySQL client like nudb (phpMyAdmin) or [https://github.com/webyog/sqlyog-community/wiki/Downloads SQLyog]. | |||
The user table allows duplicates unless the schema has other keys / constraints. The AUTO_INCREMENT parameter is not necessary in the schema definition of the user table. | The user table allows duplicates unless the schema has other keys / constraints. The AUTO_INCREMENT parameter is not necessary in the schema definition of the user table. |
Revision as of 09:21, 16 January 2021
The FstForm field nuAutoNumber is for storing number sequence that can be incremented for each new record. It is by default a VARCHAR(1000) field but should have the last one as a digit that gets incremented.
BIGINT works if manually changed at the table level in a MySQL client like nudb (phpMyAdmin) or SQLyog.
The user table allows duplicates unless the schema has other keys / constraints. The AUTO_INCREMENT parameter is not necessary in the schema definition of the user table.
The Next Number attribute of the Input parameter can be initialised.
The Auto Increment is done in the functions nuAutoNumber() and nuUpdateCounter() in nudata.php.