Created a new DB but I cant enter info

Discuss the database features

Created a new DB but I cant enter info

Postby Miked0l » Fri Mar 24, 2017 5:36 pm

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
Miked0l
 
Posts: 1
Joined: Fri Mar 24, 2017 5:24 pm

Re: Created a new DB but I cant enter info

Postby Villeroy » Sat Mar 25, 2017 12:24 am

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26385
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Created a new DB but I cant enter info

Postby UnklDonald418 » Sat Mar 25, 2017 4:58 pm

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.
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.6 & LibreOffice 6.1.1.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1059
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Base

Who is online

Users browsing this forum: No registered users and 2 guests