[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 User kpalagin changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from [EMAIL PROTECTED] Fri Apr 20 13:42:01 + 2007 --- Works fine in 2,2m7 on WinXP. Closing. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Thu Jan 4 06:23:39 -0800 2007 --- verified in CWS dba22b find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba22b - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 User fs changed the following: What|Old value |New value Target milestone|OOo 2.x |OOo 2.2 --- Additional comments from [EMAIL PROTECTED] Thu Jan 4 04:48:53 -0800 2007 --- targeting to 2.2, since the fix is part of a CWS aiming for this release - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 User fs changed the following: What|Old value |New value Assigned to|fs|msc --- Additional comments from [EMAIL PROTECTED] Thu Jan 4 02:27:16 -0800 2007 --- fs-> msc: please verify in CWS dba22b - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 --- Additional comments from [EMAIL PROTECTED] Wed Dec 13 03:02:55 -0800 2006 --- added test method "checkStatementQiQSupport" to complex test case complex.dbaccess.QueryInQuery - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 User fs changed the following: What|Old value |New value Status|STARTED |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Wed Dec 13 02:52:34 -0800 2006 --- fixed in CWS dba22b find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba22b - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 User fs changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |41393) self-contained docu | |ment to reproduce the bug | |case --- Additional comments from [EMAIL PROTECTED] Wed Dec 13 02:50:41 -0800 2006 --- Created an attachment (id=41393) self-contained document to reproduce the bug case - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 User fs changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |fs Ever confirmed| |1 Status|UNCONFIRMED |NEW Target milestone|not determined|OOo 2.x --- Additional comments from [EMAIL PROTECTED] Mon Sep 11 22:57:40 -0700 2006 --- grabbing, confirming, targeting - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 User fs changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from [EMAIL PROTECTED] Mon Sep 11 22:58:04 -0700 2006 --- accepting - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 --- Additional comments from [EMAIL PROTECTED] Mon Sep 11 09:41:03 -0700 2006 --- Found the workaround for this: sub onQiQ_2_testStatement( oEv ) dim conn dim stmt dim rs dim oSingleQueryAnal print oEv.Source.Model.Parent.Command conn = oEv.Source.Model.Parent.ActiveConnection stmt = conn.CreateStatement stmt.EscapeProcessing = TRUE oSingleQueryAnal = conn.CreateInstance( "com.sun.star.sdb.SingleSelectQueryAnalyzer" ) oSingleQueryAnal.setQuery( "SELECT Q1.*, Q2.* FROM ""Query1"" Q1, ""Query2"" Q2 WHERE Q1.ID = Q2.ID" ) rs = stmt.executeQuery( oSingleQueryAnal.QueryWithSubstitution ) rs.close end sub - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 User atjensen changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |39086) Example database fi | |le --- Additional comments from [EMAIL PROTECTED] Mon Sep 11 08:27:52 -0700 2006 --- Created an attachment (id=39086) Example database file - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 69460] XStatement does not suppor t QiQ syntax
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69460 Issue #|69460 Summary|XStatement does not support QiQ syntax Component|Database access Version|OOo 2.0.4 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen --- Additional comments from [EMAIL PROTECTED] Mon Sep 11 08:27:10 -0700 2006 --- To test this do the following: Download the attached database file. Copy this procedure into Module1 of your Standard basic library. sub onQiQ_1_testStatement( oEv ) dim stmt dim rs print oEv.Source.Model.Parent.Command stmt = oEv.Source.Model.Parent.ActiveConnection.CreateStatement stmt.EscapeProcessing = TRUE rs = stmt.executeQuery( "SELECT Q1.*, Q2.* FROM ""Query1"" Q1, ""Query2"" Q2 WHERE Q1.ID = Q2.ID" ) rs.close end sub Open the database and it's one form. Click on the button 'Test Stmt' - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]