بتاريخ: 6 يوليو 200817 سنة comment_132647 بسم الله الرحمن الرحيماخواني الاعزاء , انا الانى بصدد انشاء شجرة للنظام الذي اعمل عليه , وقررت انشاء شجرةلهذا النظام , وقمت بعمل الاتي : - بدايتا انشاء هذه ال view create or replace view tree_aa as select 'a0' as parint,'b1' as childer,'Preparing System' as name_ar from dual union all select 'a0' as parint,'b2' as childer,'Main File System' as name_ar from dual union all select 'a0' as parint,'b3' as childer,'Report System' as name_ar from dual union all select 'a0' as parint,'b4' as childer,'Help ' as name_ar from dual union all select 'b1' as parint,'c1' as childer,'Divisions' as name_ar from dual union all select 'b1' as parint,'c2' as childer,'Categories' as name_ar from dual union all select 'b1' as parint,'c3' as childer,'Jobs'as name_ar from dual union all select 'b1' as parint,'c4' as childer,'Users' as name_ar from dual union all select 'b1' as parint,'c5' as childer,'Employees' as name_ar from dual union all select 'b2' as parint,'d1' as childer,'Display Assets' as name_ar from dual union all select 'b2' as parint,'d2' as childer,'Delete Assets' as name_ar from dual union all select 'b2' as parint,'d3' as childer,'Request And Replay Assets' as name_ar from du union all select 'b3' as parint,'e1' as childer,'Divisions' as name_ar from dual union all select 'b3' as parint,'e2' as childer,'Categories' as name_ar from dual union all select 'b3' as parint,'e3' as childer,'Jobs' as name_ar from dual union all select 'b3' as parint,'e4' as childer,'Users' as name_ar from dual union all select 'b3' as parint,'e5' as childer,'Assets' as name_ar from dual union all select 'b3' as parint,'e6' as childer,'Delete Assets' as name_ar from dual union all select 'b3' as parint,'e7' as childer,'Request' as name_ar from dual / طبعا ناتج هذه ال view هو :- STATE LEVEL NAME_AR N TO ------- ---------- ------------------------- - -- 1 1 Preparing System b1 1 2 Divisions c1 1 2 Categories c2 1 2 Jobs c3 1 2 Users c4 1 2 Employees c5 1 1 Main File System b2 1 2 Display Assets d1 1 2 Delete Assets d2 1 2 Request And Replay Assets d3 1 1 Report System b3 STATE LEVEL NAME_AR N TO ------- ---------- ------------------------- - -- 1 2 Divisions e1 1 2 Categories e2 1 2 Jobs e3 1 2 Users e4 1 2 Assets e5 1 2 Delete Assets e6 1 2 Request e7 1 1 Help b4 وقمت بانشاء شاشة للشجرة , وبصراحة لا اعلم سبب عدم ظهور الداتا على الشجرة وسأقومبارفاقها .... يظهر مسج لي استعلام غير مقبول للشجرة الهرمية frm-473131ارجوا التكرم بمساعدتي ... tree2008.zip تقديم بلاغ
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.