Subject Re[2]: [ib-support] Delete * with child fields.
Author Ann W. Harrison
At 04:39 PM 2/20/2001 -0300, Carlos H. Cantu wrote:
>Yeh Ann, I though about that too, but I think he wants a more "flexible"
>way where he dont need to specify the children table(s). Maybe using the
>system tables to retrieve the relations, but I dont know if this could be
>done in a single SQL (???)

I think it can't. Even doing very dynamic query generation, you'd
need to retrieve metadata before generating the query. I could do
it (sort of) in QLI by creating a procedure (QLI style, not a stored
procedure) that writes a file and then executes that file.


We have answers.