To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67020 Issue #|67020 Summary|[RFE] queries should re-use the column settings of the | underlying table column Component|Database access Version|680m174 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|fs Reported by|fs
------- Additional comments from [EMAIL PROTECTED] Tue Jul 4 07:30:16 -0700 2006 ------- - open the attached database document - open the table "Orders" by double-clicking it => note the non-default formatting of the "OrderDate" column - create a new query in SQL, enter SELECT "Orders"."ID" AS "Order ID", "Orders"."OrderDate" AS "Date", "Customers"."Name" AS "Customer", "Products"."Name" AS "Product", "OrderDetails"."Amount" FROM "OrderDetails", "Orders", "Customers", "Products" WHERE ( "OrderDetails"."OrderID" = "Orders"."ID" AND "Orders"."CustomerID" = "Customers"."ID" AND "OrderDetails"."ProductID" = "Products"."ID" ) as SQL command - save this query - close the query designer - open the query by double-clicking it => the formatting of the column "Date" (which is effectively the column "OrderDate" is the default date format Since you can assume that the user of a database did the table column settings - width, formatting, erc. - for a reason, it would be nice if queries based on tables would automatically respect those settings. --------------------------------------------------------------------- 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]