The behavior of queries with aggregate functions has been changed in VFP9 to comply with ANSI SQL standard. See SET ENGINEBEHAVIOR for details.

laTemp[1] = NVL(laTemp[1],0) + 1

>I was using the code below in VFP 6 to generate
>code + 1 to my tables. _tally was working fine
>
>***********************************************
>dimension lctemp[1]
>select max(myfile.code) from myfile ;
> into array lctemp
> lctemp[1] = IIF(_tally=0,1,lctemp[1] + 1)
>replace myfile.code with lctemp
>***********************************************
>
>As migrating to VFP 9 I notice a problem
>
>A error message appear if its the first record of a table
>
>"field does not accept null values"
>
>Please help