recursive - can this be done?
Posted on 2002-03-06
i have table that holds all the folders for a drive.
The table is made up like this:
FolderID (autonumber - Pr.Key)
Foldername (name of the folder...)
FolderLevel (C: = 0, Winnt = 1, System32 = 2, etc)
FolderParentID (FolderID of the parentfolder, if Winnt
has folderid 15, then system32 will
have 15 as folderparentID)
this way i am able to use this table several times in one query to show a folder-structure.
Another table holds the nt-security-settings for each folder (with the local and global groups)
but, u guessed, this is not exactly a nice way of working
so i was thinking of loading this into a treeview,
and i assume i will need some sort of recursive function(s) for it to accomplish.
is this correct?
if so, has anyone have any experience with this kind of thing?
again, if so, any directions...?