Merge two rows in UniDbGrid

[Ario.Paxaz]

Hi

 

How can  merge  two records (rows) in unidBGrid by use Drag & Drop.

Best Regards.

[Sherzod]

7 minutes ago, A.Soltani said:

How can  merge  two records (rows) in unidBGrid by use Drag & Drop.

Hi,

Please explain this with specific examples.

[Ario.Paxaz]

Quote

Please explain this with specific examples.

 

UnidBGrid show list of data that some fields is empty(no entered by user).
I want by drag & drop (for two rows), merge dragged (Source) row data into dropped (Destination) row.

This means after drop, update destination row data by source row data and then delete source row.
Source UnidBGrid  and Destination UnidBGrid  is same.

for example
row id 1 : 
       firstname: name1
       lastname: empty
       ordercount: 10
row id 2 :
       firstname: name1
       lastname: lastname1
       ordercount: 5

resault of DnD:

row id 1:
        firstname: name1
        lastname: lastname1
        ordercount: 15

row id 2 is deleted and not show in UniDbgrid.

 

 

Regards.

[Sherzod]

19 hours ago, A.Soltani said:

for example
row id 1 : 
       firstname: name1
       lastname: empty
       ordercount: 10
row id 2 :
       firstname: name1
       lastname: lastname1
       ordercount: 5

resault of DnD:

row id 1:
        firstname: name1
        lastname: lastname1
        ordercount: 15

row id 2 is deleted and not show in UniDbgrid.

Hello,

Well, is not it better to use a grouping in the query?

[Ario.Paxaz]

Hi

Quote

Well, is not it better to use a grouping in the query?

The user does not want all records with an empty field to be merged.

Rather, it wants to do so selectively.

 

Regards.

[Sherzod]

5 minutes ago, A.Soltani said:

The user does not want all records with an empty field to be merged.

Rather, it wants to do so selectively.

Ok, but next time, when users will open the dataset, what will happen? What's your logic?

[Sherzod]

Also this post may help you to some extent

 

[Ario.Paxaz]

Hi

 

After merge two row by user, changes must be saved in database.

Next time, when users will open the dataset, will see only one row(result of merge two row).

source row must be deleted from database(and not show in uniDbgrid) and destination row must be updated.

 

Regards.