To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43861 Issue #:|43861 Summary:|Parameterized queries against a table do not work |(but do work against views) Component:|Database access Version:|680m79 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|msc Reported by:|twimpiex
------- Additional comments from [EMAIL PROTECTED] Wed Mar 2 02:56:18 -0800 2005 ------- While testing OOo 1.9.79 I found the following problem. If you create a query with a parameter in it, it doesn't work if you do a select on a table, but it does work if you do a select on a view from that same table. The following document contains an example. It has a 'table' and a 'view' which is just a view on this table. It contains two queries which are the same but one is against the table and the other is against the view. 1) From the queries double click on query_against_view. 2) You will be prompted to enter a value for parameter 'parent' 3) Enter '1' as a value (without the single quotes) 4) This will give you 5 rows as a result 5) From the queries double click on query_against_table. 6) You will be prompted to enter a value for parameter 'parent' 7) Enter '1' as a value (without the single quotes) 8) This will give an error saying something like no data available. Both queries are the same and act on the same data only one is for the table and the other is for the view. Wim Crols --------------------------------------------------------------------- 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]