Try to insert data using SQL query
Question

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

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




hi

If i want to update  then what i should?

Hi Sourabh,

You can write the update statement 

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

Best Regards

Devendra

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


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).


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