Check, if the view stored (in Data Builder - Edit - Select Command) is identical to the view in the view designer.
If they are I would remove the WHERE and ORDER BY to test, if they give the error.

Gerhard

>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
>