>I am attempting to create a view involving three tables in two different .DBC's in VFP 5.0.
>When I attempt to save the view I get the following message:
>SQL: Column CPROJRCWK is not found
>
>This is the SQL generated by the Designer:
>
>SELECT Qcrvaria.*, Qcr.crecordnumber, Projrcwk.csequence,;
> Projrcwk.cdescription, Projrcwk.mtext;
> FROM sitestat!qcrvaria INNER JOIN sitestat!qcr;
> INNER JOIN pas!projrcwk ;
> ON Qcrvaria.cprojrcwk = Projrcwk.cprojrcwk ;
> ON Qcrvaria.cqcr = Qcr.cqcr;
> ORDER BY Qcr.crecordnumber, Projrcwk.csequence
>
>The field CPROJRCWK is the primary key in the PROJRCWK table and is a foreign key
>in the QCRVARIA table and it most definately is found in both. Has nay seen this one and
>is there a workaround. Please contact me at
bcogswell@networkbta.com if you have any advice.
View designer cannot handle properly complicated views. Use CREATE SQL VIEW to create view programmatically and CURSORSETPROP() to handle its properties.
Edward Pikman
Independent Consultant