string problem

When I want to populate a recordset with values from another like
-----------
do while not rset1.eof()
   rset2.addnew
       rset2!name=rset1!name
   rset2.updatebatch
loop
------------
Curiosly in one computer it works fine in another one it gives an error and I must change to the following code
------------
dim var as string
 VAR=rset1!name
do while not rset1.eof()
   rset2.addnew
       rset2!name=VAR
   rset2.updatebatch
loop
----------
Must I convert the record to a string?

Thanks
asimoesAsked:
Who is Participating?
 
Valliappan ANConnect With a Mentor Senior Tech ConsultantCommented:
Try like this:

do while not rset1.eof()
  rset2.addnew
  rset2!name=rset1("name").Value   'NOTE THE CHANGE in accessing property of recordset here.
  rset2.updatebatch
  rset1.movenext  'or whatever code....
loop

A better alternative, is to use direct SQL statements to do this like(if it suits to you), like this:

Conn.Execute "INSERT INTO table2(name) SELECT name FROM table1"

This is a faster one, I dont know, this suits you or not.

Hope this helps, Cheers.
0
 
caraf_gCommented:
only thing I can think of is that you're using different ways of connecting to your data. E.g. ODBC on one machine and OLEDB on t'other...... !?
0
 
deightonCommented:
The two pieces of code have different functionality, Var is being set outside the rset1 loop in the second example  and will then not change, in the second example rset1!name changes as you move through rset1

(I presume you are navigating through the rset1 recordset somehow, codes you posted is infinite loop isn't it?)  

Post the actual code if possible

Could rset1!name be null and rset2 does not allow a null?
 
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
caraf_gCommented:
Hm...... I wonder though *why* it works..... !?

To be completely unambiguous, perhaps:

rset2.Fields("name").Value = rset1.Fields("name").Value
0
 
Valliappan ANSenior Tech ConsultantCommented:
caraf_g,
I also do so. But I think it is setting as a reference,  when assigning a recordset field to another recordset field, it gives error. But not to variables, I suppose.

So, when assigning a recordset field to another recordset field, needs to assign its value.

asimoes,
Thanks.

Cheers.
0
 
caraf_gCommented:
Yeah..... maybe.... Hm.... Anyway. Interesting :o)
0
All Courses

From novice to tech pro — start learning today.