Does a Local View open the table's records exclusively?

[drosenkranz]

Does a Local View open records exclusively and can it be set to shared?

This use of a "view" seems to prohibit VFP from using the Crystal Reports OCX to
run reports from the VFP form because it thinks the file is in use exclusively by
the VFP program. I've opened everything else "shared".

SELECT Filesout.caseno, Filesout.workerno, filesout.officevis,; Filesout.homevis, Filesout.reqdate, Filesout.unit, Filesout.comments1,; Filesout.comments2, Filesout.fake_rpt_spec, Whosid.*,; Filesout.was_deleted;
FROM frts!filesout INNER JOIN frts!whosid ;
ON Filesout.workerno = Whosid.workerno

 

[FJR]

Is the view and connection declared as shared?

 

[LordOfCode]

Actually the Vfp Database must be open before you can use a local view. So if you open the Vfp Database as Shared or "set exclusive off", the local view and the related tables must open for shared access. On the other hand, if you are working with ODBC Connections to access the data in the VFP database maybe you should check the value of the Exclusive Checkbox in the ODBC Connection you set in the Control Panel...

Edwin Dalorzo
edalorzo@hotmail.com

 

[dgrewe]

Think about your question.
In the beginning of the SQL statement there is nothing. You must create it.
To create something the Operating System (DOS/HPFS/etc) must allocate room in the hard drive for the file.
How in the world can the computer share something that does not exist????

David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644