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 :)
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
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,
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.
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.
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
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
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.
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