My Visual Database — treeview moving parent

Re: treeview moving parent

null@example.com (AD1408) — Thu, 13 Mar 2025 05:49:30 +0000

Hi Sparrow,

Thank you very much for the info.

Re: treeview moving parent

null@example.com (sparrow) — Wed, 12 Mar 2025 20:34:21 +0000

I added values 1...4

Re: treeview moving parent

null@example.com (AD1408) — Wed, 12 Mar 2025 18:22:19 +0000

Thank you very much........

I tried to browse db using SQL Lite Studio but couldn't locate the value you have added in the record_count column. I'm fairly ignorant on using SQL Lite Studio.

I guess Issue is caused by old project I was trying to use.

Re: treeview moving parent

null@example.com (sparrow) — Wed, 12 Mar 2025 16:06:18 +0000

The database table did not contain any values in the record_count column.

Re: treeview moving parent

null@example.com (AD1408) — Wed, 12 Mar 2025 14:39:25 +0000

sparrow wrote:

HI Adam
....
For changing the PLACE WITHIN ITS NODE I gave the link above.
...

Thanks... It would have been great if it could be done both. However, what you guys have done truly appreciated...

I got the script you refer. I originally asked to Dmitry for the script - moving nodes on same level.
I get it work sometimes OK sometimes not.

For instance, the attached sample project I couldn't get it working. I checked syntax etc., but couldn't find the cause of failure.

Re: treeview moving parent

null@example.com (sparrow) — Wed, 12 Mar 2025 13:25:56 +0000

HI Adam

Perhaps you are talking about moving WITHIN ITS NODE (changing the location)? Yes, that is not the case.
Our solutions with Derek for moving between nodes and changing the binding in the database.

For changing the PLACE WITHIN ITS NODE I gave the link above.

If we are talking about different things, can we take a look at your example?

Re: treeview moving parent

null@example.com (AD1408) — Wed, 12 Mar 2025 12:26:29 +0000

sparrow wrote:

Hi all,

With Derek's permission, here are two versions of the example of dragging tree nodes with the mouse in one archive.
Derek's corrected version and my version. Both versions do the same job. Hopefully without any major errors this time.

Hi Sparrow,
If I'm not doing something wrong, cannot move node up and down on same level. Moved node goes as a child.

Re: treeview moving parent

null@example.com (AD1408) — Fri, 21 Feb 2025 07:28:20 +0000

Hi Guys,
Thank you very much for tree nodes drag n drop....
Santa arrived to MVD bit late but still truly appreciated the Gift.....

Re: treeview moving parent

null@example.com (derek) — Thu, 20 Feb 2025 23:28:21 +0000

Hey Sparrow,
No permission needed - it's good when we can all exchange ideas on the Forum and make suggestions to each others' projects. Everyone wins.
I really like the ''scrolltree'' procedure that you've added - I was looking at the problem but didn't manage to find a fix.
Thanks for your interest and input.
Derek.

Re: treeview moving parent

null@example.com (sparrow) — Thu, 20 Feb 2025 14:48:46 +0000

Hi all,

With Derek's permission, here are two versions of the example of dragging tree nodes with the mouse in one archive.
Derek's corrected version and my version. Both versions do the same job. Hopefully without any major errors this time.

Re: treeview moving parent

null@example.com (sparrow) — Wed, 19 Feb 2025 12:36:05 +0000

derek wrote:

Hi Sparrow,
Yes, I see the problem now.
I'll have a look later on and see if it can be fixed.
Thanks,
Derek.

Derek look at one more thing. If the tree is larger than the height of the TreeView component.

Re: treeview moving parent

null@example.com (sparrow) — Wed, 19 Feb 2025 12:23:43 +0000

Corrected and supplemented version of the example.
Removed unnecessary code and elements.
Fixed errors, added new ones.

Re: treeview moving parent

null@example.com (derek) — Wed, 19 Feb 2025 12:15:35 +0000

Hi Sparrow,
Yes, I see the problem now.
I'll have a look later on and see if it can be fixed.
Thanks,
Derek.

Re: treeview moving parent

null@example.com (sparrow) — Wed, 19 Feb 2025 12:11:34 +0000

derek wrote:

(Line24 - "if (form1.edit3.value <> form1.edit1.value)" to stop the ParentID being set to the ID and the node disappearing).
Derek.

The problem occurs when a node with child records is moved and one of the child records is selected as the target for moving.
Let's say the fifth row is moved along with its child rows, the sixth and seventh.
If you specify the sixth or seventh as the insertion location, the problem will occur.

Re: treeview moving parent

null@example.com (derek) — Wed, 19 Feb 2025 11:33:48 +0000

Hi Sparrow, Jean,
I had the same problem but thought that I'd fixed it in the script (Line24 - "if (form1.edit3.value <> form1.edit1.value)" to stop the ParentID being set to the ID and the node disappearing).
Any chance you can give me a 'step by step' example of the problem you've found as I can't re-create it and then I can try to correct it.
Thanks for your help,
Derek.