Looking for a Data Aware Outline and/or Tree control 
Author Message
 Looking for a Data Aware Outline and/or Tree control

Anyone know where I can find an OCX or VBX Data aware Outline or Tree
Control?  Please pass on any info or experiences you've had!

Alan King



Thu, 14 Jan 1999 03:00:00 GMT  
 Looking for a Data Aware Outline and/or Tree control

Quote:

>Anyone know where I can find an OCX or VBX Data aware Outline or Tree
>Control?  Please pass on any info or experiences you've had!

Just out of curiousity, what would a data aware outline do?

John



Fri, 15 Jan 1999 03:00:00 GMT  
 Looking for a Data Aware Outline and/or Tree control

We've been looking for a Data Aware outlint control for over a year now. So
far no luck.
InfoSleuth have a data bound outline, but unfortunately it requires that you
restructure your database around it (it needs special tables) and use ODBC,
neither of which we wanted to do.
Bennet-Tec were making noises about a data bound TList control, but I havn't
heard anything from them for a while.
There's an interesting control called MyControl, which appears to be a general
purpose data binding control that might be adaptable to any outline, but it
seems still in beta.
What we want?
We're after a control similiar to the databound outline that comes with the
Access Developers Kit (useless for VB). We want to assign different SQL
statements to the different levels of the outline, preferably based on a
condition above,
        L1:SELECT ItemType FROM Items
        L2: SELECT ItemName FROM Items WHERE ItemType=<something above>
        L3: SELECT <something> FROM Items WHERE <something is conditional from
above>
We also need mutiselection capability, preferably one that can (optionally?)
put its selection into a queryable form so that we can perform operations on
the selection. Most controls have a selected items collection, but you need to
copy its entire contents into a temporary table to base your, say, update
queries on it.. not very practical with 40000+ items selected in our
application. It'd be great to have a control that automatically handles a
specified table (if desired, not required), then do an update query like
"UPDATE <blah> WHERE ItemName in (SELECT SelectionID FROM MySelectionTable)"
Any third party supplies with something like this please respond, we're ready
to buy now.
Philip Pulle



Quote:


>>Anyone know where I can find an OCX or VBX Data aware Outline or Tree
>>Control?  Please pass on any info or experiences you've had!

>Just out of curiousity, what would a data aware outline do?

>John



Sat, 16 Jan 1999 03:00:00 GMT  
 Looking for a Data Aware Outline and/or Tree control



Quote:
>Just out of curiousity, what would a data aware outline do?

>John

What would it do?
The current explorer style of selecting things and doing operations on them,
is to have a tree on the left, pick an item, then do something based on its
properties on the right. Eg pick a folder, do stuff (delete/rename etc) to its
contents.
The tree can class the items eg folders, Internet, Network Neighborhood
computers, printers making it a familiar for the user to navigate about a set
of items grouped by criteria.
We want to do the same thing with our database items, we want to group by a
set of criteria our items based on their field values. Grids used with a
query can do this, but don't show it in a collapsable, plus/minus iconed
format like the tree.
Phil


Sat, 16 Jan 1999 03:00:00 GMT  
 Looking for a Data Aware Outline and/or Tree control


[snip]

I did this by adding a field called parent to my database.  I store
the key name of the node in this field and queried the database when
the node was clicked on.  Records could be dragged within the tree or
from the dbgrid displaying them.  Records without parents were
displayed under a Node called 'Home'.

Jeff

"Why do they put braille characters on drive-up ATM machines?"



Sat, 16 Jan 1999 03:00:00 GMT  
 Looking for a Data Aware Outline and/or Tree control



Quote:

>[snip]

>I did this by adding a field called parent to my database.  I store
>the key name of the node in this field and queried the database when
>the node was clicked on.  Records could be dragged within the tree or
>from the dbgrid displaying them.  Records without parents were
>displayed under a Node called 'Home'.
>Jeff

Are you moving the data in the records manually (via code) from the dbgrid (or
whatever recordset) to and from the tree? We'd prefer that the tree was
populated by the control via its 'data awareness'. This means if I have 40000
records, then the control is smart enough to only show the 20 odd records in
the tree that are visible, then if it scrolls it pulls data from the
appropriate spot in the recordset.
Or are you somehow embedding a grid in the tree?
Phil


Sun, 17 Jan 1999 03:00:00 GMT  
 
 [ 6 post ] 

 Relevant Pages 

1. Looking for Data Aware Outline and/or Tree Control!!

2. help: look 4 data-aware grid 4 codebasic

3. Looking for Outline Control Informations

4. Looking for a good outline control

5. Bug in Microsoft Data-Aware controls

6. Data aware (bindable) user control (HOW TO?)

7. Data Aware Controls

8. Data-aware combo control

9. Q: Data-Aware Controls -- how to create them

10. Data Aware Controls

11. data aware controls

12. Freeware data aware controls?

 

 
Powered by phpBB® Forum Software