Did you save the view defintion in the database? I think you should not save this particular complex view in the database because of these errors.

I'm thinking you may create your view in code for the form that needs it and then remove it (delete view) in the form's Destroy method. I'm thinking that Stonefield may not have your variable in scope when it tries to validate the database.

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