SqlDbx Forum

SqlDbx

You are not logged in.

#1 2012-10-05 13:28:10

garbuya
Member

What can you do with "Column Block" mode?

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

#2 2012-10-05 21:01:27

sqldbxhelp
Administrator

Re: What can you do with "Column Block" mode?

I don't know what you talking about.
It is EXACTLY how it works.

Offline

#3 2012-10-09 12:47:28

garbuya
Member

Re: What can you do with "Column Block" mode?

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

#4 2012-10-09 13:52:43

maac2002
Member

Re: What can you do with "Column Block" mode?

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

#5 2012-10-09 16:25:57

sqldbxhelp
Administrator

Re: What can you do with "Column Block" mode?

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

#6 2012-10-10 09:30:44

garbuya
Member

Re: What can you do with "Column Block" mode?

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

#7 2013-07-01 05:54:05

aangelo
Member

Re: What can you do with "Column Block" mode?

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

#8 2013-07-01 09:22:12

sqldbxhelp
Administrator

Re: What can you do with "Column Block" mode?

Please provide examples of what you want to be able to do

Offline

#9 2013-07-03 03:43:49

aangelo
Member

Re: What can you do with "Column Block" mode?

Example:

12345678
12345678
12345678
12345678

1. 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
1234678

I 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

#10 2013-07-03 07:36:40

sqldbxhelp
Administrator

Re: What can you do with "Column Block" mode?

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

#11 2013-07-03 10:39:48

aangelo
Member

Re: What can you do with "Column Block" mode?

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

#12 2013-07-03 11:00:45

sqldbxhelp
Administrator

Re: What can you do with "Column Block" mode?

Ok. I think the problem is the font you have select for editor. Can you select Courier New and check if it helps

Offline

#13 2013-07-03 11:47:07

aangelo
Member

Re: What can you do with "Column Block" mode?

I've set Consolas as font in editor.
Now I set Courier New, restart SqlDbx, but I still have the same results.

Offline

#14 2013-07-03 12:20:44

sqldbxhelp
Administrator

Re: What can you do with "Column Block" mode?

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

#15 2013-07-04 03:08:56

aangelo
Member

Re: What can you do with "Column Block" mode?

Ok, this works. Thank you!

Offline

#16 2016-02-23 12:34:28

aangelo
Member

Re: What can you do with "Column Block" mode?

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.

aangelo wrote:

Example:

12345678
12345678
12345678
12345678

1. 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
1234678

I 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

#17 2016-02-23 23:33:58

sqldbxhelp
Administrator

Re: What can you do with "Column Block" mode?

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

#18 2016-03-18 08:16:08

garbuya
Member

Re: What can you do with "Column Block" mode?

aangelo,

Uncheck "Font is Proportional" in Editor settings and it will work with any font

Offline

#19 2016-06-08 04:17:42

aangelo
Member

Re: What can you do with "Column Block" mode?

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

#20 2017-04-05 06:33:11

aangelo
Member

Re: What can you do with "Column Block" mode?

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.

aangelo wrote:

Example:

12345678
12345678
12345678
12345678

1. 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
1234678

I expected to find "#" inserted in all lines, between 4 and 5.

Do I miss something?

Offline

Board footer

Powered by FluxBB