OKay,
habe das jetzt in 2 SQLs gepackt
und dann das UpdatePHP-Code:
create view qtemp/x as (
Select RowNumber() over (Partition by feld2 order by kunde, feld2, feld1) as pos,
kunde, feld1, feld2 from myfile )
GrußPHP-Code:
Update myfile a
set Feld3 =
(Select pos from x where a.kunde=x.kunde and a.feld1=x.feld1 and a.feld2=x.feld3)
Ronald
Bookmarks