SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[11.5.362 Pro] - Autocompleting ON for JOINs glitch

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[11.5.362 Pro] - Autocompleting ON for JOINs glitch
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post [11.5.362 Pro] - Autocompleting ON for JOINs glitch Reply with quote
You get a popup for picking column pairs for JOIN ON criteria whether you freshly start from the ON keyword or (when you already have one of the columns typed/selected/whatever) after typing '='. However, while the code generated for the first case is valid, the one you get for the second case is not. That column is preserved instead of being overwritten and that makes the code syntactically invalid. Note that this only happens when picking from the column pairs in the list. If you choose a single column further down the list, everything is alright.

Check this short video here.

I'd expect pairs not to be displayed after typing '='. After all, one of the columns is already there. But since they can be chosen, I'd also expect selecting a pair to 'override' the column already present.
Thu Jul 29, 2021 10:06 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Many thanks for the detailed description and video. I submitted a new defect with number #SA0041645
Thu Jul 29, 2021 5:44 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.