To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66012 Issue #:|66012 Summary:|list box shows wrong column if datasource is parsed |SELECT column1+clomn2 Component:|Database access Version:|OOo 2.0.3 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P4 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|regina
------- Additional comments from [EMAIL PROTECTED] Thu Jun 1 11:28:21 -0700 2006 ------- I use OOo2.0.3rc4de. I want to show the whole record in a list box, but link to the primary key. Therefore I use a query as datasource, which has the concatenated record in the first column and the primary key in the second record. I tried this versions (1) with function CONCAT, parsed SQL SELECT CONCAT( CONCAT( CONCAT( CONCAT( "ID", ' | ' ), "Lehrer" ), ' | ' ), "Raum" ) AS "info", "ID" FROM "Klassen" "Klassen" (2) with + , parsed SQL SELECT "ID" + ( ' | ' ) + "Lehrer" + ( ' | ' ) + "Raum" AS "info", "ID" FROM "Klassen" "Klassen" (3) same as (2), native SQL Version (2) doesn't show the "info" column in the listbox, although all three queries show the same table, when you run them as query. Try the forms in the attached testbase. --------------------------------------------------------------------- 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]