>What would you have to do to programmatically change the WHERE clause of a remote view while everything else remains the same in it? Is this a slow process? What downside might exist?
You can use the DBGETPROP() function to get the SQL clause, adjust the WHERE portion of it, then write it back to the DBC with DBSETPROP():
cSQL = DBGETPROP("rv_ViewNameHere", "View", "SQL")
* Change the WHERE portion of cSQL here
DBSETPROP("rv_ViewNameHere", "View", "SQL", cSQL)
It may be difficult to parse the WHERE portion. I usually have the ORDER BY clase immediately follow the WHERE clause, but I can't remember if that is a SQL requirement.
Chris McCandless
Red Sky Software