On Mon, 5 Nov 2001, Brian Hirt wrote:
> Stephan,
>
> Thanks for the reply. The ON DELETE CASCADE does the opposite of what i
> want. ie, you delete a primary key, and the foriegn key is deleted. In my
> sample, you are deleting the foriegn key, not the primary key.
>
> The function i included in the original message does select into a variable
> and it does delete the list row, but if the list has a next_id and the
> function is called recursively, that's when i get a stmt_execsql error.
I meant that I think this line:
SELECT delete_list_item(del_next_id);
needs to be something like
SELECT INTO foo delete_list_item(del_next_id);
or maybe
EXECUTE ''select delete_list_item(del_next_id)'';