I am using Open Office 3.0 and simply want to print address labels for Christmas cards.
I have a label file that accesses an odb address file.
I successfully have entered 39 records, but every time I try to add the next record, I get an error message: Error inserting the new record
I can click on ok or more. When I click on more, I see two errors in the error list. Under description, the first one says Error inserting the new record
The second one says SQL Status: HY000
That is all the error info I get. I have no idea what the problem is. I am using Windows XP.
Can anyone help?
[Solved] SQL Status: HY000
[Solved] SQL Status: HY000
Last edited by BPillard on Fri Dec 19, 2008 2:27 am, edited 1 time in total.
OOo 3.0.X on Ms Windows XP
Re: SQL Status: HY000
In OOo Base all table must have a primary key, your table has it?
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin
Re: SQL Status: HY000
No it doesn'n have a primary key. How can I add one?
OOo 3.0.X on Ms Windows XP
Re: SQL Status: HY000
Open your table in edit mode, right click on gray square before field which contain non recurring values for record.
If you don't have such field, create new one with integer type, with autoincrement settings.
If you don't have such field, create new one with integer type, with autoincrement settings.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin
Re: SQL Status: HY000
Thanks for your help. Now, I can't find out how to identify this as solved.
OOo 3.0.X on Ms Windows XP
Re: SQL Status: HY000
Go to the first post, and edit Subject and add [Solved], or use green tick (as you used in last post) on first post.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin