![SoftTree Technologies](templates/GreenTech/images/logo.gif) |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
No longer assists when using . |
|
2.5.20
Select *
From dbo.ACCOUNT a
INNER JOIN dbo.ACCOUNT_EXT ae
ON a.
This no longer prompts for column names. Using AS to alias doesn't help.
|
|
Tue Aug 28, 2007 1:54 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
Are you sure it was behaving that way before .20? After ON it is supposed to display joins for known foreign keys only. Did you loose the foreign key between account and account_ext tables by any chance?
Try Ctrl+Space after "a." Does it work for you?
|
|
Tue Aug 28, 2007 2:11 pm |
|
![](templates/GreenTech/images/spacer.gif) |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
Yes, ctrl+space does work. But it used to automatically prompt with column names when typing a period after a table alias.
|
|
Tue Aug 28, 2007 2:13 pm |
|
![](templates/GreenTech/images/spacer.gif) |
judahr
Joined: 09 Mar 2007 Posts: 319 Country: United States |
|
|
|
table alias + . does work for the select & where clauses, just no longer in the from clause
|
|
Tue Aug 28, 2007 2:20 pm |
|
![](templates/GreenTech/images/spacer.gif) |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7849
|
|
|
|
I will submit this issue for further investigation.
|
|
Tue Aug 28, 2007 2:41 pm |
|
![](templates/GreenTech/images/spacer.gif) |
|
|
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
|
|
|