> > > 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
>
> Hi George,
>
> so you don't use VFP's SQL commands at all right now? The problem I described doesn't depend on you using any particular type of database to store the data, it could be a VFP database.
>
> Frank.
>
> Frank Cazabon
> Samaan Systems Ltd.
>
www.SamaanSystems.com/Sorry for confusion. Currently, I use a Foxpro database, not a SQL Server database.
SQL commands are part of Foxpro, so I do certainly do use them.
Not a worry at present. I use very few SQL selects. The main table in my day job has 3.3 million records in a 682 mb dbf. When I started work on it, some jobs ran for more than an hour. I created compound index fields, avoided filters and SQL select statements and used SEEK to set pointer to top of desired data block and then used the DO while /ENDDO to extract data chunk into cursors etc. Time to produce a report is now seconds.
George