Hi,

in the past, sometimes I encountered a  similar problem, that the code completion doesn't work always. In my eyes, it doesn't work in a sub-select statement. But mostly, code completion works like a charm.

For some configuration items, please have a look at "File >> New Session Properties >> Code Completion". You can try some of the options.

If you have an example, when the code completion doesn't work, please let us know the situation, than we can have a closer look.

Did you notice some errors or warnings in the log panel (usually they are in red)?

Otherwise, you can update to 3.4 of SQuirreL.

Stefan


On 2012-08-29 11:22, Massimo Re wrote:
Hi Stefan
 
I can't understand why when i hit CTRL+SPACE to see columns name, often i can't see them but table names or view names ...
Sometimes i see them ....
 
Is a possible configuration problem ?
 
Squirrel version 3.3
Windows 7
Dbase : AS400 Iseries
 
Thank for your help.
 
Max

2012/8/26 Stefan Willinger <stefan.home@aon.at>
Hi,

1) What is the equivalent ORACLE DESC command ?
You can use the Objects Browser to learn about the structure of a table. Just navigate to a table and you will get some information (e.g. columns, create script, content) about it.


2) I've see that in ORACLE SQLDEVELOPER, after you digit SELECT FROM MYTABLE a list of all fields of the table appear so you can easy select or digit the correct name.
The same list appear also after WHERE ...
Is possible to do the same in Squirrel 3.3 (or 3.4)  ? If yes how ?
Yes, it is possible. You can use the plugin "codecompletion". I think, it is already in the base version of SQuirreL. You can activate it by hitting CTRL+SPACE. This plugin allows you to complete keywords as well as table or column names.

Stefan



On 2012-08-25 15:41, Massimo Re wrote:
Hi all
 
I'm using Squirrel 3,3 on AS400 ISeries ... it work fine.
 
I've some questions ...
 
1) What is the equivalent ORACLE DESC command ?
 
2) I've see that in ORACLE SQLDEVELOPER, after you digit SELECT FROM MYTABLE a list of all fields of the table appear so you can easy select or digit the correct name.
The same list appear also after WHERE ...
Is possible to do the same in Squirrel 3.3 (or 3.4)  ? If yes how ?
 
Thank for your help !
 
Max
 
 


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/


_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users