Question
delete multiple rows in database
Hi,
I wanted to delete multiple rows in sql database. I have given the input as infotable which has default datashape that I have binded the grid to. The grid data selected rows I am giving as input to the multi delete service infotable ip. I tried using the grid advanced but the code does not work.
The Things["Bobcat_DBConfig"].Delete_Organization(params) is the service which has sql query to delete the row (
WITH cte AS
(
SELECT ROW_NUMBER() OVER(ORDER BY org_id) AS Row
FROM Organization
)
DELETE FROM cte
WHERE Row = [[rowNum]] )
How could I resolve this?
Thanks in advance,
Shalini V.

