Log in to AnswerLog in to Follow
2022-03-15 19-09-35
Sourabh sharma
28Views
5Comments
Solved
Try to insert data using SQL query
Question
SQL
Aggregate

 Unable to insert/update data using SQL Widget can anyone helpme.step by step.

0
0
18 Mar

Hi Sourabh,

Below are the steps 

1. Drag and drop SQL widget

2  Create input parameters (the columns that need to updated or inserted)

3 Write SQL query (Insert/Update) some thing similar to attached image by using the input parameters 

4. Add out put parameter (you can return the entity)


Best Regards

Devendra




1
0
18 Mar

hi

If i want to update  then what i should?

0
0
13 Apr

Replying to Sourabh sharma's comment on 13 Apr 2022 09:11:59

Hi Sourabh,

You can write the update statement 

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition; 

Best Regards

Devendra

1
0
13 Apr

Hello saurabh,

Adding to upper comment :

Go through this documentation  https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/SQL_Queries

where you can get overview and used of SQL queries .

Thanks and Regards,

Akshay Deshpande


0
0
18 Mar

Hi Sourabh!
Adding to what was already said, don't forget that, since you're inserting data, you should have the SQL inside the module where you have your entities (if they are exposed read-only, as they should be).


0
0
18 Mar
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.