Diane: I have a form with a Variable Lookup Listview control. The where
clause that's in the control says this:
WHERE &vPOSWhere ORDER BY po
(BTW: POS stands for "POSearch", not piece-of-sh**)
In the program that opens the form, I set vPOSWhere = 'LIMIT = 0' because
the listview starts out empty.
The form code that sets it is like this:
SET VAR vPOSWhere = 'ItemID = .vPOSItemID'
PROPERTY listview REFRESHLIST 'TRUE'
Does this help you at all?
Karen
> 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
>
