To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72144 Issue #|72144 Summary|Cannot use a parameter for IN clause for query 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|kabuto01
------- Additional comments from [EMAIL PROTECTED] Thu Nov 30 08:12:11 -0800 2006 ------- I would like to be a able to use a parameter in an IN clause. (ex. SELECT fields FROM table WHERE field IN (:param) ) The Query designer complains and if you enter it as straight SQL it won't let you run or save the 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]