Thanks To all.


I am using the following code to get the Maximum two values of posR from a cursor.
>>
>>

>>SELECT TOP 2 posR FROM PageTwo ORDER BY posR DESC INTO ARRAY Maxrows
>>nfisrtposR=Maxrows(1)
>>nSecondposR=Maxrows(2)
>>

>>
>>However, i a case I am encountered with a situation where there is no posR in Pagetwo and at that situation my program generates error as Maxrows(1).prg does not exist.
>>
>>Whats the Problem, How to overcome it ?
>
>Well, this seems to be easy.
>

>lnRows = _tally
>
>if m.lnRows > 1
>   nFirstPosR = maxRows[1]
>else
>   nFirstPosR = some default value, you can also display a message
>endif
>
>if m.lnRows = 2
>   nSecondPosR = maxRows[2]
>else
>   less than 2 rows - work this condition
>endif
>