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

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

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

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

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

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

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

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

Great- I am pleased it worked out.

Richard