Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding Custom View Parameter?
Message
From
08/09/2008 14:55:56
 
 
To
08/09/2008 14:48:00
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:
01345878
Views:
17
>So, how do I define them correctly?
>I am still getting the missing operand error, even after changing this line in the top of my view prg:
>
>?vp_studentRule = [( Student.cid <> 'ZZZZZZ')]
>
>
>I get thru the validation if I define it in my command window, but where in my app should the definition go?


The line shoud be - no question mark
vp_studentRule = [( Student.cid <> 'ZZZZZZ')]
Now, If for every view you have defined it's parameterList - there's where it should go in your app
eg
=dbsetprop(ViewName, 'View', 'ParameterList', [vp_Gender,'C';vp_ParFirst,'C';vp_ParLast,'C';vp_filter,'C'])
You can change StoneField's code to use the function I have posted once before the view is opened and just after it is opened

Try it
=View_ParameterList(m.TableName, TRUE)
&&& use view nodata
=View_ParameterList(m.TableName, FALSE)
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform