mibuso.com
Home› NAV Three Tier
Options

Error message when create new record

moneimmoneim Member Posts: 13
edited 2012-06-29 in NAV Three Tier
hello !
I created a document page based on new tables (pict001)
but when i trying insert new group from the list (pict002) ,an error message is browsed (pict003)

someone can help me plz ???

tables used :
country group (code ,name) //Header
country group line (country group code,country code,country group name,country name)
//country group code from table group and country code from table country

Comments

  • Options
    rocatisrocatis Member Posts: 163
    Try to set DelayedInsert=Yes on your "List of Countries" page.
    Brian Rocatis
    Senior NAV Developer
    Elbek & Vejrup
  • Options
    udayrmerudayrmer Member Posts: 171
    I think you had wrongly linked subform with the table,

    can you please share primary key of both the table, and subform link relation.

    one more thing, try setting subform property DelayInsert = true
    Uday Mer | MS Dynamics NAV Techno-Functional Consultant
  • Options
    moneimmoneim Member Posts: 13
    I set delayedinsert = true in my page list and my subform but the same error message appears .

    I screen print my tables structure and my subform with properties

    someone have idea plz ??

    thx
  • Options
    BeliasBelias Member Posts: 2,998
    what's the page type of your subform? it should be listpart.
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Options
    udayrmerudayrmer Member Posts: 171
    Have you defined any Testfield On OnOpenForm, or OnafterCurrRecord, Or OnafterGetRec ?
    Uday Mer | MS Dynamics NAV Techno-Functional Consultant
  • Options
    moneimmoneim Member Posts: 13
    My page subform is of type listpart and I don't use Testfield :(
  • Options
    udayrmerudayrmer Member Posts: 171
    any coding is there on line table or form ?
    Uday Mer | MS Dynamics NAV Techno-Functional Consultant
  • Options
    moneimmoneim Member Posts: 13
    Ohhhh ! yes I have Testfield in my table Group Line in trigger OnValidate() :^o
    I deleted it and it works now

    Thank you mibuers =D>
  • Options
    udayrmerudayrmer Member Posts: 171
    You are always welcomed
    Uday Mer | MS Dynamics NAV Techno-Functional Consultant
  • Options
    beranberan Member, Microsoft Employee Posts: 80
    I saw a comment on using DelayedInsert on a header in the header/line pattern. This has to be done with carefullness. Currently in the released Beta version of 2013 you will the action with no error but it will return in the final version 2013.

    As said with carefulness the Delayed Insert can be used in the header/line pattern. For instance you can find it in the User table in the final release of Nav 2013. It does not set the key value in the OnNewRecored but in the OnInsertRecord.

    The reason getting this error is that the execute data fetch is called WHEN the filter has changed. The filter is changed when you fill out the key in the header which is connected to the filter on the line. But the record has not been saved yet so therefore you get the error. It will close the page going forward.
    Eric Beran
    Software Design Engineer II
    Dynamics NAV Office 365
    Microsoft

    This posting is provided "AS IS" with no warranties, and confers no rights.
Sign In or Register to comment.