Information on COPY function

Nitesh

I want more information on how to use COPY function and its use.I have tried it out but didnt get desired result.

tinoruijs

You could search for COPY in the C/SIDE reference guide (Design mode: F1)
You'll find a copy for records and a copy for files.

Nitesh

i had seen that. It doesnt work atall.

tinoruijs

Nitesh wrote:

i had seen that. It doesnt work atall.

Can you describe what you are trying to do? Maybe show some code and errors?

Nitesh

im trying something like this,

Table1.COPY(Table2);

copying records from table2 to table1 and its giving me error like,
'Copying all filters at once can only be done between records belonging to the same table. Copy the necessary filters one at a time.'

todro

Nitesh wrote:

im trying something like this,

Table1.COPY(Table2);

copying records from table2 to table1 and its giving me error like,
'Copying all filters at once can only be done between records belonging to the same table. Copy the necessary filters one at a time.'

The reason is, that copy is copying the filters too and they do not match, obviously you are trying to copy from one table to another, e.g. 18 to 21, that's not possible. The records have to be from the same source table.

If fieldnumbers are the same, you can use transferfields to copy identical fields from one record to another. If the tables are totally different, you have to assign every field manually.

Nitesh

If the tables are totally different, you have to assign every field manually.



i didnt get how it can b done..but anyways thank you..

todro

Nitesh wrote:

If the tables are totally different, you have to assign every field manually.



i didnt get how it can b done..but anyways thank you..

Maybe I got you wrong.

with "manually" I meant a normal assignment to the record fields, e.g.

SalesLine....
SalesLine.Description := Item.Description;
SalesLine."No." := Item."No.";
SalesLine.insert;

etc.

SharonVelankanni

you can try like this

table1 - record data type
table2 - record data type

if table2.find('-') then
repeat
  table1.transferfields(table2);
  table1.insert;
until table2.next = 0;

provided, your table2's field numbers should match with your table1's field numbers and their data type should also match

arindom

"COPY (Record)
Use this function to copy a record from a C/SIDE table. All filters, marks, and keys are included in the copy.

Record.COPY(FromRecord)"


The COPY function copy all the filters from table2 to table1 .So If the tables or table fields are not same then COPY are not working .If u want to assign two differnt field value then if the field IDs and data type both tables are same then use TRANSFERFIELD function .otherwise assign manualy all field from table2 to table1 .