Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: George Kelly
  Where is George Kelly?
 Dromore
 United Kingdom
 George Kelly
 To: Frank Cazabon
  Where is Frank Cazabon?
 
 Trinidad And Tobago
 Frank Cazabon
 Tags
Subject: RE: Taking advantage of larger screen resolutions
Thread ID: 83768 Message ID: 115753 # Views: 71 # Ratings: 0
Version: Visual FoxPro 7 Category: General VFP Topics
Date: Monday, December 11, 2006 3:46:23 PM         
   


> > > 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

COMPLETE THREAD

Taking advantage of larger screen resolutions Posted by George Kelly @ 12/12/2005 5:19:12 PM
RE: Taking advantage of larger screen resolutions Posted by Eric den Doop @ 12/12/2005 5:34:51 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 12/13/2005 5:42:03 PM
RE: Taking advantage of larger screen resolutions Posted by Eric den Doop @ 12/13/2005 5:47:15 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 12/13/2005 6:00:58 PM
RE: Taking advantage of larger screen resolutions Posted by Dale Dedoroy @ 12/13/2005 11:03:46 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 12/14/2005 1:39:39 AM
RE: Taking advantage of larger screen resolutions Posted by Dale Dedoroy @ 12/14/2005 6:00:28 AM
RE: Taking advantage of larger screen resolutions Posted by Frank Cazabon @ 12/9/2006 6:40:31 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 12/10/2006 8:37:43 PM
RE: Taking advantage of larger screen resolutions Posted by Frank Cazabon @ 12/11/2006 2:14:38 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 12/11/2006 3:46:23 PM
RE: Taking advantage of larger screen resolutions Posted by Soykan OZCELIK @ 12/7/2006 1:01:41 AM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 12/7/2006 10:20:15 AM
RE: Taking advantage of larger screen resolutions Posted by kevin woods @ 12/7/2006 11:42:03 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/21/2007 12:11:59 AM
RE: Taking advantage of larger screen resolutions Posted by Mike Yearwood @ 1/20/2007 1:44:11 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/20/2007 11:49:10 PM
RE: Taking advantage of larger screen resolutions Posted by Steve Hanlan @ 1/22/2007 11:16:48 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/22/2007 11:32:54 PM
RE: Taking advantage of larger screen resolutions Posted by Ken Murphy @ 1/23/2007 1:40:56 AM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/23/2007 2:01:54 AM
RE: Taking advantage of larger screen resolutions Posted by Ken Murphy @ 1/23/2007 2:21:53 AM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/29/2007 11:07:58 AM
RE: Taking advantage of larger screen resolutions Posted by Ken Murphy @ 1/29/2007 1:06:17 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/29/2007 2:22:41 PM
RE: Taking advantage of larger screen resolutions Posted by Ken Murphy @ 1/29/2007 3:31:13 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/29/2007 3:50:23 PM
RE: Taking advantage of larger screen resolutions Posted by tushar @ 1/29/2007 4:12:41 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/29/2007 6:45:26 PM
RE: Taking advantage of larger screen resolutions Posted by tushar @ 1/30/2007 5:47:10 AM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/30/2007 1:34:06 PM
RE: Taking advantage of larger screen resolutions Posted by tushar @ 1/30/2007 2:15:47 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/30/2007 3:52:54 PM
RE: Taking advantage of larger screen resolutions Posted by tushar @ 1/30/2007 5:09:35 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/31/2007 1:37:29 AM
RE: Taking advantage of larger screen resolutions Posted by tushar @ 1/31/2007 7:05:55 AM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/31/2007 11:11:01 AM
RE: Taking advantage of larger screen resolutions Posted by tushar @ 1/31/2007 1:57:16 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/31/2007 3:41:42 PM
RE: Taking advantage of larger screen resolutions Posted by tushar @ 1/31/2007 3:56:37 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/31/2007 4:55:03 PM
RE: Taking advantage of larger screen resolutions Posted by Ken Murphy @ 1/31/2007 5:04:43 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 1/31/2007 8:11:57 PM
RE: Taking advantage of larger screen resolutions Posted by Ken Murphy @ 1/31/2007 8:32:47 PM
RE: Taking advantage of larger screen resolutions Posted by George Kelly @ 2/1/2007 12:23:07 AM