On 16 Jan 2004 at 13:31, tdtappe wrote:

>Dynamic SQL Error
>SQL error code = -502
>Declared cursor already exists
>
>Does anybody know what can cause this error?
>For instance, which API calls? What kind of wrong API usage?

isc_dsql_set_cursor_name(). IBX use it with
component_name+random_number. Unfortunatelly, random number may be
not as random as they expect.

>BTW, I use FB 1.0.3 and Delphi 6 with IBX components.

Try to put Randomize to the start of your program.

SY, Dimitry Sibiryakov.