How do i represent a string as a column name?

[Rob]

How do i represent a string as a column name?

example: COLUMN_NAME = "SALES_10"

My Code:

dim i as integer
dim sStr as string

i = 10
sStr = "SALES_" & trim(str(i))
rs(sStr) = 9999 => this is ok
rs.update => generates an error

[Roy]

It is unclear what you want to do:
- build a string
- "represent a string" (???)
or update your recordset.
Please explain.

Roy

"Rob" <rphildawa@yahoo.com> wrote in message news:3cfae37a$1@10.1.10.29...
>
> How do i represent a string as a column name?
>
> example: COLUMN_NAME = "SALES_10"
>
> My Code:
>
> dim i as integer
> dim sStr as string
>
> i = 10
> sStr = "SALES_" & trim(str(i))
> rs(sStr) = 9999 => this is ok
> rs.update => generates an error

[Guy Smith]

"Rob" <rphildawa@yahoo.com> wrote:
>
>How do i represent a string as a column name?
>
>example: COLUMN_NAME = "SALES_10"
>
>My Code:
>
>dim i as integer
>dim sStr as string
>
>i = 10
>sStr = "SALES_" & trim(str(i))
>rs(sStr) = 9999 => this is ok
>rs.update => generates an error

From what I see your "rs(sStr)" reference is perfectly fine. The "rs.update"
is failing for reasons not associated to the sStr usage. What error message
is being returned?

Guy Smith

[Rob]

Hi Guy!

The error says "Invalid Column Name" or something. I don't know how to substitute
a string as a column name. In clipper, i just place an ampersand (&) to
the variable in order to refer to its content. how do i do this in VB?


Thanks a lot for ur help.


"Guy Smith" <sf@afddsf.com> wrote:
>
>"Rob" <rphildawa@yahoo.com> wrote:
>>
>>How do i represent a string as a column name?
>>
>>example: COLUMN_NAME = "SALES_10"
>>
>>My Code:
>>
>>dim i as integer
>>dim sStr as string
>>
>>i = 10
>>sStr = "SALES_" & trim(str(i))
>>rs(sStr) = 9999 => this is ok
>>rs.update => generates an error
>
>From what I see your "rs(sStr)" reference is perfectly fine. The "rs.update"
>is failing for reasons not associated to the sStr usage. What error message
>is being returned?
>
>Guy Smith