Wiki Home

VFP Upgrade Notes


Namespace: WIN_COM_API
Notes, differences among the versions.


Upgrading from VFP 6

When VFP 9 looks at VFP 6 reports, it identifies the previous printer, and checks the Save Printer Environment with that printer, which means AT RUNTIME VFP and the report look for that developer's printer... which might make those reports open slowly in the runtime. You'll notice this slowness when MODIFYing the report - and that should be your clue something's amiss. In our case, the developer's printer was across the WAN so particular reports opened slowly as XP searched in the directory. Craig Roberts


SET ENGINEBEHAVIOR 70

If you use more than one field PK in your SELECT ... GROUP BY commands.

CREATE TABLE
Cities ;
(StateCode c(2), StateName c(20), CityName c(20), population i)
SELECT
StateCode, StateName, COUNT(*) ;
FROM Cities ;
GROUP BY 1
gives an error for VFP 8 & 9 unless you use SET ENGINEBEHAVIOR 70

Craig Roberts

Local views (of DBF tables) when used in other LV's seem to be created with a NODATA.

Craig Roberts
( Topic last updated: 2008.03.07 02:54:17 PM )