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

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

This is the code which I had changed to get this working.

-----Original Message-----
From: Gerd Wagner [mailto:bir...@t-...] 
Sent: Tuesday, January 10, 2006 4:53 PM
To: Gupta, Abhishek
Cc: squ...@li...
Subject: Re: [Squirrel-sql-users] Code Completion Plugin

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
>