Request: command and shortcut key to duplicate from previous item or record in SQL window query grid

[Claus Pedersen]

I would like to have commands to duplicate the value of the field in the row just above the current row into the current row (Duplicate field). A command to copy data from the entire row above the current one into the current one would also be nice to have (Duplicate record).

In this way it is easy to make new record and have a quick access to copy values 'down' on the current row.

It should of course be possible to assign keyboards shortcut to these new commands.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Claus Pedersen]

Thanks

 

[Claus Pedersen]

Will this request make it into version 10? It seems like a simple thing to implement ...

 

[Marco Kalter]

It does indeed seem simple, but has not made it into 10.0. Maybe we can still add it...

 

[Claus Pedersen]

Thanks, if you could talk 'sugar'talk to the developers about this, this would be a really great new feature. Thanks again.

 

[Gustavo]

Claus,

It is possible to copy the entire line, though not as straightforward as you suggest (which is, of course, much better):
1. Select source line by clicking its far left marker;
2. Enable edit mode, insert new line;
3. Type something (there seems to be a bug; paste is only enabled after typing);
4. Select this target line by clicking its far left marker. Right-click and select Paste

HTH

Of course, when you need to copy only some of the fields, this is more a trouble than a helper, so the Copy Field would be really welcome.

Regards,
Gustavo

 

[Claus Pedersen]

Yes, it is primarily the 'Copy from previous field' feature that would be so nice to have. Otherwise you have to go to the field above, mark the data, copy, go to the field below again and insert the data.
And yes, I also use the copy record feature, which is also very usable.
I have not noticed any problems regarding inserting an entire line, though. I press + to add a new line, I mark the entire line below by clicking on the arrrow to the left, Ctrl-C to copy, use up arrow to go to the empty line, Ctrl-v to insert. This works.
How do you select the records to be updated? By rowid or using "For Update "?

 

[Gustavo]

As I'm not always sure of which lines will be updated, I use the rowid approach.

 

[Claus Pedersen]

This has finally been implemented in version 10 beta 7.
Thanks a lot, this is such a great feature for me :grin: