[dba-issues] [Issue 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Wed Nov 19 12:29:35 + 2008 --- verified in CWS dba31e 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=DEV300%2Fdba31e - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User lla changed the following: What|Old value |New value Assigned to|lla |msc --- Additional comments from [EMAIL PROTECTED] Wed Nov 5 12:13:44 + 2008 --- Please verify. - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User lla changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Wed Oct 8 08:26:03 + 2008 --- Fixed but maybe confusable. You need to know in which locale your desktop works. If the desktop has a English locale you can type 'true' or 'false'. In a German locale you have to type 'wahr' or 'falsch'. In a German local 'true' will result in 'falsch', because in German the word 'true' doesn't exists therefore the result is false. If unsure, type '1' (true) or '0' (false). This is tested on an English Windows with an English office but the Windows desktop use the German locale. The SQL Statement will no longer build with the String out of the text field, but with the 'EffectiveValue' which will convert in java to Boolean then to String which result in 'true' or 'false'. - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User bc changed the following: What|Old value |New value Assigned to|bc|lla Target milestone|OOo 3.0 |OOo 3.x --- Additional comments from [EMAIL PROTECTED] Wed Jun 11 09:02:58 + 2008 --- As discussed assigning to Lars - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User bc changed the following: What|Old value |New value Target milestone|OOo 2.x |OOo 3.0 --- Additional comments from [EMAIL PROTECTED] Wed Jan 2 17:20:57 + 2008 --- bc: As this is a UI relevant feature it will not make its way into OOo.2.x. Changing target to OOo. 3.0 - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User oj changed the following: What|Old value |New value Assigned to|oj|bc Status|REOPENED |NEW --- Additional comments from [EMAIL PROTECTED] Wed Aug 22 13:50:51 + 2007 --- @bc: Could you please test if this issue is still occurring for the query wizard. Thanks. - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User bc changed the following: What|Old value |New value Assigned to|bc|oj --- Additional comments from [EMAIL PROTECTED] Tue Oct 10 01:44:08 -0700 2006 --- I tried both formats (String and boolean) to set the filter condition. When I passed the filtercondition as a Boolean to the method setStructuredFilter() an SQLException (Syntax Error in SQL expression) . The idl description of setStructuredFilter says explicitly that the filtercondition must be passed as a String, so in any way here is an inconsistency. - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User fs changed the following: What|Old value |New value Status|RESOLVED |REOPENED Resolution|INVALID | --- Additional comments from [EMAIL PROTECTED] Tue Oct 10 01:55:48 -0700 2006 --- INVALID is certainly not a valid resolution - this issue needs to be fixed on either side. - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 --- Additional comments from [EMAIL PROTECTED] Tue Oct 10 22:24:38 -0700 2006 --- After investigating the source code, the api could be more tolerant ;-) Currently the string in the sturctured filter is append to the sql statement without checking which column name is used and therefor without type checking. This will be changed in that way that if you use a name = value, the API will look for the name in the column list and decide on their type how to create the statement part. - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User bc changed the following: What|Old value |New value Assigned to|bc|oj Status|STARTED |NEW --- Additional comments from [EMAIL PROTECTED] Mon Oct 9 04:45:00 -0700 2006 --- I modified my the creation of the query in such a way that the not the actual value of the filtercondition is conveyed to the querycomposer but its string representation (conforming to the instructions of com.sun.star.sdb.XSingleSelectQueryComposer The following query string was then created: SELECT Assets2.MyBooleanField AS MyBooleanField FROM Assets2 AS Assets2 WHERE ( Assets2.MyBooleanField = WAHR ) opening this query caused the following error message: The data content could not be loaded After I manually modified the statement to : SELECT Assets2.MyBooleanField AS MyBooleanField FROM Assets2 AS Assets2 WHERE ( Assets2.MyBooleanField = True ) the query worked fine. How shall we go on with this issue? bc-oj: fs suggested to send the issue to you to make a decision - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |INVALID --- Additional comments from [EMAIL PROTECTED] Mon Oct 9 22:30:08 -0700 2006 --- When you set the filte by hand you have to be sure which format you have to use. You could of course that a Boolean column as filter condition, that allowqs the singleselectquerycomposer to distinguish the type correctly and then it sets a correct query string for you. - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User oj changed the following: What|Old value |New value Assigned to|oj|bc --- Additional comments from [EMAIL PROTECTED] Mon Oct 9 22:30:30 -0700 2006 --- Back to you. - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 --- Additional comments from [EMAIL PROTECTED] Wed Aug 30 01:57:29 -0700 2006 --- Sorry for the delay. As for the first bit: 1. Open the database 2. Create Query in Design View 3. Add the table 4. Choose the field with the yes/no variable and drag it into the bottom half 5. The field correctly appears 6. according to the help, I should be able to add the criterion = TRUE (without speech marks), but I get an error message Warning! Error in SQL statement This means I cannot use the design view to create a query filtering based on the yes/no [boolean] variable... - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User bc changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from [EMAIL PROTECTED] Wed Aug 30 01:57:54 -0700 2006 --- Talked with fs: He gave me the hint to use the Property BooleanComparisonMode at DataSource. - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User clu changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Mon Aug 28 03:00:00 -0700 2006 --- correct state - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User clu changed the following: What|Old value |New value Summary|Query for Yes/No entry bro|Query containing search co |ken |ndition with bool fields d | |oes not work properly Target milestone|not determined|OOo 2.x --- Additional comments from [EMAIL PROTECTED] Wed Aug 16 05:14:58 -0700 2006 --- set target - 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 68551] Query containing search co ndition with bool fields does not work properl y
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 User clu changed the following: What|Old value |New value CC|''|'clu' --- Additional comments from [EMAIL PROTECTED] Wed Aug 16 05:16:15 -0700 2006 --- set me for cc - 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]