Thank you !
Regards
Philipp

2010/9/2 unordained <unordained_00@...>

>
>
> ---------- Original Message -----------
> From: "phfranzos" <phfranzos@... <phfranzos%40gmail.com>>
> > but I want it should rather look like follows:
> >
> > FIRST NAME NAME SEX CAR
> > Joe Miller male Buick
> > Ford
> > BMW
> > Chrysler
> > Monica Smith female Ford
> > Cadillac
> > Chevrolet
> > Toyota
> > Dodge
> > Jack Teller male Jeep
> > Pontiac
> > Ford
> ------- End of Original Message -------
>
> try something like:
>
> execute block returns (first_name varchar(50), name varchar(50), sex
> varchar
> (10), car varchar(30)) as
> declare variable r_first_name varchar(50);
> declare variable r_name varchar(50);
> declare variable r_sex varchar(30);
> declare variable r_car varchar(30);
> declare variable same_person integer;
> begin
> for select first_name, name, sex, car from some_table
> into :first_name, :name, :sex, :car do
> begin
> same_person = case when first_name = r_first_name and name = r_name then 1
> else 0;
> r_first_name = first_name;
> r_name = name;
> r_sex = sex;
> r_car = car;
> if (same_person = 1) then
> begin
> first_name = null;
> name = null;
> sex = null;
> end
> suspend;
> end
> end
>
>
>

[Non-text portions of this message have been removed]