SQL Error = -502
Hola, tengo un error que me dice "Dynamic SQL Error = -502. Declared cursor already exists" estoy utilizando interbase y cuando me sale el error la única forma de que se puede solucionar es saliendo del programa. No tengo ni idea en qué momento me aparece. Les rogaría me ayuden a saber cuándo ocurre el error. Gracias.
1 respuesta
Respuesta
1
No lo sé pero he encontrado esto que quizá te sirva:
Each time you need to work on ib database, ib api requires a cursor
name. This cursor name is maked as a random string, but this random
generation isn't too safe...
Try to search "randomstring" in ibx source code....
Which ibx control type are you using? If it's a tibquery change it with
tibsql. Also, if you want to use a tibquery, CLOSE QUERY AFTER OPERATION:
MyQuery.Close;
MyQuery.ParambyName('p1').AsSomeType := MyValue1;
...
MyQuery.Open;
MyQuery.Close;
in ibx for d5 you MUST close query before change parameters value...
Changing params value doesn't close query object.
Each time you need to work on ib database, ib api requires a cursor
name. This cursor name is maked as a random string, but this random
generation isn't too safe...
Try to search "randomstring" in ibx source code....
Which ibx control type are you using? If it's a tibquery change it with
tibsql. Also, if you want to use a tibquery, CLOSE QUERY AFTER OPERATION:
MyQuery.Close;
MyQuery.ParambyName('p1').AsSomeType := MyValue1;
...
MyQuery.Open;
MyQuery.Close;
in ibx for d5 you MUST close query before change parameters value...
Changing params value doesn't close query object.