NAV perpetual licensing for limited user and writing to temporary tables

kytoh

Hi, may I know if writing (Insert/Modify) to a temporary table will consume the Limited User write count limit?
I can't seem to find an official answer to this. Thanks.

Kepty

Hello kytoh,
I tried to find any official answer but without success. I prepared script to test it

TempCompanyInformation.INIT;
TempCompanyInformation.INSERT(FALSE);
MESSAGE('1');

TempLocation.INIT;
TempLocation.INSERT(FALSE);
MESSAGE('2');

TempResponsibilityCenter.INIT;
TempResponsibilityCenter.INSERT(FALSE);
MESSAGE('3');

TempResource.INIT;
TempResource.INSERT(FALSE);
MESSAGE('4');

Item.INIT;
Item.INSERT(FALSE);
MESSAGE('5');

GLAccount.INIT;
GLAccount."No." := 'ssssyx';
GLAccount.INSERT(FALSE);
MESSAGE('6');

Language.INIT;
Language.INSERT(FALSE);
MESSAGE('7');

SalespersonPurchaser.INIT;
SalespersonPurchaser.INSERT(FALSE);
MESSAGE('8');

ERROR('OK');

The tables with prefix Temp are temporary tables The other tables are normal tables. If I set up my user account as a Limited user and run this code, the messages are showed up to number 7, next is an error that I do not have the permission to write to the SalespersonPurchaser table.

So the result is = the temporary tables are not included in the limit.

Tomas

Kepty

Hello kytoh,
I tried to find any official answer but without success. I prepared script to test it

TempCompanyInformation.INIT;
TempCompanyInformation.INSERT(FALSE);
MESSAGE('1');

TempLocation.INIT;
TempLocation.INSERT(FALSE);
MESSAGE('2');

TempResponsibilityCenter.INIT;
TempResponsibilityCenter.INSERT(FALSE);
MESSAGE('3');

TempResource.INIT;
TempResource.INSERT(FALSE);
MESSAGE('4');

Item.INIT;
Item.INSERT(FALSE);
MESSAGE('5');

GLAccount.INIT;
GLAccount."No." := 'ssssyx';
GLAccount.INSERT(FALSE);
MESSAGE('6');

Language.INIT;
Language.INSERT(FALSE);
MESSAGE('7');

SalespersonPurchaser.INIT;
SalespersonPurchaser.INSERT(FALSE);
MESSAGE('8');

ERROR('OK');

The tables with prefix Temp are temporary tables The other tables are normal tables. If I set up my user account as a Limited user and run this code, the messages are showed up to number 7, next is an error that I do not have the permission to write to the SalespersonPurchaser table.

So the result is = the temporary tables are not included in the limit.

Tomas

kytoh

Thank you both for the answers. And to Kepty, I appreciate your effort in testing it out and sharing the result.