At 01:00 PM 9/26/2012, Jan Johansen wrote:
Razzak,
Thank you for this timely document. I've already checked over a few
things to improve.
One thing I might add is in the area of the Variable List controls.
Make sure you
don't automatically fill your list with data. Use something like the
ON KEYPRESS EEP
to control the amount of data displayed.
Jan,
The best approach to handle a situation like that would be to use the
"&vWhereClause",
where you should define the WHERE clause that does NOT match the
initial load of the
Variable Lookup ListView control.
For example, if a Variable Lookup ListView control is based on a user
defined keyword,
and the result is based on a dynamically created vWhereClause
variable, you can set
the vWhereClause variable as, for example, ('CustID IS NULL'),
knowing the fact that
CustID will NEVER be NULL. That way, the initial load will always be
blank (no rows)
until a vWhereClause variable is defined after a keyword or
dynamically vWhereClause
is concatenated to REFRESH the LIST (REFRESHLIST TRUE).
There are various sample applications provided with Super Advanced
Training (SAT) to
illustrate the use of such technique in R:BASE eXtreme 9.1/9.5 for Windows.
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
