Sergey,

Wonderfull !

A big thank....sergey


bernhart

>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 ?
>>