Hi Bernhart,

Your data doesn't have record order info in it which makes it impossible to achive what you want with UPDATE-SQL command. If you add column that defines data order than it becames simple

CREATE CURSOR CmdMedic ( pk I autoinc, cNom C(20) , nGroup I )
INSERT INTO CmdMedic ( cNom ) VALUES ( 'Temesta 2.5' )  	&& I want 1 For ngroup
INSERT INTO CmdMedic ( cNom ) VALUES ( 'Aspirine' ) 		&& I want 1 For ngroup
INSERT INTO CmdMedic ( cNom ) VALUES ( 'Temesta 2.5' ) 		&& I want 2 For ngroup
INSERT INTO CmdMedic ( cNom ) VALUES ( 'Fluimycyl' ) 		&& I want 1 For ngroup
INSERT INTO CmdMedic ( cNom ) VALUES ( 'Rofenid' )			&& I want 1 For ngroup
INSERT INTO CmdMedic ( cNom ) VALUES ( 'Temesta 2.5' )		&& I want 3 For ngroup

UPDATE CmdMedic SET nGroup = (SELECT COUNT(*) FROM CmdMedic cm2 ;
		WHERE cm2.cNom = CmdMedic.cNom AND cm2.pk < CmdMedic .pk) + 1

>
>I have a count probleme.
>
>

> CREATE CURSOR CmdMedic ( cNom C(20) , nGroup I )
>
>
>  INSERT INTO CmdMedic ( cNom ) VALUES ( 'Temesta 2.5' )  && I want 1 For ngroup
>  INSERT INTO CmdMedic ( cNom ) VALUES ( 'Aspirine' ) && I want 1 For ngroup
>  INSERT INTO CmdMedic ( cNom ) VALUES ( 'Temesta 2.5' ) && I want 2 For ngroup
>  INSERT INTO CmdMedic ( cNom ) VALUES ( 'Fluimycyl' ) && I want 1 For ngroup
>  INSERT INTO CmdMedic ( cNom ) VALUES ( 'Rofenid' )&& I want 1 For ngroup
>INSERT INTO CmdMedic ( cNom ) VALUES ( 'Temesta 2.5' )&& I want 3 For ngroup
>
>*-- etc...
>
>UPDATE ngroup = ???? From CmdMedic
>

>
>How find nGroup with Update Command ?
>