Forums
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: