FastFormField nuAutoNumber: Difference between revisions
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
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]. | 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]. | ||
If the code in '''nubuilders.php''' is changed to use '''BIGINT unsigned''', the older '''VARCHAR(1000)''' still works. | |||
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:36, 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.
If the code in nubuilders.php is changed to use BIGINT unsigned, the older VARCHAR(1000) still works.
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.