Its a pretty common sort of query but I am not sure which way to do it
�
I want to�count the number of�files belonging to a CAD,�(think of it as
counting the number of widgets a customer has brought), so that I can
prune the database if a CAD has more than 100 files.
�
The�psuedo would do something like:
�
for each�Customer in the Customer table do
� select count(widgets)
��� from orders
�
if count_widgets > 100 then
� Delete_widgets from orders where�(some_field > 100_value)���
�
I guess I can do the first part with a parameterised query...
�
My�brain is going to mush - I used to be able to do these queries no
problem..
�
Grant Black
Software Developer
SmartMove (NZ) Ltd
Phone:���� +64 9 361-0219 extn 719
Fax� :���� +64 9 361-0211
Email:���� [EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
