| Subject | RE: [firebird-support] Delete with join and delete from multiple tables |
|---|---|
| Author | Helen Borrie |
| Post date | 2007-09-12T23:58:57Z |
At 02:09 AM 13/09/2007, you wrote:
delete rows from multiple tables, that won't change. It is one of
the tenets of SQL logic, not a Firebird limitation.
The limit (1499) on the number of members in a list of constants in
the argument to the IN() predicate is not a limitation for your
situation, since you are not using it.
./heLen
>HiWhich limitation are you referring to?
>
>
>
>Thanks a lot for all the good and prompt responses. I'd say this is
>an unfortunate limitation
>and I hope something more convenient is implemented in the future.If you mean the limitation that a single DELETE statement cannot
delete rows from multiple tables, that won't change. It is one of
the tenets of SQL logic, not a Firebird limitation.
The limit (1499) on the number of members in a list of constants in
the argument to the IN() predicate is not a limitation for your
situation, since you are not using it.
./heLen