Created a new DB but I cant enter info
Created a new DB but I cant enter info
I created a new DB and created a table and a form using the wizards, I go to enter info into the form and keep getting error messages (Error inserting new record) SQL status 23000 Error code 10. I have no clue what to do to fix this as ive tried several times. Any suggestions?
Open Office 4.1.2 on Windows 10
Re: Created a new DB but I cant enter info
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Volunteer
- Posts: 1548
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Created a new DB but I cant enter info
Does your table have a Primary Key?
The safest approach is to use the default Primary Key, which is an integer named ID set to auto increment.
Also note that the Primary Key field must be on your form. It doesn't have to be visible, but it must be there if you want to use the form for data entry.
The safest approach is to use the default Primary Key, which is an integer named ID set to auto increment.
Also note that the Primary Key field must be on your form. It doesn't have to be visible, but it must be there if you want to use the form for data entry.
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
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11