>I want to create a remote view to do something like this:
>
>SELECT [field list] FROM [table] WHERE ?cExpression = .t.
>
>I want to build cExpression on the fly, then re-query the view. For example, the user can enter values and I build an expression that says cName = 'First Bank' and cState = 'TX', then re-query the view. Or someone else might want to query with cPhone = '555-1212'. This way the users would have the most flexibility in selecting the records they want to work with. I could even add something like StoneField Query to give the users a user friendly interface for building the expression.
>
>My question is: CAN THIS BE DONE?
>
>I have tried several different methods and either the view will not be created or when I try to open the view, I get an syntax error.

You can build an executable query to create a cursor this way, but you can not create a SQL view this way.