Главная страница
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.026 c
14-84613
Nikos
2003-06-09 16:40
2003.06.26
Вопрос по Database Desktop


3-83865
Rise
2003-06-02 12:03
2003.06.26
Access violation


1-84440
paa
2003-06-10 08:52
2003.06.26
Как программно узнать директорию


1-84108
Hog
2003-06-10 15:45
2003.06.26
Помогите разобраться с адресами STR и STR[1]...


4-84852
Керик
2003-04-25 20:47
2003.06.26
Сортировка