 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
rang14
Joined: 16 Apr 2009 Posts: 1 Country: United States |
|
BUG: Automatic SQL SELECT |
|
When "Auto add aliases" set "NO"
1) Type: "SELECT "
2) Arrow Down, chose table "Action"
3) Arrow Right, then Arrow Down, chose columns
4) End up with: "SELECT IDAction, NameAction FROM [Action]"
Columns without a table name.
I expected: "SELECT [Action].IDAction, [Action].NameAction FROM [Action]"
This is normal?
In the second time:
1)Type: "SELECT "
2) Arrow Down, chose table "Account"
3) Arrow Right, then Arrow Down, chose columns
4) End up with: "SELECT [Action].IDAccount, [Action].DateCrt FROM Account"
Columns with a name of table [Action], but should be Account.
I expected: "SELECT Account.IDAccount, Account.DateCrt FROM Account"
This is BUG?
|
|
Thu Apr 16, 2009 11:14 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Auto-add Aliases option is not used for fully qualifying column names. It is used for adding aliases to table names. For example SELECT * FROM my_table a WHERE a.column5 = 1 . So what you get is normal. Full column name qualification is used automatically and only when there is more than one table referenced in the query. And generally speaking even in that case it is recommended to use short aliases and don't pollute the code with unnecessary stuff making it difficult to read and maintain.
Regards,
SysOp
|
|
Fri Apr 17, 2009 6:51 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|