>What can I do to clear the cursor? I only found out when I tried to process a couple of hundred records in the DO WHILE and got a maximum numbers of cursors exceeded error.
>Thanks in advance.
>Martin
DROP VIEW only removes the definition from the DBC, it does not close the view. For that, you need to issue:
USE IN MyView
Erik Moore
Clientelligence