squirrel-sql-users

[Squirrel-sql-users] Code Completion Plugin

[Gupta, A. <abh...@gs...>]

I am facing a problem with the code completion plugin which happens when I
have multiple queries in the sql panel.

 

For example:

 

1st query: select * from table1 a inner join table2 b on table1.id =
table2.table1id where a.x = 2 // Auto complete works correctly here I get
table1 columns in "a." where clause.

 

2nd query: select * from table3 a where a.y = 5 // Autocomplete shows the
columns for table1 instead of table3.

 

Has any body else seen this problem?

 

Thanks

Abhishek

Re: [Squirrel-sql-users] Code Completion Plugin

[Gerd W. <bir...@t-...>]

Hi Abhishek,

thanks for this one. It made me play around with code completion for 
some time.

Unfortunately I don't think I'll find a good solution at the moment. 
Here are some details:

Of course the problem is that you use the same alias for two different 
tables. The decision that has to be made is whether you are in the first 
or the second statement when you use completion on 'a.'
I could not think of a good way to decide this for now.

If you have got any suggestions let me know. For every day work I'd 
suggest not to use duplicate aliases.

Gerd

Gupta, Abhishek wrote:
> I am facing a problem with the code completion plugin which happens when 
> I have multiple queries in the sql panel.
> 
>  
> 
> For example:
> 
>  
> 
> 1^st query: select * from table1 a inner join table2 b on table1.id = 
> table2.table1id where a.x = 2 // Auto complete works correctly here I 
> get table1 columns in “a.” where clause.
> 
>  
> 
> 2^nd query: select * from table3 a where a.y = 5 // Autocomplete shows 
> the columns for table1 instead of table3.
> 
>  
> 
> Has any body else seen this problem?
> 
>  
> 
> Thanks
> 
> Abhishek
>