Microsoft Dynamics NAV (Archived)

What is delayed Insert and How it works?

(0) Share

Report

Posted on by Community Member

Hi Experts,

what is delayed insert property in Pages and how it works?

i have some Questions on that can any clarify this one...

1. it is workable to any datatype?

2. but some where i didn't find for decimal datatype fields?

3. i need also AutoSplitKey?

4. Difference b/w this above two?

please give Information i already did R&D on

==>http://forum.mibuso.com/discussion/17380/autosplitkey-and-delayed-insert

==> https://msdn.microsoft.com/en-us/library/dd301257(v=nav.80).aspx

Can any Explain this above second link

Regards,

Ramesh.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (3)

Verified answer

keoma 32,729 on at

Like (0)

Report

delayed insert:

describes, when the record changes are inserted to database (when leaving record, means when going e.g. to next record, or ... when leaving the control on the page after changing the value in the control).

does not depend on datatype.

follow

msdn.microsoft.com/.../dd301257.aspx

http://forum.mibuso.com/discussion/17380/autosplitkey-and-delayed-insert

Was this reply helpful? Yes No
keoma 32,729 on at

Like (0)

Report

here you'll find a sample how to use delayed insert and autosplit key

i1.blogs.msdn.com/.../nav-design-pattern-document-pattern.aspx

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Delayed insert check my example in this forum

community.dynamics.com/.../156714

The AutosplitKey is used to generate the number automatically for you for the last field on the primary key

The last field in the primary field must be an Integer Data Type, BigInteger Data Type, GUID Data Type, or Decimal Data Type field.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

When user complete the data entry for the primary key field NAV will save the record to DB. But by setting delayed insert to Yes, NAV will wait till you move to next record without saving the record to DB. This works with any datatype.

When u have a composite primary key in a table, last key field will generate automatically if the last field is a Integer Decimal,BigInteger, GUID Data datatype and set the AutoSplitkey is set to yes.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

Hi,

The second link also depicts the same thing which Jonathan, Suresh and Tharanga have mentioned.

Was this reply helpful? Yes No