use of Table.InitValue()

(0) Share

Report

Posted on by @rp@n

Dear All,

I saw in many standard code that when they insert records in table. So, they called Table.InitValue() then Table. insert().

Example :

TTsbegin;

Table.InitValue()

// to do

Table.Insert();

TTScommit;

Can you please let me know when we called Table.initValue() what impact will happened before insert records in table?

TTSbegin and TTScommit is mandatory to write on Table.insert().

Please give me more shed on this.

Thanks!
Arpan Sen

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Sefa Duman 1,167 on at

Like (0)

Report
Copy link

Link copied!

Hi Arpan,

See this topic for detailed information:

[View:https://community.dynamics.com/ax/f/33/t/161489]

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

Thanks Sefa

Was this reply helpful? Yes No
Pravasti AK 2,985 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please refer the below link:

https://community.dynamics.com/ax/f/33/t/161489

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report
Copy link

Link copied!

Specifically calling initValue() is a good idea, but there are more detailed explanations in the linked topics.

They usually initialize values which should be populated with a default value, like for SalesTable's Sales status you do not want to have None, but rather the enumeration value which belongs to Open sales order, which is not the first entry for the SalesStatus enum. In that case you'd want to initialize it, and that is done in initValue() call as the first step after the .create() operation on the record buffer. You can also find buffer-based initalization which can be seen as initFromTableName(), to copy over values, like from SalesTable to SalesLine.

TTS block is not required for insert operations, unless you have business logic there that is not for that table in question. TTS block should only be used if you want to roll back the entire section that happens in there in case anything raises an error, so is typically used if you have postings, multiple table inserts, and so on, so you do not leave behind half-baked transactions.

Was this reply helpful? Yes No