Forums

ASP

This topic is locked

closing recordset when not sure it exists

Posted 10 Oct 2006 13:43:15
1
has voted
10 Oct 2006 13:43:15 Dave Clarke posted:
i have a page with 4 recordsets, two of them are there all the time but the other 2 are filtered by the first 2 and so may or may not exist.
page works fine but produces errors when closing the last 2 recordsets because if they don't exist they cannot be closed obviously.
how do i tell if they exist and close them accordingly????

do i need to close them? could i just set them to nothing instead
<b>Set Recordset = Nothing</b>


thanks

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome.
www.reunite.co.uk

Edited by - Davecl on 10 Oct 2006 13:59:51

Replies

Replied 13 Oct 2006 12:11:59
13 Oct 2006 12:11:59 Dave Clarke replied:
anybody??

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome.
www.reunite.co.uk

Reply to this topic