[firebird-support] Wirecrypt

I am a newbie, like a total newbie just exploring databases for the first time. I am using Lazarus and they all seem to prefer Firebird and lot of the documentation is geared that way. I have successfully downloaded and installed Firebird onto ElementaryOS Loki. I am trying to use DB Scema

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.

[firebird-support] "Invalid Cursor State"

Please consider the following SP: create or alter procedure SP_VAL_REGISTRAR_CANCELACION ( SUCURSAL smallint, ID_SOLICITUD_A_CANCELAR numeric(8,0)) returns ( ID_SOLICITUD_CANCELACION numeric(8,0)) as declare variable NUMERO_ITEM numeric(9,0); declare variable IMPORTE_UNITARIO