Subject Error SQL -502
Author viruxfr54
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