Issue 60739 - sub-form: "Analyze SQL command" == false breaks the form
Summary: sub-form: "Analyze SQL command" == false breaks the form
Status: ACCEPTED
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:
URL:
Keywords: usability
Depends on:
Blocks:
 
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: ---

Attachments
bugdoc (11.46 KB, application/vnd.sun.xml.base)
2006-01-19 09:47 UTC, marc.neumann 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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 
Hi,

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]
bugdoc
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 
accepting
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 "issues@openoffice.apache.org".