Patti, may I ask, is this similar to a questionnaire/survey instrument?
Steve in Memphis From: [email protected] [mailto:[email protected]] On Behalf Of Patti Jakusz Sent: Tuesday, June 07, 2011 12:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - need Array logic Hi, >From time to time, I would find life so much easier if rbase had some sort of Array logic that I could use when writing code. Maybe there's some other way of doing this that someone could point out to me. I have a database table with about 60 yes/no data fields in it. I need to write a one-page report per client that lists only the boxes that were checked "yes." So I've fetched the data into variables with indicator variables, that I've named vi1, vi2, vi3, etc. I'm trying to write some sort of "for/next" or "while" loop that will: set my beginning loop counter to 1 LABEL Beginloop set MyVariable representing the indicator variable to ('.vi'+loop counter) check MyVariable (which would hopefully check the real indicator var) if something other than 0, write it in a temp table (which I could use for generating the rpt) increment the loop counter goto LABEL Beginloop What I've tried won't ever give me the actual value of the indicator variable. It thinks MyVariable is a text field called .vi1 or .vi2 I considered having a table of just those fields that were marked "yes" for each client, but that creates bothersome code-writing when I have to allow data-entry people to make changes or send the entire data record off to another health dept. So it would be easier in the long run to have them all in one table. Does anyone have any idea of how I replicate Array type code in Rbase without having to write code for each of the 60 fields? Or maybe there's some other way of setting up this table that will be better suited to doing both types of tasks? Thanks, Patti Jakusz
