drosenkranz
Programmer
Does the following SQL 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".
The OCX works fine from VB. My VFP's Crystal Reports run fine in the Crystal Reports Designer but not from the program. I keep getting OLE error code 0x800a5077 unknown COM status code
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
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".
The OCX works fine from VB. My VFP's Crystal Reports run fine in the Crystal Reports Designer but not from the program. I keep getting OLE error code 0x800a5077 unknown COM status code
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
