From: "Peña, Botp" <botp@...>
Date: 2007-08-29T09:54:45+09:00
Subject: Re: ''Macro'' operator

On Behalf Of Damjan Rems
# Thanks eval is good. What I have is database with fields 
# name1,name2,name3,name4.. and

i sense normalization problem. sooner or later you will run out of field names due to db constraints on max field counts.

assumming, you have the table TABLE w the ff fields,

TABLE: foo name1 name2 name3 name4 name5 
       aaa  one   two
       bbb  one              four
       ......

you can break it down to two tables TABLE1 and TABLE2

TABLE1: foo name
        aaa   1
        aaa   3
        bbb   1
        bbb   4
         .....

TABLE2: name value
          1   one
          2   two
          3   three
          4   four
         .....


of course, it's possible i sensed it wrong :)

kind regards -botp