Small and medium business | Business Central, N...

Fill table via Visual Studio

(0) Share

Report

Posted on by densonx21

Hello dear forum,
I've been working on a project for the university for a long time. I have to fill a table via Visual Studio with the information of another already given table. Unfortunately, I don't know how to do that. I would be happy if you could help.

Kind regards
Danny

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (0)

Report

RE: Fill table via Visual Studio

Hi, If you mean to insert values, you can use Record.Insert() Method.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-insert--method

Hope this helps as well.

Thanks.

ZHU
Suggested answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

RE: Fill table via Visual Studio

hi

try this

local procedure InsertSyncTableLoop()

var

SourceTable: Record SourceTable;

SyncTable: Record "Sync Table";

begin

if SourceTable.FindFirst() then

repeat

SyncTable.Init();

SyncTable."Primary Key" := SourceTable."Primary Key";

SyncTable.D1 := SourceTable.S1;

SyncTable.D2 := SourceTable.S2;

SyncTable.D3 := SourceTable.S3;

SyncTable.Insert();

until SourceTable.next = 0;

end;

check my answer if it helped you, thanks

DAniele
Suggested answer

pankaj.k 962 on at

Like (0)

Report

RE: Fill table via Visual Studio

Hi Densonx21

Please check the below link that will help you to insert data in new table.

https://learn.microsoft.com/en-US/dynamics365/business-central/dev-itpro/administration/set-up-standard-company-configuration-packages

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extension-install-code

Have a great day!

Don't forget to help the community by verifying the answer if your question has been answered. It will let others know that the topic has verified answer.

Thanks,

Contact Info: kuwalpankaj97@gmail.com