Question Concatenating variable to class property

[reyes]

Hi guys

I've been googling this for a while thinking I'd get a quick answer, but I can't find the response I'm looking for.

I have a class with 4 properties: Property1, Property2, Property3, Property4.

In my database, I have 4 fields also named: Property1, Property2, Property3, Property4.

I'd like to achieve something like this, which I know won't work, but here it is:

dim I as byte

for I = 1 to 4
    
    dbRow("Property" & I) = MyClass.Property & i

next

I remember looking into this on a VBA project ages ago, but I can't remember whether the answer was "can't be done", or whether I just went with another option. This time, my curiosity needs satisfying!

Thanks in advance.

 

[JohnH]

Have a look at reflection and GetProperty/GetValue.

 

[reyes]

Okay John, will do.

Thanks for the reply.


Sent from my iPhone using Tapatalk