>>I am going to have to upgrade a project I look after from 7 to 9 - are there any things to look out for out of the starting gate, or ought it just be a recompile, and all is good? Many thanks for your input!
>
>I once moved a friend's project from 7 to 9, and mostly the differences were in things I never do, so there were a few little surprises.
>
>One was the use of _tally in a select with an aggregate function but without group by, into an array. Where VFP7 would select nothing and not create the array, VFP9 would, with _tally=1 and I don't remember what was in the array, empties or nulls.
>
>The other difference was in the declaration of arrays, the old syntax of "local array xx[1,2]" doesn't work any more - remove the word array and it does.
>
>And the changes in the SQL engine took the rest of the time - the strict group by clause, which is specially annoying when you're creating a denormalized cursor, the columns from lookup tables now have to be in an aggregate function, because the engine can't guarantee which of the identical values will be selected. But that's my pet peeve, and this is pet feeding time :).



I always do LOCAL ARRAY, ok. like xx(1,2), but that should not be a problem.
Also
SET ENGINEBEHAVIOR 70 should solve the problem. One can then slowly improve the SELECTs