Subject | Error SQL -502 |
---|---|
Author | viruxfr54 |
Post date | 2005-05-27T09:24:24Z |
hi all,
sorry for my english :(
i've a probleme with multithread application
i create 1 to 8 thread, each thread create dynamicaly a connection, a
transaction and some querys.
if in my application, i create 1 thread it's OK.
if i create more than 1, i've this error :
----------------------------
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -502
Attempt to reopen an open cursor
----------------------------
in other forum, someone say it's because Query build a cursor for
reference by server, and for build the cursor a random is use (
Queryname + RandomString(8), but the query is dynamic so they don't
have a name at create and more than 1 query have the same cursorname.
so i've add Randomize; before creating query, but that don't work :(
can you help me ?
thank
virux
sorry for my english :(
i've a probleme with multithread application
i create 1 to 8 thread, each thread create dynamicaly a connection, a
transaction and some querys.
if in my application, i create 1 thread it's OK.
if i create more than 1, i've this error :
----------------------------
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -502
Attempt to reopen an open cursor
----------------------------
in other forum, someone say it's because Query build a cursor for
reference by server, and for build the cursor a random is use (
Queryname + RandomString(8), but the query is dynamic so they don't
have a name at create and more than 1 query have the same cursorname.
so i've add Randomize; before creating query, but that don't work :(
can you help me ?
thank
virux