I have not worked with Base much at all, but I understand the basics. I have created a table and a form. I don’t understand how to enter new records from the form that I created. I have entered values into the fields I created, but it seems that those values aren’t getting entered into the record/row. When I try to save the record, I get the error below.
I’m not sure what I’m doing wrong.
I guess not reading the message.
We can’t see your table. But is there a mandatory field, might even be the id, wich is mandatory, but not given in your Insert-record ?
.
If you checked this, please add Table-definition and your INSERT Command.
I read the message, but I don’t understand why I am getting the error. I am populating the fields. I checked the table and none of the fields in my table are mandatory. How do I auto-increment the id so that the value is not null?
I don’t know what this means. I’ve used insert statements on a limited basis when adding data to a table from another table. I don’t know how to apply that here. Are you referring to a script to add the values to the table?
That is a field property when creating the table. Sounds like you may need much more help than just this in the future. Here is the link to the Base Manual:
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide
For the setting of auto increment, see the v7.3 Base Guide, Chapter 3, Creating Tables (about page 130)
Will be the column “Record No”, which isn’t set, but should be primary key. Change this to AutoValue. Have a look at the properties of the field in table editor. It is the first entry if you have chosen INTEGER for the field.
See timecode 4:50 minutes of this video:
If you used some, show it.
But I guess “your” insert-statement is generated by the form you created, so you could try whith a screenshot of the form or the open form navigator.
.
Usually it is better to upload the .odb-file, if there is no personal data inside, as most helpers know where to look.
Otherwise you will often get additional questions… (If you would know wich photo we need, you’d probably also know where to fix your problem…)
Very informative. Thank you.