Subject | Re: [firebird-support] sql to check if a row has been used in related tables? |
---|---|
Author | Milan Babuskov |
Post date | 2007-03-27T16:41:04Z |
Lucas Franzen wrote:
master table (i.e. one) even if it deletes a thousand records in child
tables. Has this been changed in some recent versions of FB?
--
Milan Babuskov
http://www.guacosoft.com
http://www.flamerobin.org
> if all your fields are defined as foreign keys you can do a delete onLast time I checked the result is always the number of affected rows in
> the master record and get the AffectedRows. If the result is bigger than
> 1
master table (i.e. one) even if it deletes a thousand records in child
tables. Has this been changed in some recent versions of FB?
--
Milan Babuskov
http://www.guacosoft.com
http://www.flamerobin.org