Can't save table

asked 2019-01-11 11:14:08 +0100

Pavel_47 gravatar image

updated 2019-01-11 11:54:01 +0100


I'm wondering is database engine a mature product in LibreOffice. Another issue: I can't save a table. The tool claims insertion of a value in a column where it is not necessary. Moreover when I try to do it, I can't: annoying message appears each time when I try to do something.

Any comments ?


P.S. Here is settings of the table image description

edit retag flag offensive close merge delete


Could you please provide at least some information to understand your question, like e.g. what could possibly "The tool claims insertion of a value in a column where it is not necessary" mean - some message? when you do what exactly where exactly (on which database, with what version, how was it created, using what version)? or another bit: what message could be annoying to you? and what is that "something" you try to do when you are shown that message?

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-11 11:27:35 +0100 )edit

The error says it's Date column that is non-nullable, but is left null. So it's the Date column data that is required to see the problem.

Also move the data from the answer here, and remove the answer please

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-11 12:11:30 +0100 )edit

Thanks Mike,

Here is what happens when I try to do something. image description Indeed the 1st recording has no value in the "Location" column. But according to my settings this column doesn't require that "Location" must be filled. Moreover, this error message appers upon whatever action, ... so I can't fill "Location" field. Sincerely

Pavel_47 gravatar imagePavel_47 ( 2019-01-11 12:24:14 +0100 )edit

Yes, it was the case: I misinterpreted the error message. The issue is resolved: I accidentally add a record and didn't fill any fields. And it was the reason of the annoying message. By the way I didn't find a method how to remove accidentally added empty records. During my researches on how to remove it, the tool suddenly closed ... and wheh I reopened it, the empty record was removed.

Pavel_47 gravatar imagePavel_47 ( 2019-01-11 12:31:04 +0100 )edit