RE: [Squirrel-sql-users] Code Completion Plugin
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Gupta, A. <abh...@gs...> - 2006-01-11 14:47:29
|
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 > |