More DBI question

[Gordon McMillan]

Timothy Grant wrote:
 
> Thanks Gordon, I appreciate the input. I'm am now going through my code
> and closing all cursors after I get the result table.
> 
> As I stop to think about it though, If I were to need to make a
> different query mid-fetch(), I would then need to open a separate cursor
> and use it. 

And hope that the driver supports multiple open cursors (a few 
widely used ODBC drivers don't).

> I'm significantly new enough to this type of DB programming
> that I just don't know what is good style and what is not.

Whatever you do, don't even THINK about isolation levels 
<wink>.

- Gordon