You may also post this question in Stonefield category now since the problem seems to be specific to Stonefield trying to validate your view.
>I am getting errors trying to validate the database in Stonefield.
>The exact error I am getting is:
>Error #1231
>Message: Missing Operand
>Line #51
>Code: Use (tcName) again alias (lcAlias) shared nodata
>Method: opencursor
>Object: frmSDT..sdtdbcxmgr.OCOREMGR
>
>My code is my view is as follows:
>
> vp_studentRule = [( Student.cid <> 'ZZZZZZ')]
>
>CREATE SQL VIEW "LV_STUDENT" ;
> AS SELECT Student.CID,;
> Student.CSITEID,;
>...
>...
>WHERE
>...
> AND &?vp_studentRule ;
> GROUP BY Student.CID ;
> ORDER BY Student.CLASTNAME, Student.CFIRSTNAME
>parm_list=parm_list+"vp_Gender,'C';vp_ParFirst,'C';vp_ParLast,'C';vp_studentRule,'C'"
>
>
>I can't post the full view, since it is several hundred lines. I am adding the vp to an existing view, so I know the view itself is correct, until I attempt to make these changes.
>These are the only code changes I have made to the view.
If it's not broken, fix it until it is.
My Blog