easy RecordRef Insert problem

mnewmedia

Hello togheter,
I have two tables 50000 and 50001 both has the fields "Name" and "Description".
I wanna Copy all records from the the first table to the second, but it works only with the Field "Name". somebody knows why?

RecordRef1.OPEN(50000);
RecordRef1.FINDFIRST;
RecordRef2.OPEN(50001);
RecordRef2.INIT;

IF RecordRef1.FIND('-') THEN REPEAT
   field1 := RecordRef1.FIELD(2); // works only with 1
   field2 := RecordRef2.FIELD(2); // works only with 1
   field2.VALUE := field1.VALUE;
   RecordRef2.INSERT;
UNTIL RecordRef1.NEXT = 0;

I get the Error (translated by me to english) "'table2' exists already. Identified Fields and Values: Name="
Any Ideas, Tipps?
Thanks

Nagaraju17

Why not use Transferfields function......
.....................

mnewmedia

Because later i need to use RecordRef variable and TRANSFERFIELDS only works with a normal Record Variable...

Kishorm

The problem is you are not copying all fields across but just one field. This works for your Name field as this must be your primary key and doesn't work for the Description field because in that instance you are not setting the primary key field in the record being inserted so it is always blank. Put a loop in there to copy BOTH fields and it will work.

mnewmedia

Put a loop in there to copy BOTH fields and it will work

Can you provide a small example for that?
Or do you mean i have to do it like that:

   IF RecordRef1.FIND('-') THEN REPEAT
      field1 := RecordRef1.FIELD(1);
      field2 := RecordRef2.FIELD(1);
      field2.VALUE := field1.VALUE;
      field1 := RecordRef1.FIELD(2);
      field2 := RecordRef2.FIELD(2);
      field2.VALUE := field1.VALUE;
      RecordRef2.INSERT;
   UNTIL RecordRef1.NEXT = 0;

And what if let's say i already copied Field 1 (Name) and wanna later copy only the Field 2 (Description)? Do i have to change the Primary Key, or is there an other way?