SqlDbx
You are not logged in.
OK, this is a question - what can you do with "Column Block" mode?
So far you can only hit "Del" and delete selected text or press Ctl+C and copy it to a clipboard and then paste to another application.
You cannot even paste it to the script window as is!!! You have to preallocate enough blank lines first!
And obviously you cannot use the most needed function - paste it into the new column NEXT TO THE EXISTING text!
This is what other editors allows you to do:
abcd
efgh
klmn
You can select column 2-3 c,copy it and paste it NEXT TO the existing text
abcd bc
efgh fg
klmn lm
Unfortunatelly SqlDbx cannot do it
Offline
I don't know what you talking about.
It is EXACTLY how it works.
Offline
No, it is not!!!!!!!
I tried different ways using Ctl+V and Shift+Alt+V and even adding trailing spaces to each line and never was able to paste a block!
In the example above I'm highlighting and copying col 2-3 but after paste it looks like this
abcd abcd
efgh
klmn
Could you give a detailed istruction of how to paste a block next to the existing text?
Offline
Sorry to interfer here, I did not know about this feature,
but i can certify that it works as is intended:
text before:
1112333
1223444
dfsffff
after test:
1112333 1233
1223444 2344
dfsffff sfff
Last edited by maac2002 (2012-10-09 13:52:57)
Offline
1. Hold ALT and select rectangular area with mouse
2. CTRL+C
3. Click where you want the selection to be copied.
4. CTRL+V
Offline
Not working for me!!
I selected block col2-3 and copy it to the clipboard.
Then I position cursor on the 1st line.
When I click Ctrl+V it paste the left side of the line to where cursor is!
And if i position a cursor on the 2nd line it paste the left side of 2nd line!
And so on!
abcd abcd <- cursor is on the 1st line
efgh
klmn
abcd
efgh efgh <- cursor is on the 2nd line
klmn
abcd
efgh
klmn klmn <- cursor is on the 3rd line
Is it anything in the settings I need to change?
Last edited by garbuya (2012-10-10 09:53:24)
Offline
It seems to me that I cannot edit by block (such as in many editors e.g. Notepad++).
Is it possible in some way?
If not, it would be a powerful improvement.
Bye.
Last edited by aangelo (2013-07-03 03:42:57)
Offline
Please provide examples of what you want to be able to do
Offline
Example:
12345678
12345678
12345678
123456781. Position cursor at 1st line, between 4 and 5 then Alt+C switches into Column (Block) Mode.
2. Move cursor down using Shift + Arrow down key to extend down selection (as suggested by Help Guide [Editor Keyboard Shortcuts]).
3. I always obtain column 5 selected in all rows (not a thin red line as I read somewhere in the documentation)
4. As soon as I type something (e.g. key "#") the "5" of the 1st line is overwritten (no insertion at all) while the "5" of all other lines is simply deleted, obtaining the following:
1234#678
1234678
1234678
1234678I expected to insert "#" in all lines, between 4 and 5.
Do I miss something?
Last edited by aangelo (2013-07-03 03:45:01)
Offline
What you describe should work.
If you position cursor between 4 and 5 and then ALT+C and then SHIFT+ ARROW DOWN you should see thin red line.
The only time I can reproduce your behavior if before moving down I select 5 in a first row.
Try to enter block insertion mode by holding ALT and LEFT MOUSE BUTTON while moving mouse.
Offline
Sorry, but the problem persists.
My OS: Windows 7 Professional SP11 64 bit
Keyboard is always in INS mode
1. I position cursor between 4 and 5 and then ALT+C .
2. When I SHIFT+ ARROW DOWN I see the thin red line only at the last (lower) line reached and the whole column at the right of the cursor (character 5 in the example) is selected.
3. Holding ALT and LEFT MOUSE BUTTON while moving mouse produce the exactly same behaviour.
In no way I can have the cursor between 4 and 5 without any char selected after I moved down the cursor.
Offline
Ok. I think the problem is the font you have select for editor. Can you select Courier New and check if it helps
Offline
I've set Consolas as font in editor.
Now I set Courier New, restart SqlDbx, but I still have the same results.
Offline
Ok. I can see that Consolas an Courier New for some reason have issues. Try Courier. Works for me
Looks like on Windows 7 some of the fixed pitch fonts are not detected correctly.
This will be fixed in a next release.
Offline
Ok, this works. Thank you!
Offline
Hello!
Environment:
SqlDbx x64 Version 4.13 (Professional Edition)
OS: Windows 10 Home Edition
I tried to edit some text in Column Mode but it seems to me that still exists an old problem (see quoted text and following posts).
Time ago I was suggested to solve it using "Courier" fonts but now I made the same test with Courier, Courier New and Consolas fonts without solve it.
Probably I missed something again but can you please help me?
Thank you for the attention.
Example:
12345678 12345678 12345678 123456781. Position cursor at 1st line, between 4 and 5 then Alt+C switches into Column (Block) Mode.
2. Move cursor down using Shift + Arrow down key to extend down selection (as suggested by Help Guide [Editor Keyboard Shortcuts]).
3. I always obtain column 5 selected in all rows (not a thin red line as I read somewhere in the documentation)
4. As soon as I type something (e.g. key "#") the "5" of the 1st line is overwritten (no insertion at all) while the "5" of all other lines is simply deleted, obtaining the following:1234#678 1234678 1234678 1234678I expected to insert "#" in all lines, between 4 and 5.
Do I miss something?
Last edited by aangelo (2016-02-23 12:36:11)
Offline
I am not sure why you have this problem.
I can not reproduce it and everything seems to work correctly.
Do you have English version of Windows or some other?
Offline
aangelo,
Uncheck "Font is Proportional" in Editor settings and it will work with any font
Offline
garbuya:
"Font is Proportional" was always unchecked and I tested with Courier, Courier New and Consolas font.
Today the test has been performed with the last version 4.16 but I get the same result after SqlDbx restart.
sqldbxhelp:
my OS is Windows 10 Home, with Italian language.
Last edited by aangelo (2016-06-08 04:19:51)
Offline
Hello!
Environment:
SqlDbx x64 Version 5.11 (Professional Edition) (UNICODE)
OS: Windows 10 Home Edition
Please apologize me, but in my work I find really useful column mode editing.
I just updated to version 5.11 but the column mode editing problem still exists, as described in the quoted text of 2016-02-23 and posts following.
Time ago I was suggested to solve it using "Courier" fonts but now I made the same test with Courier, Courier New and Consolas fonts without solve it.
Probably I missed something again but can you please help me?
Thank you again for the attention.
Example:
12345678 12345678 12345678 123456781. Position cursor at 1st line, between 4 and 5 then Alt+C switches into Column (Block) Mode.
2. Move cursor down using Shift + Arrow down key to extend down selection (as suggested by Help Guide [Editor Keyboard Shortcuts]).
3. I always obtain column 5 selected in all rows (not a thin red line as I read somewhere in the documentation)
4. As soon as I type something (e.g. key "#") the "5" of the 1st line is overwritten (no insertion at all) while the "5" of all other lines is simply deleted, obtaining the following:1234#678 1234678 1234678 1234678I expected to find "#" inserted in all lines, between 4 and 5.
Do I miss something?
Offline