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]
