Copy line in grid is not working

Gustavo

Member³
PLSD 7.1.2.1365

Code:
select rowid, myalias.* from mytable myalias;
1. Click the area right before the row indicator in the data grid to select the line.
2. Select copy.
3. Click the grid lock to enable editing.
4. Click the area right before the "work line" to select it.
5. Right click. Paste is not enabled.

This used to work fine and it is an awesome feature to generate data for tests. Can we have it back?
 
PLSD 7.1.3.1379

Code:
select myalias.* from mytable myalias for update;
5. Right click. The Paste-Option is available

BUT all Fields from the copied line are copied into the first Field of the pasted line.
 
PLSD 7.1.3.1378

Pasting does work when you right-click the concerning table (e.g. mytable) in the object browser and select 'Edit data'. This results in an SQL window with almost the same query, but with the 'lock' in the grid already enabled. Now pasting is possible.

Seems like a little bug.
 
Yes, now it works for me too. But I had a situation where the paste-option was grayed out and stayed grayed out. Too bad I cannot reproduce it.

Maybe it has to do with the copy/paste problems I sometimes have in the program editor too: occasionally I have to copy things twice before I can paste them.
 
I think I found something: it seems to depend on the position of 'rowid' in the statement.

When I use

Code:
select rowid, t.* from mytable t;
then pasting doesn't work.

But when I use
Code:
select t.*, rowid from mytable t;
then it does work.

Does that make sense???
 
Great! Same thing here, but at least now I can copy lines again. Thx!

Marco, can't you still reproduce it?

Regards
 
Back
Top