>Hi Sir,
>
>Is there a way to close everything at once instead of going through every cursor and closing each one of them?
>
>Please advice.
>
>Thanks,
>Sam
CLOSE DATABASE ALL or CLOSE TABLES ALL will certainly close a lot, or everything depending if dbc file exists/open. However, it is not what you try to get, correct? Basically, working with cursors it's better to treat them on case-by-case basis: you create it, use it and close it. If it is used within one procedure then close it at the end, if within one form then create in Load and close in Unload event.
Edward Pikman
Independent Consultant