Get last record + 1

Dynamics 365 Business Central/NAV Developers Forum
1

I want to insert a record. So I find the last record of table + 1.

I have this;

//Begin insert contact:

IF “”.“Digital shipment” = TRUE THEN BEGIN

//MESSAGE(‘ja’);

KlantContact.INIT;

KlantContact.Type := 1;

IF KlantContact.FINDLAST = TRUE THEN

KlantContact.“No.” :=KlantContact.“No.” + 1;

// KlantContact.“No.” := KlantContact.“No.”.FINDLAST; //‘1127’;

// MESSAGE(KlantContact.“No.”.FINDLAST);

KlantContact.Name := ‘Crediteuren administratie’;

//MESSAGE(KlantContact.“No.”);

// END;

KlantContact.VALIDATE(KlantContact.“Company No.”, BussinesContactName.“Contact No.”);

KlantContact.INSERT;

END;

But I get this error:

Type conversion is not possible, Code + Integer. on the line: KlantContact.“No.” :=KlantContact.“No.” + 1;

KlantContact."No is a varchar.

Thank you

2

If you want to increment a code value, use INCSTR

https://msdn.microsoft.com/en-us/library/dd338972(v=nav.90).aspx

3

Thank you!! that did the job