[dba-issues] [Issue 109763] Filtering form: IN Operat or allows only two expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109763 --- Additional comments from eberl...@openoffice.org Thu Mar 4 08:01:10 + 2010 --- just tested, input in (1,2) is recognized, see attachment. using ; as a delimiter solves my problem, nevertheless I consider the current behavior buggy. - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 109763] Filtering form: IN Operat or allows only two expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109763 --- Additional comments from eberl...@openoffice.org Thu Mar 4 08:03:03 + 2010 --- Created an attachment (id=68140) three pics for input, enter, filter - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 109763] Filtering form: IN Operat or allows only two expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109763 --- Additional comments from eberl...@openoffice.org Thu Mar 4 08:13:34 + 2010 --- The problem are the blanks. Try IN (1,2) or IN (1 , 2) or IN (1, 2). - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 109763] Filtering form: IN Operat or allows only two expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109763 Issue #|109763 Summary|Filtering form: IN Operator allows only two expression |s Component|Database access Version|OOo 3.2 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|eberlein --- Additional comments from eberl...@openoffice.org Wed Mar 3 10:41:34 + 2010 --- to reproduce: Open a form with a number field. Open the filter mode and type in the field in (nr1,nr2). Press Enter. Parser recognizes the expression (setting to IN (nr1,nr2)). Repeat the procedure with 3 or more arguments. Parser changes the expression to IN ('nr1,nr2,nr3'). If you remove the quotes and filter the form, then the navigator bar is disabled, you can only close the form. - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 109763] Filtering form: IN Operat or allows only two expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109763 --- Additional comments from atjen...@openoffice.org Wed Mar 3 20:49:42 + 2010 --- Checked w/ Xp, OOo3.2 - OOo3.0.1 - DEV300m_72 Using form based filters in no case accepted IN( N1, N2 ). The syntax IN( 'N1', 'N2', 'N3' ) is accepted, checked and no problems found. For numbers there is a different syntax IN( 1;2;3 ) also functions properly. In both 3.0.1 and 3.2 there is the problem that if the user enters IN( 1, 2 ) then tabs out of the field this is incorrectly quoted as IN( '1,2' ). Under DEV300m_72 this is no longer the case, rather an error box is displayed when you tab out of the field. The error text is, IMO, much too cryptic to be of any real use. - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 109763] Filtering form: IN Operat or allows only two expressions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109763 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org