Martin wrote:
> BUT: Your db may not allow deleting from a table referenced in a subquery.
> Solution: Run the subquery, store in a temp table then run the main query
> linked to the temp table:
Not keen on using temp tables (it's Interbase, and I've never tried
'em in that), but if the other suggestion I've had doesn't work out,
it DOES make sense to go that way.
Thanks.
cheers,
peter
============================================
Peter Hyde, SPIS Ltd, Christchurch, New Zealand
* Print-to-Web automation http://TurboPress.com
* Web design, automation and hosting specialists
* TurboNote: http://TurboPress.com/tbnote.htm
-- small, FREE and very handy
Find all the above and MORE at http://www.spis.co.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
