Weird cursor behavior in SQL Window

[CTzen]

PL/SQL Developer 6.0.3.x, 6.0.4.x

I cannot reproduce this all the time (although it perfectly reproducible today), but it happens often enough to annoy me

Here are steps that cause the problem
1) start typing sql statement in SQL window
2) hit return and continue type on the second row
3) move cursor using cursor keys to the first row
4) using cursor keys position cursor back to second row and end of line
5) if you use space or enter now, cursor jumps one character back before inserting space or enter character

Here is small screenshot video (2mb) .

If I use mouse to position cursor, then everything is ok.

 

[patch]

I have replayed your movie, but I have no strange behaviour. Could it be that some other tool gets in your the way here?

 

[CTzen]

I don't think so, I just reinstalled this system. In case there is other tool involved, I would like to know how to identify which program causes the problem.

 

[Joachim Rupik]

Hello,

I have the similar behaviour in all windows except report.

When I place a cursor (using keyboard or mouse) between first and second character of the word, and then I press space (or enter), cursor moves to the end of the word, space is inserted together with all the word starting from second character:

1. select is typed in
select|
2. cursor is placed between 1 and 2 char:
s|elect
3. space is pressed:
select |elect

It happens with words like: select, from

Joachim Rupik

 

[D.]

Hi,

This looks like an auto-complete problem. Do you have any plug-ins running which auto-completes on a space (eg. SmartEd) ?

This is not reproduceable on my install, where I have no plugins.

Hope this helps,
D.

 

[CTzen]

No, I don't have any plug-ins that could affect auto-completion function. I installed Reconnect plug-in this morning, so it doesn't count

PL/SQL Developer
  Version 6.0.4.907 (MBCS)
  01.xxxxx - 10 user license
  Windows XP version 6.0 (build 2600) Service Pack 2

Parameters
  C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
  Session mode: Multi
  OCI Library:
  Use OCI7: False

Plug-Ins
  *Reconnect v1.0 (C:\Program Files\PLSQL Developer\PlugIns\Reconnect.dll)
   (* is Active)

Homes
  OraHome920  (C:\oracle.2.0)

DLLs
  C:\oracle.2.0\bin\oci.dll

TNS File
  C:\oracle.2.0\Network\Admin\tnsnames.ora

Using
  Home: OraHome920
  DLL: C:\oracle.2.0\bin\oci.dll
  OCI: version 9.2
  Oracle9i Enterprise Edition Release 9.2.0.4.0
  Character size: 1 byte(s)

 

[mike]

Here are my thoughts. First, I watched the video and it's very funny to watch. OK - maybe not if it's happening to you. Anyway...

Joachim - I think that your case is because you are using the shortcuts plug-in. "S" followed by a space is replaced with select, right? Mine does the same thing. So just don't do that anymore, or remove the specific entry for "S ".

Slava - I've learned that if it works for some, but not others, it's often a preference difference or a plug-in difference. Sometimes, I disable ALL plug-ins to rule that out.

Anyway, I played around a little with the settings and I can reproduce this error. If the following editor preferences are in effect, the strange behavior happens when I follow the video:

Indent Automatic - unchecked.
Smart Tab - checked.
Smart Fill - unchecked.
Use tab character - unchecked.
Allow cursor after end of line - checked.
Syntax Highlighting Enabled - checked.

Obviously, this looks like a bug to me. In the mean time, it may work better if you try unchecking "Allow cursor after end of line" or check "Indent Automatic".

Mike

 

[CTzen]

Mike,

you did a great job identifying what's wrong, thank you

My Edit options were set as follows

[x] Ident Automatic
[ ] Smart tab
[ ] Smart fill
[ ] Use tab character
[ ] Wrap lines
[x] Allow cursor after end of line

After disabling last option, the "bug" went away. Hopefully, Marco will fix this one

Thanks again!

 

[Joachim Rupik]

Joachim - I think that your case is because you are using the shortcuts plug-in. "S" followed by a space is replaced with select, right? Mine does the same thing. So just don't do that anymore, or remove the specific entry for "S ".

Great job Mike! I would like to apologize for my "communications noise" .

Joachim Rupik