Insert record in Temporary table

(0) Share

Report

Posted on by jsshivalik

3,099

I have below code . Is there any better way to save data in Temporary table . I have ILERec with Record DataType & SubType = Item Ledger Entry. Temporary = 'Yes'

Item Ledger Entry - OnAfterGetRecord()

ILERec.RESET;
ILERec.SETRANGE("Item No.","Item No.");
ILERec.SETRANGE("Lot No","Lot No");
IF ILERec.FINDFIRST THEN Begin
CurrReport.Skip;
end else begin
ILERec."Entry No." := "Item Ledger Entry"."Entry No.";
ILERec."Item No." := "Item Ledger Entry"."Item No.";

ILERec."Lot No" := "Item Ledger Entry"."Lot No";
ILERec.INSERT;
End;

Thanks

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

ILERec.RESET;

ILERec.SETRANGE("Item No.","Item No.");

ILERec.SETRANGE("Lot No","Lot No");

IF NOT ILERec.ISEMPTY THEN

CurrReport.Skip

else begin

ILERec.RESET;

ILERec.INIT;

ILERec := "Item Ledger Entry";

ILERec.INSERT;

End;

Was this reply helpful? Yes No