https://bugs.documentfoundation.org/show_bug.cgi?id=100167
--- Comment #4 from [email protected] ---
Design view is more powerful and more efficient for experienced developers.
The wizard does not allow all the options which the design view suggests are
available - eg. no option for "SQL command" data source.
I had initially expected a subform object to appear on the main form, within
the bounds of which subform fields could be added/edited.
Even using the navigator-based approach, I'm still having problems...
If someone could try to replicate this and report, I would be grateful.
I wonder if there are just problems with the Ubuntu version? 14.04.4 / LO
Version: 5.1.3.2Build ID: 1:5.1.3~rc2-0ubuntu1~trusty1
I have created a table structure to log and list issues (things that need
attention) in a software project I'm working on, the categories which apply to
them, and vice-versa.
issue --< issue_cat >-- cat
issue(issue integer PK autoincrement, issuedescr text)
cat(cat integer PK autoincrement, catdescr text)
issue_cat(issue integer, cat integer)
Issue and Cat tables have some dummy records, issue_cat is as-yet empty.
Upon opening issue_cat (table) to edit data, there is no grid and records
cannot be added. Record navigation/new record buttons are missing. Looks as if
the window hasn't been drawn fully/properly. Moving or maximising the window
causes them to appear, but they are disabled.
1. create a new form, with a textbox
2. bind form to "issue" table and textbox to "issue" field (using right-click
context menu)
3. navigator > right-click "form" > "New" > "Form"
...form appears as child of "Form", rename child to "subform"...
click "subform"
click "more controls..." on toolbox
add table control
cancel wizard (I don't want to show a table or query, but want to use an SQL
statement to provide the data)
in subform properties, set "content type" to SQL command
set "content" to:
SELECT "issue_cat"."issue", "issue_cat"."cat", "cat"."catdescr" FROM
"issue_cat", "cat", "issue" WHERE "issue_cat"."cat" = "cat"."cat" AND
"issue"."issue" = "issue_cat"."issue"
Set link master and slave fields to "issue"
There now seems to be no way to edit the empty table control.
So...
Delete the table control and create another (having set-up the parent and
subform in the steps above)...
wizard appears showing fields from subform sql command
added successfully
table control is blank when scrolling through records on parent form (there is,
as yet, no data in issue_cat, so this may not be regarded as wrong...) ...but
there is no way to add records - no default "blank/null" line waiting to be
filled as might be expected, and the navigation controls/new record button are
disabled. Subform properties apparently allow additions and modifications.
Subform table control doesn't allow additions/deletions (with disabled nav/new
controls) even if a table source and fields are selected from the wizard.
I can't test how behaviour might differ if issue_cat were populated, because I
can't enter any data in the table view.
Many thanks
Gareth
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
