SubPage ListPart Insert with InsertAllowed = No in Mainpage

DerBexucher1

Hello,

I am currently facing the issue, that users should have the possibility to create new rows in a SubPage of Type ListPart, but mustn't alter, insert or delete the SourceTable of the Mainpage. But when I set InsertAllowed = No the ListPart is also not "insertable".

Is there a way to achieve that?

Thanks

Btw.: I tried SubPage of Type List, but then inserted rows disappeared after refreshing the page.

Slawek_Guzek

Set PageType to Document, set InsertAllowed=No, DeleteAllowed=No, leave ModifyAllowed=Yes, change Editable on all top level groups to FALSE.

If you take standard Page 51 as an example:



The net effect is:



in Edit mode:

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

Mark_Smart

As a workaround, you can try making the main page editable with default properties for modify and insert, and interrupt the page insert/modify/delete triggers to return false. Also set all of the page fields to non editable:

OnInsertRecord(BelowxRec : Boolean) : Boolean
EXIT(FALSE);

OnModifyRecord() : Boolean
EXIT(FALSE);

OnDeleteRecord() : Boolean
EXIT(FALSE);

You may want to use a message or error for user feedback.


As to your lines disappearing, often it it important in an editable subpage to set any filtered fields from the subpage link/view and page view. Check that the lines you inserted (run the table directly) have right field values in that are filtered in your subpage link and views/filters. The most common method to do this is in the OnNewRecord trigger of the subpage eg:

OnNewRecord(BelowxRec : Boolean)
"Document Type" := GETRANGEMAX("Document Type");
"Document No." := GETRANGEMAX("Document No.");

This will work fine with any combination of MultipleNewLines, DelayedInsert and Autosplitkey.


Alternatively, you may try header page types of Worksheet, Document, StandardDialog etc. Different page types affect the EDITABLE property differently.

Slawek_Guzek

Set PageType to Document, set InsertAllowed=No, DeleteAllowed=No, leave ModifyAllowed=Yes, change Editable on all top level groups to FALSE.

If you take standard Page 51 as an example:



The net effect is:



in Edit mode:

DerBexucher1

Thank you both for your input.
Slawek_Guzek's answer works perfectly.