Re: [firebird-support] "Invalid Cursor State"

19.10.2017 18:11, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > The real nightmare of a programmer is not when the program doesn't work > and she/he doesn't know why; it's when the program does work and she/he > doesn't know why :)

Re: [firebird-support] "Invalid Cursor State"

On 19.10.2017 at 16:46, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > I´m not sure which was the solution that finally worked, as I´ve made > several changes, mostly on the execution order in my program (windows exe, > not FB). > I suppose there is some issues with ODBC

Re: [firebird-support] "Invalid Cursor State"

I´m not sure which was the solution that finally worked, as I´ve made several changes, mostly on the execution order in my program (windows exe, not FB). I suppose there is some issues with ODBC driver _and_ Clarion, but I´m not really sure about it. Regards 2017-10-18 15:19 GMT-03:00 'Leyne,

RE: [firebird-support] "Invalid Cursor State"

It´s an executable procedure which returns a parameter. It´s not a selectable procedure. Its the kind of SP you invoke like "execute procedure ... returning values ..." while selectable ones are usually called as "select ... from stored_procedure_name" I´ve managed to fix my issue, anyway.

Re: [firebird-support] "Invalid Cursor State"

Sean: It´s an executable procedure which returns a parameter. It´s not a selectable procedure. Its the kind of SP you invoke like "execute procedure ... returning values ..." while selectable ones are usually called as "select ... from stored_procedure_name" I´ve managed to fix my issue, anyway.

RE: [firebird-support] "Invalid Cursor State"

Dimitry: I do it all the time ... (read output parameters from executable procedures, using "call executable_sp" by ODBC). No issues with other SPs. Unless I missed something, your SP is missing the required SUSPEND to make the SP selectable. Regards 2017-10-17 15:38 GMT-03:00 Dimitry

Re: [firebird-support] "Invalid Cursor State"

Dimitry: I do it all the time ... (read output parameters from executable procedures, using "call executable_sp" by ODBC). No issues with other SPs. Regards 2017-10-17 15:38 GMT-03:00 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] : > 17.10.2017

Re: [firebird-support] "Invalid Cursor State"

17.10.2017 20:12, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > What am I doing wrong? You cannot fetch from non-select query. -- WBR, SD.