The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

Editing cells in DBISL's result set pane is a nice feature, and as expected, one can copy & paste the contents of the edited cell.

However, that does not work for cells that have a NULL value currently: They do not accept pasted contents, independent of the fact whether the cell's displayed contents - "(NULL)" - is selected or not.

In order to allow to paste contents, I have to click on the "Edit in window" command, and then it's possible to paste into the window or directly into the cell.

That's somewhat uncomfortable...

BTW: Are there keyboard shortcuts to activate the "Edit in window" and "Set to NULL" commands and the while I'm editing a cell? That would be a nice enhancement, as editing should generally be doable without mouse actions.

Tested with on Windows 32-bit.

asked 28 Mar '12, 06:33

Volker%20Barth's gravatar image

Volker Barth
accept rate: 32%

edited 28 Mar '12, 06:35

Just to restate: According to Martin, the behaviour is different (and better) in 11.0.1. So may this be considered a bug or undesired behaviour in 12.0.1?

(30 Mar '12, 09:38) Volker Barth

Any comment from the SQL Anywhere tooling engineers would be very welcome:)

(03 May '12, 03:25) Volker Barth

For me editing a row and selecting the null cell and pressing ctrl-v inserts the clipboard text into that cell. Have I misundestood your approach?

permanent link

answered 28 Mar '12, 08:40

Martin's gravatar image

accept rate: 14%

No, you have fully understood my situation - however, exactly that does not work for me, unless I use the "Edt in window" command.

In contrast, inserting normal character does work, so it's really the CTRL-V command (and the according "Paste" command from the "Edit" menu) that is blocked/ignored. And if the cell is not null, then CTRL-V does work, too.

The behaviour is the same for numeric, text or date/timestamp columns.

(28 Mar '12, 09:44) Volker Barth
Replies hidden
Comment Text Removed

Sorry for the confusion, I have used dbisql v11.0.1. You are right with dbisql v12.0.1 I can reproduce your observation. You can press any char, afterwards also the ctrl-v works on the same cell (just a workaround).

(28 Mar '12, 10:30) Martin

Thanks for the re-check - and yes, the workaround is a good one I had not thought of.... Note, it takes a "backspace" or other deletion to remote the inserted char right before the CTRL-V:)

FWIW, CTRL-A does not work with NULL cells, either

(28 Mar '12, 10:36) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 28 Mar '12, 06:33

question was seen: 958 times

last updated: 03 May '12, 03:25