Thank tore....


if you can ... do'nt forget BARCELONE , it 's a beautifull stad too...!

Good evening

bernhart



>Hi Bernhart,
>
>right now I am sitting at my local airport waiting for a four hour delayed flight to Madrid, with not too much battery on my laptop....! :-) Anyway, in this case I suggest that you do a count BEFORE every INSERT.

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

>
>
>
>>Hi Tore,
>>
>>Sorry for my poor English...
>>
>>I want change Value for nGroupe with a Update command ( count() in data )
>>
>>Example
>>
>>First record , the Field ngroup must give 1 because it is the first temsta 2,5
>>Second record , the field ngroupe must give 1 because it is the first Aspirine
>>Third record , the field ngroupe must give 2 because it the second temesta 2,5
>>Fourth record , the field ngroupe must give 1 because it the first time Fluimycyl
>>
>>is not very clear now ?
>>
>>Thank in advance
>>
>>bernhart
>>
>>
>>>>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
>>>
>>>Your question is not very clear. Is this what you want?

>>>INSERT INTO CmdMedic ( cNom , nGroup) VALUES ( 'Aspirine',1 )