[Solved] Error code -10

Discuss the database features
Post Reply
Harumph
Posts: 1
Joined: Sun Nov 13, 2016 3:07 am

[Solved] Error code -10

Post by Harumph »

I am new to OO Base and have created my first DB.
I get this error code when I try to enter a new record:

SQL Status: 23000
Error code: -10

Attempt to insert null into a non-nullable column: column: SupplierName table: Suppliers in statement [INSERT INTO "Suppliers" ( "Category","Sub-Category") VALUES ( ?,?)]

I am guessing it has something to do with the Primary Key, but can't figure out where I screwed up.

ANy help out there ? :?:
Thanks
Last edited by Harumph on Sun Nov 13, 2016 5:14 am, edited 1 time in total.
OpenOffice 4.13 Macintosh 10.12.1
FJCC
Moderator
Posts: 9280
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Error code -10

Post by FJCC »

How are you entering the data, from a form or directly into the table? What have you set to be the primary key? Can you up load the odb file? There is an Upload Attachment tab just below the box where you type a response.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply