Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding Custom View Parameter?
Message
From
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:
01345810
Views:
32
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.
Amanda Morton
System Analyst
Harrisburg Project
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform