i dont't have program, i get the message when i run myform
thanks
>>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.
>
>
>Mohamed,
>1. laAarray is an array and You must write:
>

laAarray[number1[,number2,...]

>
>2. In your code
>
>- IF _TALLY > 0
>

laAarray has one element

>and you can write
>

>thisform.text1.value=(RIGHT(STR(YEAR(DATE()),4),2) + '_'+RIGHT(STR(10000+laAarray[1]+1,5),4))+"_1"
>

>- IF _TALLY = 0 that is while mstr.dbf hasn't records
>and else I don't know ???