>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