Issue 69258

Summary: SQL query not working as subform
Product: Base Reporter: fbrzvnrnd <effevene>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0.3   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on: 66559    
Issue Blocks:    
Attachments:
Description Flags
simple database with SQL query not working as subform none

Description fbrzvnrnd 2006-09-05 08:06:17 UTC 
If I build a query using SQL, and I want to use the query as subform, the link
between the form and the subform is not working if I use the SQL button to use
the query as SQL (the subform makes everytime a complete query and shows all the
fields). Look at the example file: selecting datas in form, the subform do not
shows datas and in the form properties I do not see column name of the SQL query.

The query is working fine in subform if I do not check the SQL icon in toolbar,
but I can not do this, 'cause -if I do no check the SQL icon- when I close the
query and I need to reopen it to modify it, openoffice opens the query in design
graphic mode. If the query I wrote in SQL (and working in form!) is quite
complex the desing mode destroy the query and do not give me the choose to exit
the design mode for a generic SQL syntax error.
Comment 1 fbrzvnrnd 2006-09-05 08:07:02 UTC 
Created attachment 38959 [details]
simple database with SQL query not working as subform
Comment 2 christoph.lukasiak 2006-09-11 15:23:42 UTC 
i am not quiet shure what you mean - may you add a step by step description to
make your problem more clear and to avoid, we speak about two different problems

thx
Comment 3 drewjensen.inbox 2006-09-11 16:00:41 UTC 
He is correct. I just downloaded his test file and tried this using 2.0.4 RC 1.
( After renaming the queries for the new naming rules and updating the forms
dataform controls )

The issue is that when 'Run SQL Direct' is set to true for the query being used
by the sub form then having a Master->Slave linkage makes has effect. The result
set for the slave dataform is not filtered at all.

I believe that what happens is that when the query is set as 'Run SQL Direct'
the dataform setts it's property 'Analyze SQL Command to NO. 

For example, If you open the test.odb file and save the colour query with SQL
Direct set to false. Then go into the form and change the 'Analyze SQL Command'
to NO you will have the exact same behavior again.
Comment 4 marc.neumann 2006-09-12 09:24:28 UTC 
Hi,

This is not realy a duplicate to isse 66559, but it depends on it.

So I set this issue also as RFE and send to the right developer.

Bye Marc
Comment 5 Marcus 2017-05-20 10:47:58 UTC 
Reset assigne to the default "issues@openoffice.apache.org".