UniDBGrid reordering rows using drag&drop

[mika]

I know drag&drop using two UniDBGrids are discussed and there are even demo about it but how about dragging and dropping inside one grid? I have data in which rows are ordered by indexed row number and I'd like to add feature where user can drag rows to different positions and when user does that, row numbers are updated in the background accordingly. What is the easiest and more importantly, correct way to achieve this?

[Sherzod]

Hi,

 

Do you want to drag and drop on the same grid?!

 

Best regards.

[mika]

Yes I do. Idea is to let user reorder records by using mouse.

[Kachar ganyalong]

I'm waiting for this answer too, I'm gonna need it.

[Sherzod]

I will try to make a small test case for this...

[Sherzod]

Can you try this testcase ?!:

 

 

DragDropInSameGrid.rar

 

 

[Kachar ganyalong]

Tested and it's works, Wow

Can you try this testcase ?!:

 

DragDropInSameGrid.png

 

DragDropInSameGrid.rar

[mika]

Awesome. This is A-class service. Thank you so much!

[Sherzod]

Thank you!

[du1000brazil]

Hello I made a change in the code to do with multiple lines. The problem is when we move 2 lines. Locate on the grid to stop working.

[du1000brazil]

Hello I made a change in the code to do with multiple lines. The problem is when we move 2 lines. Locate on the grid to stop working.

Você pode experimentar este testcase?

 

DragDropInSameGrid.png

 

DragDropInSameGrid.rar

 

Unigui version:1.0.0.1425

Follow code in the link:

DragDropInSameGrid_teste.rar

[AmericoKutomi]

On 3/24/2017 at 6:11 AM, Sherzod said:

Can you try this testcase ?!:

 

 

DragDropInSameGrid.rar

 

 

I had the same problem and thank you for this solution!

[kalilxd11]

 n

[Sherzod]

1 minute ago, kalilxd11 said:

Someone could provide the download link for this example, I can't download it, it's unavailable.

Hello,

Sorry, are you still using the trial version?

[kalilxd11]

a

[Sherzod]

Please adjust your forum email address first:

 

[Sherzod]

 

[Sherzod]

30 minutes ago, kalilxd11 said:

... since you don't want to help me.

This is not true.

31 minutes ago, kalilxd11 said:

I'm just the developer

Tell them to add your email address. 

And read about the license agreement please!

 

[Kurt]

Hi,

how will i handle the database event of this? my scenario is:

1. i have a column that is a sequence/series
2. i want to reorder the sequence of the field


example:

seq, product_name
1, PRODUCT A
2, PRODUCT B
3, PRODUCT C


when i move the product B under the PRODUCT C i want the record to be:

seq, product_name
1, PRODUCT A
2, PRODUCT C
3, PRODUCT B

any idea how to implement it?

[Kurt]

7 minutes ago, Kurt said:

Hi,

how will i handle the database event of this? my scenario is:

1. i have a column that is a sequence/series
2. i want to reorder the sequence of the field


example:

seq, product_name
1, PRODUCT A
2, PRODUCT B
3, PRODUCT C


when i move the product B under the PRODUCT C i want the record to be:

seq, product_name
1, PRODUCT A
2, PRODUCT C
3, PRODUCT B

any idea how to implement it?

nevermind... i just checked the source code of sample. its already there... thanks.....