Description
Deletes features in a table by performing a query on a table using an MI SQL Delete command string. In some cases the table will need a primary key column, depending on the data provider and the query. See the MapInfo SQL Language Reference for detailed information on MI SQL commands and functions.
ACL Authorization Flow
To delete features in a named table, the user (or the role they belong to) needs both EXECUTE and DELETE permission on the Named table.
Messages
The following table lists the request and response messages for the deleteBySQL operation.
Click on a message name to get more information about the message.
| Message | Description |
|---|---|
| DeleteBySQLRequest | The request message for the deleteBySQL operation. |
| DeleteBySQLResponse | The response message for the deleteBySQL operation. |
Example
Example request for deleting features in a table using the MI SQL Delete command with a bound parameter:
<DeleteBySQLRequest
xmlns:ns2="http://www.mapinfo.com/midev/service/featurecollection/v1"
xmlns:ns3="http://www.mapinfo.com/midev/service/style/v1"
xmlns:ns4="http://www.mapinfo.com/midev/service/geometries/v1"
xmlns:ns5="http://www.mapinfo.com/midev/service/table/v1"
xmlns:ns6="http://www.mapinfo.com/midev/service/feature/v1">
<ns6:SQL>delete from "/MyTable" where IntCol = @param1</ns6:SQL>
<ns6:BoundParameterList>
<ns6:BoundParameter name="param1">
<ns6:Value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2:IntValue">
<ns2:Value>100</ns2:Value>
</ns6:Value>
</ns6:BoundParameter>
</ns6:BoundParameterList>
</DeleteBySQLRequest>