>>I want to convert some views (where I'm using parametrized condition) to a parametrized WHERE.
>>
>>Here is an example :
>>
>>CREATE SQL VIEW "myView" AS
>>SELECT * FROM myTable WHERE myTable.field1 LIKE ?THISFORM.cValue
>>
>>----------------
>>
>>CREATE SQL VIEW "myView" AS
>>SELECT * FROM myTable WHERE & ?THISFORM.cCondWhere
>>
>>
>>so I can put my conditions in the cCondWhere
>
>
>Sonny, I've done this, but I put the form property into a variable, and call the parameterized view with the variable
>
>CREATE SQL VIEW "myView" AS
>SELECT * FROM myTable WHERE myTable.field1 LIKE ?MyVar
>
>Then MyVar = thisform.cCondWhere
>
>Sele MyView
>=requery()
>
>I've been using variables in both the WHERE and the SORT BY clauses with no problems.
>
>HTH
>Barbara

Thanks for your response.
I want to parametrized the whole WHERE clause with a variable. I've tested many ways to do this but I didn't find one that works.

SELECT * FROM myTable WHERE &whereClause