At 03:22 PM 1/21/2016, TOM HART wrote:
Here is what I am doing.
I have a sales form which might have 1 to 20+ rows, it is setup on a
temp table,
so I can define each var lookup in the variable expression, or I could do a
'select whatever'. When you say ' static form' is this what I am
trying to do
or is it a 'dynamic lookup'.
Define lookup variables as expressions.
That would be dynamic lookup for selected row as you navigate through each row
at a time.
Very Best R:egards,
Razzak
On Thursday, January 21, 2016 1:55 PM, A. Razzak Memon
<[email protected]> wrote:
Tom,
It depends on what you are trying to achieve.
FWIW ...
For static form, SELECTing INTO VarName INDIC ... is the best approach.
However, for dynamic lookup data in a form with multiple (varying) rows, the
traditional Variable Lookup Expressions are better.
Very Best R:egards,
Razzak
-----Original Message-----
From: TOM HART <[email protected]>
To: [email protected]
Date: Thu, 21 Jan 2016 19:37:57 +0000 (UTC)
Subject: [RBASE-L] - Look-up question
> I have a form where I lookup data from a table, so my question is:is
> it better to use a 'select into' for the lookup to populate the data
> oruse the defined variables in the form to populate the data.
> Tom Hart
>