Re: Closing Cursors and ODBC (How To?)

From: Hugh Pendry <hpendry_at_trinitech.nospam.co.uk>
Date: Wed, 23 Feb 2000 16:23:44 -0000
Message-ID: <8911ih$83o$1@trinitech.demon.co.uk>

Yes this is one of the things I have tried, and the same problem is still there.

(I call SQLFetch in a loop once for each ref cursor and call SQLMoreResults between each loop. Presumably this shouldn't make any difference?)

rock_cogar_at_my-deja.com wrote in message <890lg7$npj$1_at_nnrp1.deja.com>...
>Hugh,
>
>Does this open cursor problem occur when you use the call sequence of:
>
>SQLAllocStmt()
>SQLExecDirect()
>SQLFetch() // in a loop
>SQLFreeStmt()
>
>?
>
>Rock.
Received on Wed Feb 23 2000 - 10:23:44 CST