SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
No longer assists when using .

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
No longer assists when using .
Author Message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post No longer assists when using . Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6501

Post Reply with quote
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 View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Reply with quote
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 View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 314
Country: United States

Post Reply with quote
table alias + . does work for the select & where clauses, just no longer in the from clause
Tue Aug 28, 2007 2:20 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6501

Post Reply with quote
I will submit this issue for further investigation.
Tue Aug 28, 2007 2:41 pm 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.