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