Dear David :
>>
The point is being missed here: what is YOUR desired outcome? Do you
simply what to do know if there ARE multiple instances (Yes / No), or do
you need to be able to KEEP those multiple instances and work with them in
some way?
<<
I just wants to know if there are multiple instances, so I found a simple
solution that have been posted yesterday :
OUTPUT FileName
SELECT numcde FROM ligne WHERE numcde = .vnumcde +
GROUPED BY cndp, cgratuit, cpaysori, cpreference, +
cana1, cana2, cana3, cana4, cana5, +
ctaxe1, tauxt1, ctaxe2, tauxt2, ctaxe3, tauxt3, ctva +
HAVING COUNT(*) > 1
SET VAR vINT = .verr
OUTPUT SCREEN
IF vINT = 0 THEN
PAUSE 2 USING 'One or many GROUPED BY rows'
ELSE
PAUSE 2 USING 'No GROUPED BY rows'
ENDIF
Thanks for your help ...
J.M. GRATIAS, Logimatique, France
