Public bug reported:

Binary package hint: openoffice.org

I am using Ubuntu x64 and Openoffice 3.2.1 with MySQL databases.  I have forms
with subforms that have been working since Ubuntu 9.04.  After upgrading to
10.10 from 10.04, the following situation occurs with all databases and subform
entries:

When adding or modifying a record in a subform, the following message is
displayed:

Error inserting record

No value specified for parameter 1

Selecting more gives:

SQL Status: 07001

No value specified for parameter 1

If I choose OK, the error reoccurs.  If I change focus from that subform to the
form or another subform, the error reappears.  If I choose X to exit the error
message and exit the form without saving it, when I reopen the form, the subform
record(s) is/are there.  I get a duplicate record for each time I exit the
message popup with OK or change focus to the form or another subform.  As I
said, this behavior happens with all forms and MySQL databases when attempting
to add or modify a subform record.  I can delete subform records with no
problems, and I can add, modify, and delete form records with no problems
(assuming appropriate cascade options are set in the databases).

This behavior was not present in Ubuntu 10.04 and Openoffice 3.2.0 or any
releases prior.

Ubuntu Release: 10.10
Openoffice Release: 1:3.2.1-7ubuntu1
Expected:  Record to be added without error message
What happened: Record was added but received error message.  Could not continue 
without exiting the form and restarting the form.  If I tried to continue, the 
error message re-occurred each time I selected OK on the error message window 
or tried to change focus to another subform or to the main form.

** Affects: openoffice.org (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/693450

Title:
  Openoffice Base error when adding a subform record

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to