To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51151
------- Additional comments from [EMAIL PROTECTED] Tue Jul 12 02:32:38 -0700 2005 ------- I've experienced the same problem on 1.9.109 on Windows connecting to a Postgres database via ODBC. Logging the queries to the database shows that when the DataPilot dialog is opened, the column IDs are requested twice, and the entire table once: SELECT * FROM "public"."vsm_timesheets" WHERE 0 = 1 SELECT * FROM "public"."vsm_timesheets" WHERE 0 = 1 SELECT * FROM "public"."vsm_timesheets" I may be mistaken, but requesting the entire table would appear to be unnecessary when only the column names are required at this stage? Later, when the table is created (after pressing OK on the DataPilot dialog), there are three requests for the column IDs and two for the entire table: SELECT * FROM "public"."vsm_timesheets" WHERE 0 = 1 SELECT * FROM "public"."vsm_timesheets" WHERE 0 = 1 SELECT * FROM "public"."vsm_timesheets" SELECT * FROM "public"."vsm_timesheets" WHERE 0 = 1 SELECT * FROM "public"."vsm_timesheets" I imagine it should be possible to do this with a single request for the column IDs and another for the relevant columns only in the table (rather than all of the columns) --------------------------------------------------------------------- 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]
