Missing User Level ID when it's autoincrement

gcjesus89 · Post by **gcjesus89** » Wed Dec 10, 2014 12:21 am

Hi, i have a basic User Level Table empty :
ID: PK, not null, autoincrement.
UserLevelName: Not null.
This table has been created using the option "Create tables" in the "Dynamic User Levels" tab in "Advanced Security - User Levels".

My page is configured to not showing the ID column cause it's autoincrement and to prevent to try adding repeated value.

in the web page my Add form is like this (just as i want):

User Level Name: _______________
Permissions: Add () Edit () .... .... ....

I filled all the required fields and i get this message: "Missing User Level ID"
I though it was because Required attribute was checked in the ID field. i desactivated it, regenerate all the code and that message is still appearing. I don't know why if it is an autoincrement field. I'm using the v11

Thanks for you help.

mobhar · Post by **mobhar** » Wed Dec 10, 2014 9:34 am

Try to put this following code in "Row_Inserting" server event:

unset($rsnew["ID"]);

Post by **Webmaster** » Wed Dec 10, 2014 9:40 am

gcjesus89 wrote:
My page is configured to not showing the ID column cause it's autoincrement and to prevent to try adding repeated value.

How did you "configure" not to show? If a field is properly detected as autoincrement and is the primary key, the checkbox in the "Add" column of Field Setup page should be disabled. If not, post the database type and the CREATE TABLE statement of the table.