Скачать: CL | DM;

не редактирует DBEdit   Найти похожие ветки 

← →
Инна   (2003-06-03 11:20) [0]

по хп из ADODataSet достаю данные
CREATE PROCEDURE planperweeks;1
@group int, @potok int
AS
SET NOCOUNT ON
select distinct rasdispotok.code_of_dis, coalesce(disc0.name,"-") as Name_of_dis,
coalesce(disc0.full_name,"-") as FullName_of_dis,
coalesce(disc0.code_of_kaf,"-") as kaf_of_dis,

coalesce(lec.ID,"-") as LID,
coalesce(lec.subs,"-") as subs,
coalesce(lec.unions,"-") as unions,
coalesce(lec.hours,"-") as l_h,
coalesce(lec.code_of_prepod,"-") as code_of_lector,
coalesce(p1.name,"-") as Lector,


coalesce(sems.ID,"-") as SID,
coalesce(sems.subs,"-") as subs,
coalesce(sems.unions,"-") as unions,
coalesce(sems.hours,"-") as s_h,
coalesce(sems.code_of_prepod,"-") as code_of_seminarist,
coalesce(p2.name,"-") as Seminarist,

coalesce(labs.ID,"-") as LAID,
coalesce(labs.subs,"-") as subs,
coalesce(labs.unions,"-") as unions,
coalesce(labs.hours,"-") as la_h,
coalesce(labs.code_of_prepod,"-") as code_of_labprepod,
coalesce(p3.name,"-") as LabPrepod

from rasdispotok
left outer join lec on (lec.code_of_dis=rasdispotok.code_of_dis
and lec.code_of_group=@group)
left outer join sems on (sems.code_of_dis=rasdispotok.code_of_dis
and sems.code_of_group=@group)
left outer join labs on (labs.code_of_dis=rasdispotok.code_of_dis
and labs.code_of_group=@group)
left outer join prepodavatel p1 on (p1.ID = lec.code_of_prepod)
left outer join prepodavatel p2 on (p2.ID = sems.code_of_prepod)
left outer join prepodavatel p3 on (p3.ID = labs.code_of_prepod)
left outer join disc0 on (disc0.ID=rasdispotok.code_of_dis)
where rasdispotok.code_of_potok = @potok order by rasdispotok.code_of_dis
GO

вывожу на форму инфу и раскидываю ее по DBEditam - почему не дает исправлять???? во всех Эдитах = ReadOnly - false. неужели придеься дублировать обычными эдитами? :(((

---

← →
stone ©   (2003-06-03 12:05) [1]

> не редактирует DBEdit


Потому что возвращаемый рекордсет не редактируемый

---

← →
Инна   (2003-06-03 12:32) [2]

т.е. можно обойти только через обычные Эдиты???

---

Страницы: 1 вся ветка

Скачать: CL | DM;



Память: 0.45 MB
Время: 0.014 c