Реферат: Перенос приложений MIDAS с одной СУБД на другую
for select FROM_ID, TO_ID, sum(DOC_SUM)
from DOC_TITLE
where DOC_DATE >= :FROM_DATE and DOC_DATE <= :TO_DATE
group by FROM_ID, TO_ID
into :FROM_ID, :TO_ID, :FULL_SUM
do begin
FROM_NAME = NULL;
TO_NAME = NULL;
select NAME
from client
where CLIENT_ID = :FROM_ID
into :FROM_NAME;
select NAME
from client
where CLIENT_ID = :TO_ID
into :TO_NAME;
if (FULL_SUM is NULL) then
FULL_SUM = 0;
suspend;
end
end
^
Преобразуется в процедуру следующего вида:
|
create procedure rep_inout @from_date smalldatetime, @to_date smalldatetime as select dt.from_id, dt.to_id, isnull(sum(dt.doc_sum), 0) as full_sum, c.name as from_name, c1.name as to_name from doc_title dt, client c, К-во Просмотров: 378
Бесплатно скачать Реферат: Перенос приложений MIDAS с одной СУБД на другую
|