Claus Pedersen
Member³
I have some data, with something like 100 lines with 6 tab-separated numbers (between 0 and 9), like this:
I copy this data.
I have an empty table containing 6 number columns.
I select the columns for update in an SQL window: "SELECT n1,n2,n3,n4,n5,n6 FROM myTable FOR UPDATE" where n1..n6 are my table's number columns.
Now I get an empty result grid. I press the lock symbol to be able to edit data. I now mark all 6 columns by Ctrl-clicking them individually and tries to insert (Paste). This does not work, as the Paste option in the context menu is not enabled. I now place the cursor in the first enterable field and mark all 6 columns again. Now I can paste, but only the last column (n6) is filled in, the 5 columns before are left empty. It is the last column of the tab-separated numbers that is pasted in.
I execute my select again, to flush data. I now press the asterisk and the resulting arrow symbol to mark all columns and paste. Now 5 columns of data are inserted, but in the wrong columns. Column 6 (n6) is left empty and column 1 of my data is missing.
I start over and this time positions the cursor in column 1 (n1) and press the left- and top-most square to mark all. In this mode, the copy-paste seems to be working, but only every second time, in the other cases I get the type of errors as described above.
Is this a known issue, and will it be corrected in version 8?
Code:
1<tab>2<tab>3<tab>4<tab>5<tab>6
6<tab>5<tab>4<tab>3<tab>2<tab>1
(etc. x 100 lines)
9<tab>8<tab>7<tab>6<tab>5<tab>4
I copy this data.
I have an empty table containing 6 number columns.
I select the columns for update in an SQL window: "SELECT n1,n2,n3,n4,n5,n6 FROM myTable FOR UPDATE" where n1..n6 are my table's number columns.
Now I get an empty result grid. I press the lock symbol to be able to edit data. I now mark all 6 columns by Ctrl-clicking them individually and tries to insert (Paste). This does not work, as the Paste option in the context menu is not enabled. I now place the cursor in the first enterable field and mark all 6 columns again. Now I can paste, but only the last column (n6) is filled in, the 5 columns before are left empty. It is the last column of the tab-separated numbers that is pasted in.
I execute my select again, to flush data. I now press the asterisk and the resulting arrow symbol to mark all columns and paste. Now 5 columns of data are inserted, but in the wrong columns. Column 6 (n6) is left empty and column 1 of my data is missing.
I start over and this time positions the cursor in column 1 (n1) and press the left- and top-most square to mark all. In this mode, the copy-paste seems to be working, but only every second time, in the other cases I get the type of errors as described above.
Is this a known issue, and will it be corrected in version 8?