Re: START REPORT error.
Posted in 1996
Hi,
i guess your problem lies in this function, right after the two lets.
You open a comment with { that you don't close. I hope it works, when
you put a } at the end of the delete statement you obviously don't want
to use. Unfortunately i can't test it, as i have neither your database
nor your globals file.
Sincerely,
Roland
FUNCTION purge()
DEFINE l_count smallint,
l_count2 smallint
let l_count = 0
let l_count2 = 0
{DELETE FROM account
WHERE case_num in (SELECT account.case_num
FROM account, arc_temp
WHERE account.case_num = arc_temp.case_num)
DECLARE c_pointer3 CURSOR FOR
SELECT case_num from arc_temp
FOREACH c_pointer3 INTO g_case.case_num
delete from account where case_num = g_case.case_num
END FOREACH
END FUNCTION -- function purge