> Hi George,
>
> > To upgrade my applications, can I simply add values into the anchor property and recompile existing programs with V9?
> >
>
> The only issue with upgrading from VFP7 to 9 that I can think of off the top of my head is if you use SQL SELECTs with the GROUP BY clause. Earlier versions of VFP were less strict in allowing you to run this type of SQL than VFP8 and 9. As a temporary workaround you may need to SET ENGINEBEHAVIOR 70, but in the long run you should ensure that you update your SQL to the proper syntax. Check the help on SET ENGINEBEHAVIOR for more.
>
>
> Frank.
>
> Frank Cazabon
> Samaan Systems Ltd.
>
www.SamaanSystems.com/Thanks Frank
I use the Foxpro database for all my work at present. However, when I move to VFP9 I'll be doing some new work on SQL Server in new year, so I'll lookup this thread when the time comes.
George