Parameters in a view

[genevi]

Is it possible to use parameters in a view?<br><br>For exemple in the criteria of a field I put:<br><br>LIKE N'[* &forms!searchact!searchbox&*]'<br><br>searchbox is a textbox<br>I want the input parameter to be the value in searchbox<br><br>Thanks <br>genevi

 

[jnicho02]

You should be able to use a parameter seeing as the view is defined by a standard SELECT statement<br><br><FONT FACE=monospace>CREATE VIEW myView (col1,col2,col3)<br>AS<br>SELECT col1,col2,col3 FROM aTable<br>WHERE col1 LIKE @myParam</font><br><br>The nuts and bolts may be different if your parameter is from a VB or ASP front-end, but it should be essentially the same.... <p> <br><a href=mailto: > </a><br><a href=

http://www.geocities.com/jnicho02/>my

home</a><br>

 

[SacAndFox]

But does the parameter need to be declared as in a stored procedure to be an INPUT or an OUTPUT parameter and of what type (e.g. Integer, VarChar, etc.)?