When saving an entry on my form, I recieve the following error. What am I missing? I'm stuck.. [closed]

asked 2020-12-28 05:33:11 +0200

kitchenguy22 gravatar image

image description

SQL Status: 23000 Error code: -10

Attempt to insert null into a non-nullable column: column: Customer Type table: Tbl_Customer List in statement [INSERT INTO "Tbl_Customer List" ( "Address","Bird Dog","City","Date of First Contact","Email","Farm","First Name","Last Name","Loan Type","Outreach Lvl","Phone Number","Property type","Refered By","Zip") VALUES ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?)]

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by Ratslinger
close date 2020-12-28 05:51:16.105052



This is nothing more than an elaboration of this question -> Help! I am a Newbie at databases. Can anyone give me a general idea(in layman's terms) of what this error means?.

Please do not duplicate questions but rather Edit your original question (lower right corner of question) and add the information. Then delete this question.

Ratslinger gravatar imageRatslinger ( 2020-12-28 05:51:10 +0200 )edit


Also just noticed, you are not working with LibreOffice but rather OpenOffice. You may want to post here -> AOO Forum

You can try here but people answering may not have AOO installed.

Ratslinger gravatar imageRatslinger ( 2020-12-28 05:59:32 +0200 )edit


After more looking, it appears your form list box for Customer Type may not be set correctly. Cannot tell from images. Best to actually post a sample in the other question.

Ratslinger gravatar imageRatslinger ( 2020-12-28 06:11:41 +0200 )edit

this is not LibreOffice you are using OpenOfice

kimy747 gravatar imagekimy747 ( 2021-01-03 21:56:25 +0200 )edit


Strange for you to simply repeat what I stated in my second comment.

Ratslinger gravatar imageRatslinger ( 2021-01-03 22:02:12 +0200 )edit