[RBASE-L] - RE: Getting a value

[Walker, Buddy]

Bernie

  After assigning the column name to vYr then I would just select the
value directly from the table like so

 

  SET VAR YrNo INTEGER = 1

  SET VAR vYr TEXT

  SET VAR abc TEXT   --Assuming data type of column is TEXT

 

   WHILE YrNo <= 4 THEN

      SET VAR vYr = ('Yr' + (CTXT(.YrNo)))

      SELECT &vYr INTO abc INDIC iabc FROM TableName WHERE .....

      SHOW VAR abc

      SET VAR YrNo = (.YrNo + 1)

   ENDWHILE

 

Buddy

 

 

________________________________

From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Bernard
Lis
Sent: Thursday, October 02, 2008 8:05 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Getting a value

 

In the table I have several columns named Yr1, Yr2, Yr3, Yr4, etc.

 

set var xx text = &yr2

 

R>show var xx
99

 

So instead of having a variable for each column, I create it by
incrementing YrNo

set var vYr = ('Yr' + (ctxt(.YrNo)))

So if YrNo = 2 then I would expect vYr to contain the value Yr2, so now
to get the contents of the col Yr2 I would use:

R>set var vvyr text = &vYr

But instead of getting 99, I get

R>show var vvyr
Yr2

 

 

R>show var &vvyr
99

 

So how do I get 99 into a var?

R>set var abc = &vvYr

 

R>show var abc
Yr2