I am extremely new to vb but i do something in my other language i program
in that i will soon try to re-create in vb.
Basically we have a file such as dbf with 100+ fields.
We have a function that we call and it Loops through the file defenition (
knowing now how many fields there are in a record ).
We call this "Scatter() ""
Scatter looks at the record you are sitting on, loops through the field
names ( that you know from the dbf defenition ) and then
writes each field into an array. So a Record that has 115 fields would have
115 dimension arrays.
So now this function returns the array of all the values in the field.
Now we have another function called " Gather() " and this loops through the
array copying all the values in the array to
the same field # in the database.
In between calling Scatter and Gather, you can change values in an array.
You just have to know which array# you are changin,
which is the field # in the db.
Once i get to this stage ill try to write it in vb. See me in a month or
two ;)
I had a big enough problem last night trying to call one form from another.
Miro.
"Jeff Brooks" <Je********@discussions.microsoft.com> wrote in message
news:7B**********************************@microsof t.com...
I need to copy a record one access record into the same table. I just need
to modify a couple fields that the user will change. Im sure there is an
easy way to do it. I have started just reading the data and writing a SQL
insert command, but there are a ton of fields. It would take forever to
get
the datatypes correct and the SQL formatted properly. Anyone know how to
just copy a record and make a couple changes to it?
Thanks
Jeff