Web API Reference | MapGuide Open Source

- Overview
- Modules
- Classes

CreateFeatureSource
DescribeSchema
DescribeSchema
DescribeSchemaAsXml
DescribeSchemaAsXml
DescribeWfsFeatureType
EnumerateDataStores
ExecuteSqlNonQuery
ExecuteSqlQuery
GetCapabilities
GetClassDefinition
GetClasses
GetConnectionPropertyValues
GetFeatureProviders
GetLockedFeatures
GetLongTransactions
GetSchemaMapping
GetSchemas
GetSpatialContexts
GetWfsFeature
SchemaToXml
SelectAggregate
SelectFeatures
SelectFeatures
SetLongTransaction
TestConnection
TestConnection
UpdateFeatures
XmlToSchema
virtual INT32 MgFeatureService::ExecuteSqlNonQuery | ( | MgResourceIdentifier * | resource,
|  | CREFSTRING | sqlNonSelectStatement |
| ) |  |  | `[pure virtual]`
Executes SQL statements NOT including SELECT statements. Remarks: The XML returned by MgFeatureService::GetCapabilities says whether a provider supports SQL commands. See Provider Capabilities . .NET Syntax
`virtual int ExecuteSqlNonQuery(MgResourceIdentifier resource, string sqlNonSelectStatement);`
Java Syntax
`virtual int ExecuteSqlNonQuery(MgResourceIdentifier resource, String sqlNonSelectStatement);`
PHP Syntax
`virtual int ExecuteSqlNonQuery(MgResourceIdentifier resource, string sqlNonSelectStatement);`
  Parameters:
  | resource | (MgResourceIdentifier) A resource identifier for a feature source.
  | sqlNonSelectStatement | (String/string) The SQL statement that is NOT a SELECT statement.
Returns: Returns a positive integer value indicating how many instances (rows) have been affected. Example (PHP)
     $sql = "update featclass set abyte = 37 where featid = 0";
     $numRows = $featureService->ExecuteSqlNonQuery($activeFeatSrcResId, $sql);
  Exceptions:
  | MgFeatureServiceException |
  | MgInvalidArgumentException |
  | MgInvalidOperationException |
  | MgFdoException |

Comments or suggestions? Send us feedback.