SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
BUG: Automatic SQL SELECT

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
BUG: Automatic SQL SELECT
Author Message
rang14



Joined: 16 Apr 2009
Posts: 1
Country: United States

Post BUG: Automatic SQL SELECT Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.