1 Topic by v_pozidis (edited by v_pozidis 2018-09-18 05:49:42)

  • Registered: 2014-09-06
  • Posts: 803

Topic: copy and paste selected rows in tablegrid

Is there a way to copy selected rows from a tablegrid and paste them in another tablegrid ?
in a previous topic you give us a solution copy to clipboard   http://myvisualdatabase.com/forum/viewtopic.php?id=4553

  • Registered: 2014-02-14
  • Posts: 10,294

Re: copy and paste selected rows in tablegrid

When we talk about database, it's not usual operation like copy and paste.
What do you mean paste? Do you want to copy selected rows to another database table? or for the same database table? With all data? or just like link? (foreign key)


Please describe your situation in more details.

Dmitry.

3 Reply by v_pozidis (edited by v_pozidis 2018-10-22 10:00:06)

  • Registered: 2014-09-06
  • Posts: 803

Re: copy and paste selected rows in tablegrid

Hi Dmitry, welcome back.
1) Can I multi select rows from a tablegrid and delete those instead delete one by one ?

2) is there a way to paste paste selected rows from one tablegrid to another ? Like when I cope selected rows from one excell sheet to paste those to another sheet.

I use currently the 4.2 version

  • Registered: 2014-02-14
  • Posts: 10,294

Re: copy and paste selected rows in tablegrid

v_pozidis wrote:

Hi Dmitry, welcome back.
1) Can I multi select rows from a tablegrid and delete those instead delete one by one ?


You can download latest beta version, now you can set option for the TableGrid: Additional > Options > goMultiSelect = True, to delete multiselect records using button with action "Delete Record"
https://www.dropbox.com/s/yagi074bd24ox … a.zip?dl=0


or you can use this example, how to do it using script
http://myvisualdatabase.com/forum/misc. … download=1



v_pozidis wrote:

2) is there a way to paste paste selected rows from one tablegrid to another ? Like when I cope selected rows from one excell sheet to paste those to another sheet.

I use currently the 4.2 version


You can't directly paste rows from one tablegrid to another tablegrid, but you can insert data to database table, then you can update TableGrid to show them.


These tablegrids shows data from the same database table?

Dmitry.
  • Registered: 2014-09-06
  • Posts: 803

Re: copy and paste selected rows in tablegrid

DriveSoft wrote:
v_pozidis wrote:

Hi Dmitry, welcome back.
1) Can I multi select rows from a tablegrid and delete those instead delete one by one ?


You can download latest beta version, now you can set option for the TableGrid: Additional > Options > goMultiSelect = True, to delete multiselect records using button with action "Delete Record"
https://www.dropbox.com/s/yagi074bd24ox … a.zip?dl=0


or you can use this example, how to do it using script
http://myvisualdatabase.com/forum/misc. … download=1



v_pozidis wrote:

2) is there a way to paste paste selected rows from one tablegrid to another ? Like when I cope selected rows from one excell sheet to paste those to another sheet.

I use currently the 4.2 version


You can't directly paste rows from one tablegrid to another tablegrid, but you can insert data to database table, then you can update TableGrid to show them.


These tablegrids shows data from the same database table?




No, when copy from one tablegrid to transfer them (paste) to another project.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: copy and paste selected rows in tablegrid

It's possible, but unfortunately I can't make example for you, need to much time to make it.

Dmitry.