Want to try a test? if so. In BASE Copy the following (ctrl c)
CREATE TABLE "TESTDATA" ("ID" INTEGER PRIMARY KEY
, "ITEMNAME" VARCHAR(200)
, "UNITPRICE" DECIMAL
, "UNITSINSTOCK" INTEGER
, "LASTORDERDATE" DATE
, "NOTES" VARCHAR(100));
use it to create a new table (TESTDATA)
select Tools>SQL... then paste (ctrl V) the above and Execute
It should give a note saying it execu;ted successfully
Then Edit the table, and make the ID Field Autovalue (Yes)
Save it and open and add data.
If you cannot enter data, then reinstall OpenOffice.
If you can enter data but still cannot enter your data. Reply with the
structure (like above TESTDATA) and I'll try it here.
Harold Hauge
On Sat, Oct 10, 2009 at 8:04 PM, Arnold Roth <[email protected]> wrote:
> I have created a small database with one table and a form for entering data
> into the table. When I try to enter a record I get an error message that
> tells me that I'm trying to save a record with null information in non-null
> fields. However, I've put in info in each one of the fields.
>
> Can anyone tell me what the problem might be?
>
> Thanks
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
