hi,
thank you for reply,
i get erro message file"laaarray.prg" dose not exist

SELECT 1
SELECT MAX(billno) from mstr INTO ARRAY laAarray
IF _TALLY > 0
   thisform.text1.value=(RIGHT(STR(YEAR(DATE()),4),2) + '_'+RIGHT(STR(10000+laAarray[1]+1,5),4))+1
ELSE
   THISFORM.TEXT1.VALUE = (RIGHT(STR(YEAR(DATE()),4),2) + '_'+RIGHT(STR(10000+laAarray[1]+1,5),4))&&file"laaarray.prg" dose not exist

ENDIF

>>hi all,
>>
>>i try to run this code TO INSERT FIRST BILLNO AND DATE at empty table, it works befor,
>>i get error message variable LAAARRAY not found
>>

>>SELECT 1
>>SELECT MAX(billno) from mstr INTO ARRAY laAarray
>>IF _TALLY > 0
>>thisform.text1.value=(RIGHT(STR(YEAR(DATE()),4),2) + '_'+RIGHT(STR(10000+laAarray+1,5),4))+1
>>ELSE
>> THISFORM.TEXT1.VALUE = (RIGHT(STR(YEAR(DATE()),4),2) + '_'+RIGHT(STR(10000+laAarray+1,5),4))
>> ENDIF
>>

>>THANKS.
>
>

>SELECT 1
>SELECT MAX(billno) from mstr INTO ARRAY laAarray
>IF _TALLY > 0
>   thisform.text1.value=(RIGHT(STR(YEAR(DATE()),4),2) + '_'+RIGHT(STR(10000+laAarray[1]+1,5),4))+1
>ELSE
>   THISFORM.TEXT1.VALUE = (RIGHT(STR(YEAR(DATE()),4),2) + '_'+RIGHT(STR(10000+laAarray[1]+1,5),4))
>ENDIF
>

>
>Index to the first element of the laArray as laArray[1]