Copying table records to duplicate table (date() / buf2buf)

(0) Share

Report

Posted on by Ashein

275

Hi everyone

I am trying to copy records from inventTable to my duplicateInventTable. But when i try, my duplicate table ends up being filled up with empty records.

I have tried to use buf2buf but when i create/duplicate inventTable it ends allocating new fieldId's so i can't use it.

And when i use data(), it just fills my duplicate table with empty records.

Please help.

4212.1.png

7026.2.png

*This post is locked for comments

All responses (12)

Answers (1)

Suggested answer

kehlet 462 on at

Like (0)

Report

RE: Copying table records to duplicate table (date() / buf2buf)

Can you explain what the purpose is? If you truly want a copy of the table, then you could just insert it in a SQL statement and adjust the SYSTEMSEQUENCES table for the DuplicateInventTable afterwards.

An alternative is to do an insert_recordset or a RecordInsertList with insertDatabase() at the end, which would be a bit slower, but allow for more granular control of the data to be inserted.

But, if you could give the purpose of this, it would be easier to help, unless the above helps.
NNikolov 5 on at

Like (0)

Report

RE: Copying table records to duplicate table (date() / buf2buf)

The buf2BufByName() should possibly check not only on name but also on type.
Brian Kinser 815 on at

Like (0)

Report

RE: Copying table records to duplicate table (date() / buf2buf)

a little late but.....would buf2buf by name work? I have used this successfully in the past for archiving and logging....basically just like buf2buf but use field names instead

static void buf2BufByName(Common _from, Common _to)
{
DictTable dictTableFrom = new DictTable(_from.TableId);
DictTable dictTableTo = new DictTable(_to.TableId);
DictField dictFieldFrom;
FieldId fieldIdFrom = dictTableFrom.fieldNext(0);
FieldId fieldIdTo
;

while (fieldIdFrom && ! isSysId(fieldIdFrom))
{
dictFieldFrom = new DictField(_from.TableId, fieldIdFrom);

if(dictFieldFrom)
{
fieldIdTo = dictTableTo.fieldName2Id(dictFieldFrom.name());

if(fieldIdTo)
_to.(fieldIdTo) = _from.(fieldIdFrom);
}

fieldIdFrom = dictTableFrom.fieldNext(fieldIdFrom);
}
}
Ashein 275 on at

Like (0)

Report

RE: Copying table records to duplicate table (date() / buf2buf)

Ok, thanks. I just thougth there were and easier way to do it.
Crispin John Augustine 37,081 on at

Like (0)

Report

RE: Copying table records to duplicate table (date() / buf2buf)

No, comparing fieldIds will only complicate things. I just wanted to point out that only manual assignment works with your code.

Andre's suggestion to use a Map is your best available standard AX option.
André Arnaud de Cal... 294,715 Super User 2025 Season 1 on at

Like (0)

Report

RE: Copying table records to duplicate table (date() / buf2buf)

Hi Ashein,

The map is an AOT object where you define the mapping once. Yes, you have to manually map it. You can write an own routine to search field ID's based on field names, but that would also be quite cumbersome.
Ashein 275 on at

Like (0)

Report

RE: Copying table records to duplicate table (date() / buf2buf)

Crispin, so i should compare each fieldId from both tables?
Ashein 275 on at

Like (0)

Report

RE: Copying table records to duplicate table (date() / buf2buf)

But if i use maps, then i would have to manually map every field to each table?
Crispin John Augustine 37,081 on at

Like (0)

Report

RE: Copying table records to duplicate table (date() / buf2buf)

I get what you think. (based on same field name)

The system understands based on fieldIds.
Verified answer

André Arnaud de Cal... 294,715 Super User 2025 Season 1 on at

Like (1)

Report

RE: Copying table records to duplicate table (date() / buf2buf)

Hi Ashein,

The buf2buf() and data() methods are intended to be used on the same table. You can try to use a table Map object where you can link fields of various tables.

More information can be found here: msdn.microsoft.com/.../bb278211.aspx