Issue 53778 - "Append table alias name" should be defaulted to "off" for dBase and HSQLDB databases, at least
Summary: "Append table alias name" should be defaulted to "off" for dBase and HSQLDB d...
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m124
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-08-25 11:51 UTC by Frank Schönheit
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2005-08-25 11:51:06 UTC 
when creating a new database (File|New|Database), the advanced option "Append
table alias name" (see
http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw) is set
to "on", and cannot be changed later on.
This means that for those databases, which target more the unexperienced and
novice than the expert users, SQL statements generated in the query designer
have an unnecessary complexity.

Setting this option to "off" by default for those database types should make
queries generated by OOo slightly more understandable to the unexperienced user.
Comment 1 ocke.janssen 2007-11-07 08:30:53 UTC 
Was fixed in cws dba24c with another issue.
Comment 2 ocke.janssen 2007-11-07 08:31:14 UTC 
Closing it.