Unable to delete data from custom table
Question
Application Type
Service
Service Studio Version
11.11.7 (Build 45559)

Hi, 

I am unable to delete data from table. 

I usually do, 

 Delete from {tablename};

 Exec('com'+'mit') ;

These comments with SQL widget with some dummy structure or same entity. 

This is throwing error now stating "commit is present so query did not executed".

Is there any changes I should do here or am I missing anything, Kindly help me. 


Thanks, 

Venkatesh S




mvp_badge
MVP
Solution

Hello there Venkatesh,


If you're trying to delete data from an entity directly from Service Studio (testing an SQL query), that way doesn't work anymore.

If you're calling an action that executes that query, you don't need to do a commit.


If you simply want to delete data from entities and clear them out, I suggest that you create a back office screen and some actions inside of it for that purpose.

Check this documentation that may guide you:

https://success.outsystems.com/Documentation/How-to_Guides/Data/How_to_delete_data_from_Entities


Kind regards,

Rui Barradas

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