Subject Re: [firebird-support] Re: Concatenated fields
Author unordained
In 1.5, you could write a stored procedure. Approx. solution (not tested) below.

create procedure x returns (team varchar(50), name varchar(32000)) as
declare variable lt varchar(50);
declare variable t varchar(50);
declare variable n varchar(100);
begin
name = '';
for select team, name from master left join slave on slave.fkidteam =
master.idteam into :t, :n order by team do
begin
if (team != t) then
begin
lt = team;
suspend;
name = '';
end
team = t;
name = name || (case when name != '' then '/' else '') || n;
end
if (team != lt) then
suspend;
end


select team, name as players from x;

---------- Original Message -----------
From: "pcpower099" <mmartinez@...>

> I read that it could be
> done with the newer LIST function. Should I migrate to 2.1? or is
> there any workaround for this issue in 1.5?
>
> Marcelo.
------- End of Original Message -------