select max(client.CODE) from client ;
    into array lctemp
insert into client (code) values (IIF(isnull(lcTemp),1,lctemp + 1))

>Still NULL value
>
>It worked well on VFP 6 problem begins with VFP 9
>
>anything wrong with tally in VFP 9 ?