I am converting my app from VFP7 to VFP9.

This view in the DBC works OK in VFP7, but not in VFP9.

CREATE SQL VIEW "MODELV" ; 
   AS Select * From [C:\ABC8\DATA\model.dbf]

Model.dbf is a free table. The view is created at runtime, hence the hard coded path and the quotes around the FROM part.

I am using:
Set ENGINEBEHAVIOR 70

The view does not give an error, it just does not return any records. It works fine in VFP7.


Does this view look fundamentally wrong for VFP9, or should I persevere?

Cyril