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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

pankaj.k 994 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

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 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

Was this reply helpful? Yes No