Subject Re[3]: [ib-support] Delete * with child fields.
Author Carlos H. Cantu
Thanks Ann ;)

[]s

Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com

AWH> 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 (???)

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


AWH> Regards,

AWH> Ann
AWH> www.ibphoenix.com
AWH> We have answers.



AWH> To unsubscribe from this group, send an email to:
AWH> ib-support-unsubscribe@egroups.com