How to copy a record between two tables

a.mouttou

hi all,
I'm trying to copy the record of the table 5082 to a user custom table
50011 so i've made a report with the 5082 table.

In the OnAfterGetRecord i put this C/SIDE

//stat : record : 50011

stat.init;
stat.copy("Value Entry");

But i've got a Message telling me that all filters can't be copied at the same time and that only record from the same table can be copied.

Did anyone already try something like this.I don't wanna copy each fileds betwenn the twotables.

Thanks.

DenSter

If you copied table 5082 as table 50011, then you may have added fields to table 5082 that have not been added to table 50011. When you do a COPY, navision will attempt to put the values of all fields in the source table into identical fields in the target table. When it doesn't find these fields, you get the error you mentioned.

You can only use the COPY command if both record variables are of the same type, and then only if both tables have the same structure. You need to make this happen, or I'm afraid you're going to have to assign the fields individually.

HTH

zarryn

You might want to try TRANSFERFIELDS. It can be used between two different records. The on-line help gives a good description of the functionality and use.

DenSter

TRANSFERFIELDS only works for the fields in the source table that also exist in the target database, and with the same numbers.

SteveO

Hi,

I think that TRANSFERFIELDS is the command you are looking for.
Check out the help for more info.

a.mouttou

hi all,
Thanks TRANSFERFIELDS is the solution.
Regards guys.