FYI
/Sik
FYI
/Sik
Quote
During the Implementing Enterprise Applications with the Geodatabase presentation at the 2009 ESRI Developer Summit a couple weeks ago, we talked about a handy tool that can be added to ArcMap to send SQL to the connected database. This tool uses the IWorkspace.ExecuteSQL method and it can be very useful in starting and stopping a DBMS trace directly from ArcMap when profiling an operation.
The tool can be downloaded from the ESRI ArcGIS Resource Center for developers in the ArcGIS Desktop .NET Code Gallery. Click here to go directly to the tool.
ExecuteSQL Command for ArcMap
This command may be used to executeSQL against a connected database. It uses the ArcObjects IWorkspace.ExecuteSQL method. It is very useful in starting DBMS tracing from ArcMap. Usage: -Add data to ArcMap -Select a feature layer -Click the command button -Enter sql to execute -Click ok Example SQL to start a trace: ORACLE: alter session set events '10046 trace name context forever, level 12' SQLServer: master..sp_trace_setstatus 1 Informix: set explain on
|   |
Report Inappropriate Content: This Code Gallery is intended for the free exchange of code related to ESRI software products. Let us know if this entry is inappropriate (e.g., a download for a commercial product).
Read more:
Ingen kommentarer:
Send en kommentar