> 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 >>
INSERT INTO CmdMedic ( cNom , nGroup) VALUES ( 'Aspirine',1 )