To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116174
Issue #|116174
Summary|Subform record add or modify results in error message
Component|Database access
Version|OOo 3.2.1
Platform|PC
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|MySQL Connector/OOo
Assigned to|dbaneedsconfirm
Reported by|cscj01
--- Additional comments from csc...@openoffice.org Sun Dec 19 18:28:12
+ 2010 ---
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.
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org