Recordset addnew etc...

[dkintheuk]

I have a question regarding how i can refer to the fields that I want
to add into my dataset

Each of my fields in my rawtext file that I am going to import appears
in the form:

"FieldName:FieldValue"

with a comma between each ietm in a record.

I'm happy about dividing it all up but I want to do something like
this...

rs1.AddNew
For i = 1 To intCnt
rs1!(myarray(1, i)) = myarray(2, i)
Next
rs1.Update

So myarrary(1,i) contains the fieldname and myarray(2,i) contains the
contents.

incnt contains the the count of fields in a particular row.

The reason for this idea is that i might only get some of the total
possible fields in my data record...

I know that i can refer to the fieldname by name but here i tried to
use a variable instead and it just doesn't want to know...

What is the correct form - if any?

Thanks,

Rob.

[dkintheuk]

Anyone? I've tried loads of ideas but it's not getting me anywhere.

I've tried:

rs1![myarray(1,i)] = myarray(2,i)

rs1!(myarray(1,i)) = myarray(2,i)

rs1!("myarray(1,i)") = myarray(2,i)

it's driving me mad - what am i doing wrong?

Thanks,

Rob.

On 25 Sep, 13:06, dkintheuk <[e-mail]:

I have a question regarding how i can refer to the fields that I want
to add into my dataset

Each of my fields in my rawtext file that I am going to import appears
in the form:

"FieldName:FieldValue"

with a comma between each ietm in a record.

I'm happy about dividing it all up but I want to do something like
this...

rs1.AddNew
For i = 1 To intCnt
rs1!(myarray(1, i)) = myarray(2, i)
Next
rs1.Update

So myarrary(1,i) contains the fieldname and myarray(2,i) contains the
contents.

incnt contains the the count of fields in a particular row.

The reason for this idea is that i might only get some of the total
possible fields in my data record...

I know that i can refer to the fieldname by name but here i tried to
use a variable instead and it just doesn't want to know...

What is the correct form - if any?

Thanks,

Rob.

[OldPro]

On Sep 25, 7:06 am, dkintheuk <[e-mail]:

I have a question regarding how i can refer to the fields that I want
to add into my dataset

Each of my fields in my rawtext file that I am going to import appears
in the form:

"FieldName:FieldValue"

with a comma between each ietm in a record.

I'm happy about dividing it all up but I want to do something like
this...

rs1.AddNew
For i = 1 To intCnt
rs1!(myarray(1, i)) = myarray(2, i)
Next
rs1.Update

So myarrary(1,i) contains the fieldname and myarray(2,i) contains the
contents.

incnt contains the the count of fields in a particular row.

The reason for this idea is that i might only get some of the total
possible fields in my data record...

I know that i can refer to the fieldname by name but here i tried to
use a variable instead and it just doesn't want to know...

What is the correct form - if any?

Thanks,

Rob.

I'm still not clear on exactly what you are trying to do... You have
a comma-delimited text file and you want to import it. What method
are you going to use to import it? You could open it with the OPEN
command and read it one line at a time until you reach its EOF. If
you are unsure if all of the possible fields will be represented, then
you could use a switch statement to select the proper field or
rs.fields("fieldname"), replacing "fieldname" with the variable
holding the fieldname. I don't know what you are trying to do with
the array...

[dkintheuk]

On 25 Sep, 14:38, OldPro <[e-mail]:

On Sep 25, 7:06 am, dkintheuk <[e-mail]:

I have a question regarding how i can refer to the fields that I want
to add into my dataset

Each of my fields in my rawtext file that I am going to import appears
in the form:

"FieldName:FieldValue"

with a comma between each ietm in a record.

I'm happy about dividing it all up but I want to do something like
this...

rs1.AddNew
For i = 1 To intCnt
rs1!(myarray(1, i)) = myarray(2, i)
Next
rs1.Update

So myarrary(1,i) contains the fieldname and myarray(2,i) contains the
contents.

incnt contains the the count of fields in a particular row.

The reason for this idea is that i might only get some of the total
possible fields in my data record...

I know that i can refer to the fieldname by name but here i tried to
use a variable instead and it just doesn't want to know...

