Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding Custom View Parameter?
Message
 
 
To
08/09/2008 13:06:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01345719
Message ID:
01345816
Views:
17
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
Previous
Reply
Map
View

Click here to load this message in the networking platform