OpenOffice Base Table Data View << Error inserting the n>>

Discuss the database features
Post Reply
LTCF
Posts: 1
Joined: Thu Apr 12, 2018 8:47 pm

OpenOffice Base Table Data View << Error inserting the n>>

Post by LTCF »

Greetings,

I recently migrated from MS Works DB 1995 to OpenOffice.

After creating an OpenOffice Base and trying to insert a new record I get the following error message:
Image
How can I resolve this error and add my new record?

Regards,

Dennis
Apache OpenOffice 4.1.5 AOO415m1(Build:9789) - Rev. 1817496
Windows 7 Home Premium 64 bit
UnklDonald418
Volunteer
Posts: 1548
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: OpenOffice Base Table Data View << Error inserting the n

Post by UnklDonald418 »

The error message is telling you that it can't add the new record because one of the columns in your new record has a null value, and the database has been instructed not to accept a null value for that column. Looking at your upload I suspect it is the ID column.
The best solution would be to open your table in the Edit mode and looking near the bottom left of the window change Auto Value to Yes for the ID column.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Post Reply