>lcMedic='Temesta 2.5' >Select count(*) from CmdMedic where cNom=lcMedic into array aTemp >INSERT INTO CmdMedic ( cNom, nGroupe ) VALUES ( lcMedic, atest+1 ) >lcMedic='Aspirine' >Select count(*) from CmdMedic where cNom=lcMedic into array aTemp >INSERT INTO CmdMedic ( cNom, nGroupe ) VALUES ( lcMedic, atest+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 >>>>>>>>
>>>INSERT INTO CmdMedic ( cNom , nGroup) VALUES ( 'Aspirine',1 )