* Remote view created as CREATE SQL VIEW myremote ; CONNECTION myrem1 ; AS SELECT * FROM mytable ; WHERE mytable.id = ?lcId ; and mytable.city = ?lcCity ; and mytable.state = ?lcState * Via an interface you get values for users * User1 lcId = "someid" lcCity = "" lcState = "" * User2 lcId = "" lcCity = "somecity" lcState = "" * User3 lcId = "" lcCity = "somecity" lcState = "somestate" * User4 lcId = "" lcCity = "" lcState = "" use mydbc!myremote alias myview *Change filter for user4 to state search lcId = "" lcCity = "" lcState = "somestate" requery("myview")Cetin
* Collect criterias via a form interface >>m.criteria1 = "" && Would mean all for nonspecified >>m.criteria2 = minvaluecriteria && For numerics,date(time)s min-max >>m.criteria3 = maxvaluecriteria >>m.criteria4 = "" >>.. >> >>select * from mytable ; >> where cSearch1 = ?m.criteria1 ; >> and between nSearch2 ?m.criteria2 and ?m.criteria3 ; >>...cetin