firebird stored procedure

2 отговора 0 прегледа
#1

firebird stored procedure

здр,
как може да се конкатенират два varchar-a в firebird stored procedure?
т.е. нещо от вида:

procedure(...)

tmp, somevariable varchar(xxx) - variables
somecondition integer - input parameter
result varchar(xxxx) - output parameter

for select somecolumn from sometable
where somefield = :somecondition
into :somevariable do begin
tmp := tmp + :somevariable;
end
result = tmp;
suspend
end
т.е suspend да върне като резултат somevariable1, somevariable2

Отговор
в отговор на st #2

Re: firebird stored procedure

procedure(...)

tmp, somevariable varchar(xxx) - variables
somecondition integer - input parameter
result varchar(xxxx) - output parameter
tmp='';
for select somecolumn from sometable
where somefield = :somecondition
into :somevariable do begin
tmp=:tmp||:somevariable;
end
result = tmp;
suspend
end

Отговор
в отговор на NDeu #3

Re: firebird stored procedure

tks

Отговор