Hi all,

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 ?

Thnak in advance for help.


bernhart