In tora documentation it is mentioned that CTRl-T will auto complete table names. But what CTRL-T does is just swap the lines. eg
#1
#Select * from cu(Cursor)
On pressing CTRL-T at the cursor position what is does is:
#Select * from cu
#1
I am using tora 2.1.3 on windows XP and tora revision 3793 on openSuSE 11.3., for Oracle 11 and MySql 5. This happens for both Oracle and MySql.
For openSuSE 11.3, I compile using the following versions of software:
gcc - 4.5.0
qt - 4.6.3.
KDE - 4.4.4
glibc - 2.11.2-3.3.1
Thanks,
Vivek Bhat
I am seeing the same result. Can you please list the document name, version, and page number that you are referring to?
The manual I am referring to is for TOra 2.1.3,
Document Name: tora_documentation.pdf
Page number: 19
Under the heading "SQL editors". The text is here(for reference):
"Editors for SQL have another feature which is code completion. If you place the cursor
after a ’.’ character TOra will this the available columns for the table referenced by the
name before the ’.’ character. This will only work for defined views and tables. You can
also look up tablenames using the CTRL+T key which will list all tables starting with the
same word as you currently have the cursor in. When the completion list is open you can
navigate it using Up, Down keys and selecting an entry using Return. You can also remove
the list by pressing the Escape key. The completion values are saved in the object cache
and can not be used until it is read. If you find this annoying you can disable this in the
preferences."
Is there any other shortcut for completing usernames? I installed TOra from tora2.1.3-win32-setup.exe and still CTRL-T just swaps lines as mentioned earlier. Is this fixed in some svn version.
There are a lot of tables in database I am working on and it will be a great help if I could know the right key combination for completing table names.
Thanks,
Vivek
View and moderate all "bugs Discussion" comments posted by this user
Mark all as spam, and block user from posting to "Bugs"
I am having the same problem under mac osx snow leopard. the table completion does not work and only swaps the lines. the column name completion works when typing a dot but the the return key does not insert the selection into the editor :-(
comfirmed in windows xp and openSUSE12.2.
ctrl+t can only auto-complete column names , not table names.
First version of the NEW autocomplete function was checked into SVN.
Ctrl+T - line swap is default Scintilla(editor framework) behavior.