Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 9 of 9 total |
DB Trees in EDB |
Mon, Sep 10 2018 10:15 PM | Permanent Link |
Richard Harding Wise Nutrition Coaching | Many years ago, before EDB, I bought Steve Forbes's KBase application to store useful bits of information. It used DBISAM. (I use Zotero now to store information which is really good.)
KBase organised Topics into a tree of Categories. Categories (ID, ParentID, Name, ListOfNodesFromRoot, . . . ) Topic (ID, CategoryID, Name, . . . .) When EDB arrived, I converted the application to a Elevate DB application, separating the tree structure into Nodes and Edges where the Node is a Category and the Edges define the relationship between the Nodes (Categories). Nodes (ID, NodeName) Edges (ParentID, NodeID) Topic (ID, NodeID, Topic, . . . .) There are two work tables along with the procedures to populate these tables when the Tree View stucture has been changed. Paths (StartNode, EndNode, PathLength) TreeView (ID, NodeID, IndentedNode, NodeName) Plus an Options table. Options (TreeViewVerticalChar, TreeViewHorizontalChar) The Paths table stores all the paths in the tree and allows you to get from one node to another node. The TreeView table is a sorted, character-based, indented Tree View. For example, Top +--Agriculture +--Databases +----Trees +--Literature +--Medicine +----Cardiology +----Diabetes +----Neurology +--Science +----Geology +----Mathematics +------Topology +--------Mapping +--------Regular Solids +----------Euler Formula Much more information regarding the tree is available. For example, you can find all sub-categories of a particular category or all topics belonging to a category and its sub-categories. Recently, I converted a reduced version of the Delphi application to an EWB application - to see if I could. I needed an EWB module to execute the procedures when the Tree structure is changed. (Thank you Uli) I have uploaded the EDB Backup file to the Binaries forum which may be of interest. Richard |
Wed, Sep 12 2018 4:49 AM | Permanent Link |
Matthew Jones | Richard Harding wrote:
> Many years ago, before EDB, I bought Steve Forbes's KBase application to store useful bits of information. It used DBISAM. (I use Zotero now to store information which is really good.) > > KBase organised Topics into a tree of Categories. > > Categories (ID, ParentID, Name, ListOfNodesFromRoot, . . . ) > Topic (ID, CategoryID, Name, . . . .) > > When EDB arrived, I converted the application to a Elevate DB application, separating the tree structure into Nodes and Edges where the Node is a Category and the Edges define the relationship between the Nodes (Categories). > Interesting. A) useful starting point for people, so thanks, and B) We still use kbase as it was supplied! Slowly migrating away to other things but it still works... -- Matthew Jones |
Wed, Sep 12 2018 3:53 PM | Permanent Link |
Richard Harding Wise Nutrition Coaching | Matthew
It can be really frustrating to know that you have seen some really useful information - whether it was yesterday or years ago, and you just do not know where to find it. The RTF editor in KBase was rather ordinary - it frequently messed up lists which is why I rewrote it in the first place. Richard |
Tue, Sep 15 2020 4:43 AM | Permanent Link |
alexza | Hi Richard,
thanks for this, I'm trying to implement a DBTree. I downloaded your backup but it doesn't restore. Any info on the EDB version needed? Thanks in advance Alex alex @ www.zring.it |
Wed, Sep 16 2020 3:42 PM | Permanent Link |
Richard Harding Wise Nutrition Coaching | Hello Alex
I am using EDB v 2.28. Character set is ANSI. Did you restore the catalog file? Click on the Selection tab and check the Restore Catalog from backup. Richard |
Thu, Sep 17 2020 3:03 AM | Permanent Link |
alexza | Hello Richard, and thanks.:
The point is exactly this. There's no catalog in the backup, as per the attached Details form in EDBManager 2.24. I doubt the version is paramount, 'cause the backup file is a couple years old. What am I doing wrong? Alex Hello Alex I am using EDB v 2.28. Character set is ANSI. Did you restore the catalog file? Click on the Selection tab and check the Restore Catalog from backup. Richard alex @ www.zring.it Attachments: KBase.jpg |
Fri, Sep 18 2020 2:40 AM | Permanent Link |
Richard Harding Wise Nutrition Coaching | Hello Alex
<<There's no catalog in the backup, as per the attached Details form in EDBManager 2.24.>> I downloaded the "KBaseII-Backup_2018-09-11-1237.EDBBkpbackup" file from the Binaries forum and restored the database into a brand new database using EDB Manager v2.28, restoring the catalog from backup. All is well. When I show the details for the backup, it shows the catalog file is present. I downloaded EDB Manager v2.24 and was able to restore "KBaseII-Backup_2018-09-11-1237.EDBBkp". Catalog file is there. If there was a problem with the format of the catalog file then I would expect a different error. Could it be a privileges issue? I have attached a zip file of the database which does contain the catalog file. Another item to add to the extensive list of things that I do not understand. Richard Attachments: TESTING.zip |
Fri, Sep 18 2020 8:34 AM | Permanent Link |
alexza | Hello Richard and thanks a lot for your time.
It was a charset problem but I solved it with your attachment. This forum is a great place, as you just proved. Thanks again Alex alex @ www.zring.it |
Fri, Sep 18 2020 7:46 PM | Permanent Link |
Richard Harding Wise Nutrition Coaching | Great- I am pleased it worked out.
Richard |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |