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/

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/