Hi all:

There is a lot of SQL code in my application that started of with VFP 6 and then with VFP 7. Now I have acquired VFP 8 and for starters got a message like so:

SQL: GROUP BY clause is missing or invalid

But the Group By cluase exists in the code. I then read that SET ENGINEBEHAVIOR 70 will accept existing SQL code. Question is where do I place that code? Every form's load/or init event? Is there any impact using the code as was in VFP 7?

Further, when i use Modiy form MyForm, I get the VFP erro dialog box with the message:

Data type is invalid for this property

This message reappears for quite a few times after I clicked the OK button (did not know what I was saying OK to :)). The form then finally showed up.

Is there anything elese that could surface up with VFP 8?

Thank you for your suggestions.