I'm a bit unclear about the LOOKUPWHERECLAUSE property in R:BASE eXtreme 9.0 (64-bit) and was wondering if anyone knew the answers to these questions: 1) Is PROPERTY <comp ID> LOOKUPWHERECLAUSE 'value' is a valid property for a Variable Lookup LISTVIEW? I know it is for a Variable Lookup LISTBOX - it shows up under the Syntax Builder for the PROPERTY Command on R:BASE's website. It is not on the property list for Variable Lookup Listview at this time, though. 2) Why is the word "LOOKUPWHERECLAUSE" not bolded like other property commands (e.g., "REFRESHLIST") when I use the LOOKUPWHERECLAUSE property command in an EEP or Form Action when I am using the editor to edit an EEP/Form Action? 3) I have a Variable Lookup ListView control, "varList", that has "&vwhere" in the box for the WHERE clause under the Lookup Settings Property Tab. Assuming the LOOKUPWHERECLAUSE property is valid for a Variable Lookup Listview, which is preferable? set var vwhere text = "where vLastName is not null order by vLastName" PROPERTY varList REFRESHLIST "true" or set var vlookupwhereclause text = "where vLastName is not null order by vLastName" PROPERTY varList LOOKUPWHERECLAUSE .vlookupwhereclause PROPERTY varList REFRESHLIST "true" (and does it matter if the Variable Lookup Listview control has "&vwhere" in the WHERE clause section under the Lookup Settings Property Tab? In this case, which takes precedence, the LOOKUPWHERECLAUSE property or the WHERE clause variable defined in the Listview control)?
These are probably insignficant questions but I want to make sure I am correct in my assumptions for my application. Thank you so much -- Diane DeMers [email protected] DeKalb, IL
