AutoValue

[praks]

Hi everybody, am new to this forum. Would like to get help on OO base AutoValue. I create a table with a field property set to integer and as primary key. I chek the Auto value to true and save the table. however, when i open the table to insert data, the error message says that the field cannot be left blank and the autoValue defaults to "No" automatically.

please help. Thanks in advance.

[Billyray]

Welcome to the Forum! To get helpful answers, you should have a signature prepared like mine below. It makes a difference what database you are connected to, or if you are using the internal one. What is your operating system, and what version of OOo are you using.
_________________
Billyray
using:
Linux distro: Ubuntu 10.04 LTS, Lucid Lynx, OOo Base 3.3, connected to MySql database using Java jdbc (note: ONLY sun-java-6-1.6.0_22 jre works right), and converted from MS Access 2003.

[praks]

HI, Thank You. I am using OO version 3.0, in windows as standalone mode. Not connecting to any db. using inbuilt db to create table.
The error message is
"SQL Status: 23000
Error code: -10

Attempt to insert null into a non-nullable column: column: id table: Table1 in statement [INSERT INTO "Table1" ( "name") VALUES ( ?)]"

Thanks Once again.
Shiva Prakash

[Villeroy]

Easy fix:
Create a new table.
Copy the contents from the old table to the new one. Drag the new table icon over the old one and choose "append data".
Delete the old table.
Rebuild any relations.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

[praks]

No no no. There are no records. The moment i try to enter records by skipping the auto value field the error message pops-up.
Using ooobase 3.0 on windows 7, with in-built db. no external connections to the db.

[Billyray]

Are you using 32 bit or 64 bit Windows 7?
_________________
Billyray
using:
Linux distro: Ubuntu 10.04 LTS, Lucid Lynx, OOo Base 3.3, connected to MySql database using Java jdbc (note: ONLY sun-java-6-1.6.0_22 jre works right), and converted from MS Access 2003.

[davidp0418]

I have the same problem as the other user above. I have Open Office 3.4.0 (current version) using the internal database and setting the primary key to an integer field type, I select autovalue to YES and as soon as a save it it changes from YES to NO. Even when using the wizard to create a database and when I get to the primary key and select autovalue to yes, when I exit the wizard the primary key is not a YES but a NO.

I'm not trying to edit an already existing database but creating a new database from scratch. It could also be I'm not creating it correctly.

I'm using Windows 32bit version on Vista

Could there be a bug in the current version as to why the autovalue isn't staying at a YES?

[dacm]