We are trying to delete all rows in a SQL Table where ToDelete=true. There are about 8 rows that meet this criteria.
The following code does not remove any rows from SQL Server:
RemoveIf('[dbo].[Material]',ToDeleted = true)
Is there something wrong with the syntax ?
Go to Solution.
The RemoveIf doesn't work on tables.
The correct syntax is:
Remove('[dbo].[Material]',Filter('[dbo].[Material]',IsDeleted = true));
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.