Information générale
Titre:
Error using View Wizard
I give following code in the command window and it create view but when I tried to open it in the project it give the error of
SQL: Column 'CSURVEY' is not found
the code is as follow
create view vp_line as ;
SELECT Line.ilinecode, Line.clinename, Line.csource, Line.cacqtool,;
Line.ccrew, Line.nsrate, Line.nreclength, line.ngpinterval,; Line.cdataflag,Dformat.cname,Survey.cname, Area.cname,; Country.cname, Province.cname,District.cname,Contractor.cname,; Operator.cname, Survey.nsdate, Survey.cstype,Survey.csgeom ;
FROM das!area INNER JOIN das!line;
INNER JOIN das!contractor;
INNER JOIN das!country;
INNER JOIN das!dformat;
INNER JOIN das!district;
INNER JOIN das!operator;
INNER JOIN das!province;
INNER JOIN das!survey ;
ON Survey.ccode = Line.csurvey ;
ON Province.ccode = Line.cprovince ;
ON Operator.ccode = Line.coperator ;
ON District.ccode = Line.cdistrict ;
ON Dformat.ccode = Line.cdataformat ;
ON Country.ccode = Line.ccountry ;
ON Contractor.ccode = Line.ccontractor ;
ON Area.ccode = Line.cblock;
WHERE Line.ilinecode = ?thisform.ilineptr;
ORDER BY Line.clinename
Got any idea?
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement