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.