deleteBySQL

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 any roles they belong to) will need Execute and Delete permissions on the named table in the following manner:

  • EXECUTE” for entity type “Location Intelligence.Named Resources”
  • “DELETE” for entity type “Location intelligence.Dataset.DML”

Messages

Note: You must have View permissions on the named table as well as Create/Modify/Delete permissions on the named table's associated dataset to perform insert, update, and delete operations on writable tables. See Access Control for Datasets in the Administration section for more information.
Note: Delete is supported on PostGIS, Oracle, SQL Server, GeoPackage, and generic JDBC tables. It also supported on MapInfo native TAB and extended native TAB (NativeX) files on Windows operating systems only. Named tables with composite primary keys are not writable.

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>