>>>Hello all.
>>>
>>>Now I am migrating one software made with vfp7 to vfp9. Besides the report engine , what else do I have to consider in this migration process.
>>>
>>>
>>>Thank you for any advice.
>>
>>The DBC engine behavior is a little different...I think there is a SET ENGINEBEHAVIOR TO 70 or something like that....
>
>SET ENGINEBEHAVIOR 90 and change your queries to match. Just do it.

Yeah that is obviously the better approach. I eventually used Gendbcx to get a .prg for my DBC, then just searched it for 'group by' and a few other things that I knew would cause a problem. Overall, it really didnt take that long to do it - and I had over a thousand views to go though.