[RBASE-L] - RE: Getting a value

[Bernard Lis]

Thanks Buddy,
Since I already had the variables from a fetch statement, I didn't think about 
using a select command.
But I tried using sel where current of cursor and that gave me the correct 
value.
Thanks for the Heads Up
Bernie Lis
  ----- Original Message ----- 
  From: Walker, Buddy 
  To: RBASE-L Mailing List 
  Sent: Thursday, October 02, 2008 9:32 PM
  Subject: [RBASE-L] - RE: Getting a value


  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