| how to build a tree like win explorer? [message #86219] |
Sun, 12 September 2004 22:46 |
hmb
Messages: 1
Registered: September 2004
|
Junior Member |
|
|
Hi Tom,
I want to build a tree and objects related to every branch of the tree , just like windows explorer .
I have created a table fro the tree and its objects and this is the create statement:
CREATE TABLE SEC_OBJECTS
)
OBJ_ID NUMBER(10) ,
OBJ_PARENT NUMBER(10) ,
OBJ_DESC VARCHAR2(100),
OBJ_MAIN NUMBER(1(,
FILE_NAME VARCHAR2(100(,
SIGN VARCHAR2(255(
(;
> OBJ_ID = The object id even if it an object or a branch of the tree. It is concat between the object id and its parent id. The (ID) of object number 1 under parent 1 will be (11) .
> OBJ_PARENT= The id of the object’s parent object , but for the tree root the parent will (0) by default.
> OBJ_DESC= the object name or describtion.
> OBJ_MAIN= it has tow values (1) if the object could be parent for a nother object
(2) if the object is terminal (child) .
> FILE_NAME= the name of the (fmx) file to run it. It is only for terminal objects.
> SIGN= the object logo that appears in the tree.
Actualy I have done it but the problem it is very slow, I mean when I click on a branch in the tree to display it’s objects (children) the logos take several minutes to appear because I used loop in the code to display the objects’ logos in non database image fields.
<IMG alt="this the result i got but it is very slow!" hspace=0 src="http://azal.jeeran.com/test.JPG" align=baseline border=0>
<v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600">This shape shows the result I've got now but i'm afraid it is very slow!</v:shapetype>
<v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"></v:shapetype>
<v:shapetype stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"> </v:shapetype>I wonder if ther is a nother way to make it faster just like the windows explorer???
Thannkyou ,,,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
