Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 1806 SQL: Column 'CaseNo' is not found
Message
De
29/11/2013 09:04:42
 
 
À
29/11/2013 07:46:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01588611
Message ID:
01588883
Vues:
50
Are there any FIND or GET filters in the view. Can you post the view definition?

This is the view definition for the parent:
SELECT funeralcase.caseno, ;
		funeralcase.traffic, ;
		funeralcase.entity, ;
		funeralcase.casedate, ;
		funeralcase.casetype, ;
		funeralcase.decpin, ;
		funeralcase.fdcode, ;
		funeralcase.disptype, ;
		funeralcase.dispother, ;
		funeralcase.agebracket, ;
		funeralcase.agemonths, ;
		funeralcase.agedays, ;
		funeralcase.agehours, ;
		funeralcase.ageminutes, ;
		funeralcase.calldate, ;
		funeralcase.calltime, ;
		funeralcase.takenby, ;
		funeralcase.calltype, ;
		funeralcase.callerpin, ;
		funeralcase.famnotified, ;
		funeralcase.hospcode, ;
		funeralcase.famowns, ;
		funeralcase.famcemetery, ;
		funeralcase.famburied, ;
		funeralcase.famwhom, ;
		funeralcase.persbelong, ;
		funeralcase.fcnotes, ;
		0 AS nisnew, ;
		Purchasr.fullname AS decnamesort, ;
		Purchasr.dob, ;
		Purchasr.dod, ;
		Purchasr.age, ;
		Purchasr.deceased, ;
		Purchasr.ssn, ;
		ICASE(funeralcase.casetype="A", "AtNeed ", funeralcase.casetype="P", "PreNeed", SPACE(7)) AS casetypedesc, ;
		IIF( funeralcase.podtype = 'DH', purchasr.state1, IIF(funeralcase.podtype = 'OT', funeralcase.podstate, ivendor.bstate)) AS deathstate, ;
		funeralcase.shiptype;
	FROM Funeral!funeralcase ;
		LEFT JOIN nexus!purchasr ;
			ON funeralcase.decpin == Purchasr.pin ;
		LEFT JOIN ivendor ;
			ON funeralcase.podvendor == ivendor.vendor ;
	WHERE funeralcase.caseno LIKE ( ?PKValue ) ;
		AND funeralcase.caseno LIKE ( ?FindCaseNo ) ;
	ORDER BY funeralcase.caseno
And this is the definition for the one that is giving me the problems:
SELECT funeralcase.caseno, ;
		funeralcase.traffic, ;
		.f. AS Review;
	FROM funeral!funeralcase ;
	WHERE funeralcase.caseno LIKE ( ?PKValue ) ;
	ORDER BY funeralcase.caseno
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform