Then the new SP remains:
create or alter procedure VER_EDAD (
N_EDAD numeric(15,4),
SEPARADOR varchar(1),
CORTO char(1))
returns (
C_EDAD varchar(8))
as
begin
/* Procedure Text */
if (separador is null) then
separador = ' ';
if (corto is null) then
corto = 'N';
On 23-10-2018 17:31, Germán Balbi bal...@yahoo.com [firebird-support] wrote:
> in the netx SP send the follow parameters
> 5,' ','N' --->>>5 Años (perfect)
> 5,'','N' --->>>5 Años ( not 5Años) without space of separation >:(
>
> create or alter procedure VER_EDAD (
> N_EDAD numeric(15,4),
>
23.10.2018 17:31, Germán Balbi bal...@yahoo.com [firebird-support] wrote:
> in the netx SP send the follow parameters
Read Firebird Language Reference to find out the difference between CHAR and
VARCHAR
data types.
--
WBR, SD.
Hi.in the netx SP send the follow parameters5,' ','N' --->>>5 Años (perfect)
5,'','N' --->>>5 Años ( not 5Años) without space of separation
create or alter procedure VER_EDAD (
N_EDAD numeric(15,4),
SEPARADOR char(1),
CORTO char(1))
returns (
C_EDAD varchar()
as
begin
/*
