Главная страница
Top.Mail.Ru    Яндекс.Метрика
Текущий архив: 2003.06.26;
Скачать: 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 вся ветка

Текущий архив: 2003.06.26;
Скачать: CL | DM;

Наверх




Память: 0.47 MB
Время: 0.022 c
1-84152
McSimm2
2003-06-11 10:33
2003.06.26
Плавный переход цвета из одного в другой


1-84242
VISA
2003-06-13 13:56
2003.06.26
TIniFile


4-84840
I:D
2003-04-25 18:09
2003.06.26
SetWindowLong(hwnd,GWL_WNDPROC,Integer(P));


14-84685
passlight
2003-05-23 09:56
2003.06.26
---|Ветка была без названия|---


14-84594
Viktor_bs
2003-06-08 18:14
2003.06.26
Delphi + XML