Subject | Re: [firebird-support] Re: Concatenated fields |
---|---|
Author | unordained |
Post date | 2010-01-21T19:41:47Z |
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@...>
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------- End of Original Message -------
> done with the newer LIST function. Should I migrate to 2.1? or is
> there any workaround for this issue in 1.5?
>
> Marcelo.