What is the correct form - if any?

Thanks,

Rob.

I'm still not clear on exactly what you are trying to do... You have
a comma-delimited text file and you want to import it. What method
are you going to use to import it? You could open it with the OPEN
command and read it one line at a time until you reach its EOF. If
you are unsure if all of the possible fields will be represented, then
you could use a switch statement to select the proper field or
rs.fields("fieldname"), replacing "fieldname" with the variable
holding the fieldname. I don't know what you are trying to do with
the array...- Hide quoted text -

- Show quoted text -

It's not the import that is the problem i can go from a text file that
looks like this...

Fieldname1:FieldValue1,FieldName2:FieldValue2,Fiel dName3:FieldValue3

Each row can contain any number of records but i have the full set of
possible fieldnames...

I'm converting this to an array myarray(a,b)

a is always 1 or 2 and this relates to fieldname or fieldvalue

So then I can call the fieldnames with myarray(1,b) and the
fieldvalues with myarray(2,b)

I'm gonna try what you mentioned rs.fields(myarray(1,b)) and see how
far i get.

Thanks,

Rob.

[dkintheuk]

On 25 Sep, 14:38, OldPro <[e-mail]:

On Sep 25, 7:06 am, dkintheuk <[e-mail]:

I have a question regarding how i can refer to the fields that I want
to add into my dataset

Each of my fields in my rawtext file that I am going to import appears
in the form:

"FieldName:FieldValue"

with a comma between each ietm in a record.

I'm happy about dividing it all up but I want to do something like
this...

rs1.AddNew
For i = 1 To intCnt
rs1!(myarray(1, i)) = myarray(2, i)
Next
rs1.Update

So myarrary(1,i) contains the fieldname and myarray(2,i) contains the
contents.

incnt contains the the count of fields in a particular row.

The reason for this idea is that i might only get some of the total
possible fields in my data record...

I know that i can refer to the fieldname by name but here i tried to
use a variable instead and it just doesn't want to know...

What is the correct form - if any?

Thanks,

Rob.

I'm still not clear on exactly what you are trying to do... You have
a comma-delimited text file and you want to import it. What method
are you going to use to import it? You could open it with the OPEN
command and read it one line at a time until you reach its EOF. If
you are unsure if all of the possible fields will be represented, then
you could use a switch statement to select the proper field or
rs.fields("fieldname"), replacing "fieldname" with the variable
holding the fieldname. I don't know what you are trying to do with
the array...- Hide quoted text -

- Show quoted text -

In fact i can already tell you that it works perfectly - i just
couldn't get the syntax right to refer correctly to the fieldname in
the recordset rs1 by a variable - that has sussed it.

CHeers,

Rob.

[Tom van Stiphout]

On Tue, 25 Sep 2007 06:27:55 -0700, dkintheuk
<rm*******@firenet.uk.comwrote:

rs1.Fields(myarray(1,i)) = myarray(2,i)

-Tom.

>Anyone? I've tried loads of ideas but it's not getting me anywhere.

I've tried:

rs1![myarray(1,i)] = myarray(2,i)

rs1!(myarray(1,i)) = myarray(2,i)

rs1!("myarray(1,i)") = myarray(2,i)

it's driving me mad - what am i doing wrong?

Thanks,

Rob.

On 25 Sep, 13:06, dkintheuk <[e-mail]:

>I have a question regarding how i can refer to the fields that I want
to add into my dataset

Each of my fields in my rawtext file that I am going to import appears
in the form:

"FieldName:FieldValue"

with a comma between each ietm in a record.

I'm happy about dividing it all up but I want to do something like
this...

rs1.AddNew
For i = 1 To intCnt
rs1!(myarray(1, i)) = myarray(2, i)
Next
rs1.Update

So myarrary(1,i) contains the fieldname and myarray(2,i) contains the
contents.

incnt contains the the count of fields in a particular row.

The reason for this idea is that i might only get some of the total
possible fields in my data record...

I know that i can refer to the fieldname by name but here i tried to
use a variable instead and it just doesn't want to know...

What is the correct form - if any?

Thanks,

Rob.