[dba-issues] [Issue 68551] Query for Yes/No entry bro ken
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 Assigned to|dbaneedsconfirm |clu --- Additional comments from [EMAIL PROTECTED] Wed Aug 16 04:51:12 -0700 2006 --- change owner - 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 for Yes/No entry bro ken
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 Assigned to|clu |bc --- Additional comments from [EMAIL PROTECTED] Wed Aug 16 05:10:02 -0700 2006 --- clu-bc: the second described part i can repro (seems to be your area) 1. use query wizard with any table (containing a boolean field) 2. insert a search condition for the bool with a value like: 'true' 3. push the finish button - error message: Syntax error in sql expression clu-open_me: may you describe the first part (with the query editor) more precisely (step-by-step), because like i have tried, it generally worked fine (query a bool field with true as criterion) thx - 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 for Yes/No entry bro ken
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68551 Issue #|68551 Summary|Query for Yes/No entry broken Component|Database access Version|OOo 2.0.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|open_me --- Additional comments from [EMAIL PROTECTED] Fri Aug 11 14:44:58 -0700 2006 --- Create a new database, with one field containing a Yes/No variable. According to the help and my intuition, I could use = TRUE or = FALSE to query the field. I get an error message instead. The matching IS NULL works. If I use the wizard to the same effect, the condition FieldX is equal to TRUE seems to be translated into FieldX =. That's no argument after the equal sign. The wizard thus creates an invalid query... - 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 for Yes/No entry bro ken
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] Fri Aug 11 16:31:52 -0700 2006 --- What seems to be broken is the Wizard and the Query editor. I have tried to create a query with the SQL view, and it works (as described in the help). SELECT Test.ID, Test.Check FROM Test Test WHERE (Test.Check = TRUE) The wizard creates this syntax, except that it drops the TRUE at the end. The query editor does not let me enter TRUE as a condition (error messages). - 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]