>hi,
>
>i try but same message
>
>at myform procedure activate
>
>SELECT 1
>SELECT MAX(BILLNO) FROM (mstr()) INTO ARRAY laArray
>
>IF _TALLY > 0
> THISFORM.TEXT1.VALUE = laArray + 1
>ENDIF
>
>
>thanks.
Your syntax says "There is an array or function named MSTR which will return a character result. Use that character result as the name of the table/alias from which MAX(billno) should be selected."
More than likely you mean
SELECT MAX(billno) FROM mstr INTO ARRAY laArray