Hi Henry !
1. The scope of SET ENGINEBEHAVIOR is global. It is enough to put it at a start point of your application
2. VFP8 treats captions in different way than VFP7 (it try to evaluate it in design time) - check caption expresion of your objects. For example I have caption with such expresion: ="=" in VF7 it works but in VFP8 I had to change it to: =" ="
>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.