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.