Issue 60739 - sub-form: "Analyze SQL command" == false breaks the form
Summary: sub-form: "Analyze SQL command" == false breaks the form
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: usability
Depends on:
Reported: 2006-01-18 01:08 UTC by kieser
Modified: 2017-05-20 10:44 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

bugdoc (11.46 KB, application/vnd.sun.xml.base)
2006-01-19 09:47 UTC, marc.neumann
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description kieser 2006-01-18 01:08:10 UTC
If "Analyze SQL command" is set to false in a slave table control that is parent
to another slave table control, the next time the form is used, the error
"column out of range" occurs. Either the error message needs to be more
meaningful or (better), the option to set "Analyze SQL command" to false should
be disabled under these conditions.
Comment 1 marc.neumann 2006-01-19 09:44:44 UTC

I can reproduce this.

open the attached sample database and open the form.

==>> error messages.

Bye Marc

Comment 2 marc.neumann 2006-01-19 09:47:02 UTC
Created attachment 33367 [details]
Comment 3 marc.neumann 2006-01-19 10:06:56 UTC
set target
Comment 4 Frank Schönheit 2006-01-20 10:52:22 UTC
Comment 5 Frank Schönheit 2006-01-20 10:55:18 UTC
master-slave relationships in forms require analyzing the SQL command, else OOo
cannot know which parameters are in the command. Need to think about a better
error message, probably.
Comment 6 kieser 2006-01-20 13:18:47 UTC
I would say that yes, the error message needs to be improved, but that's only
1/2 the solution. The forms system should not allow the "Analyze SQL command" to
be set to false if it's required for the correct operation of the form! I.e. It
should be disabled if part of a master-slave relationship.
Comment 7 Frank Schönheit 2006-01-20 13:42:28 UTC
yes, this would also be a possibility. However, a clear error message saying
"your master-slave relationship doesn't work because ..." would perhaps be
better than silently disabling some options. In the latter case, people would
not understand what's going on, would they?
Comment 8 kieser 2006-01-20 13:58:38 UTC
That's also true. Whatever is the easiest to understand, I guess.
Comment 9 Marcus 2017-05-20 10:44:15 UTC
Reset the assignee to the default "".