ThinkGeo.com    |     Blog    |     Wiki    |     Support

Can't we delete feature using ExecuteNonQuery method in QueryTools

When I tried to delete feature its showing “The SQL Query mode is not supported.”

int result = _crudLayer.QueryTools.ExecuteNonQuery("delete * from table Name where "); //The SQL Query mode is not supported.

Can’t we delete feature using ExecuteNonQuery method rather than editing tools ? i.e.,

myFeatureLayer.EditTools.BeginTransaction();
myFeatureLayer.EditTools.Delete(myFeature.Id);
myFeatureLayer.EditTools.CommitTransaction();

Hi,

Our QueryTools for shape file is supported via OLEDB, I think Delete via ExecuteNonQuery is not supported.

You can delete it just like your code shows by the Delete API.

Regards,

Ethan

OK, Thank you …

Hi,

Thanks for your update.

Regards,

Ethan