Home > Forum > Database > insert into database

insert into database
0

MVP

Hi Arthuzad,
the question is very vague, but i'll give few shots to answer:

1. Inserting / Updating on database provided by WEBCON breaks EULA point 3.6 / 1.23 (https://webcon.com/wp-content/uploads/2025/05/WEBCON_EULA_EN_2025.pdf).
2. If you need to import some data into a dictionary, then the easiest option would be Import/Export by Excel
* https://docs.webcon.com/docs/2025R2/Studio/Studio_ToolBar_Import/
3. If there is a lot of records required >500, then it might be better to do it via Cyclic Action, or REST Api, I've written a series which describes both ways: https://blog.lumenn.pl/importing-data-to-webcon-1/

In reply to: Maksymilian Stachowiak

Hi Arthuzad,
the question is very vague, but i'll give few shots to answer:

1. Inserting / Updating on database provided by WEBCON breaks EULA point 3.6 / 1.23 (
https://webcon.com/wp-content/uploads/2025/05/WEBCON_EULA_EN_2025.pdf).
2. If you need to import some data into a dictionary, then the easiest option would be Import/Export by Excel
* https://docs.webcon.com/docs/2025R2/Studio/Studio_ToolBar_Import/
3. If there is a lot of records required >500, then it might be better to do it via Cyclic Action, or REST Api, I've written a series which describes both ways: https://blog.lumenn.pl/importing-data-to-webcon-1/

there needs only one item to be inserted, and the data should come from the mentioned item list. as i said i have created a query with "insert into" but i don't know how guid wll be generated and how to access wanted dictionary

MVP
In reply to: Arthuzad

there needs only one item to be inserted, and the data should come from the mentioned item list. as i said i have created a query with "insert into" but i don't know how guid wll be generated and how to access wanted dictionary

I'm assuming there are 2 processes then:
1. Dictionary
2. Process which on some form has an item list.

If you want to add something to the dictionary - by "insert" i'm assuming it's a new document, then you could try to use start a subworkflow action:
* https://docs.webcon.com/docs/2025R2/Studio/Action/Workflow/StartWorkFlow/
for updating an item in a dictionary you could try to use update related workflow instance:
* https://docs.webcon.com/docs/2025R2/Studio/Action/Workflow/UpdateParentWorkflow/

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.