POST
|
Hello all, I have an ArcObjects add-in that works fine on the company server with and ArcSDE SQL Server database, but on the client's network, when the app attempts to save a new point, or changes to an existing point, it gets the following error: "The requested operation is invalid on a closed state. [StellarRoutes.DBO.Commercial_Bin_Points] State_ID = 14" Here is the code: Protected Function SaveContChanges() Dim pDataset As ESRI.ArcGIS.Geodatabase.IDataset Dim tTable As ESRI.ArcGIS.Geodatabase.Table Dim pfeatWorksspace As ESRI.ArcGIS.Geodatabase.IFeatureWorkspace Dim m_pqueryfilter As ESRI.ArcGIS.Geodatabase.QueryFilter Dim pcur As ESRI.ArcGIS.Geodatabase.ICursor Dim prow As ESRI.ArcGIS.Geodatabase.IRow Try StartEditSession() m_pLayer = GetLayer(ComboValue) pFLayer = m_pLayer pDataset = pFLayer pfeatWorksspace = pDataset.Workspace tTable = pfeatWorksspace.OpenTable("DBO.Commercial_Bin_Points") m_pqueryfilter = New ESRI.ArcGIS.Geodatabase.QueryFilter m_pqueryfilter.WhereClause = "Bin_ID = '" & txtBinID.Text & "'" pcur = tTable.Search(m_pqueryfilter, False) prow = pcur.NextRow prow.Value(pcur.FindField("ContSize_ID")) = cboContSize.SelectedValue prow.Value(pcur.FindField("ContColor_ID")) = cboContColor.SelectedValue prow.Value(pcur.FindField("Route")) = cboRoutes.SelectedValue prow.Value(pcur.FindField("ServiceType_ID")) = cboServiceType.SelectedValue prow.Value(pcur.FindField("PickupType_ID")) = cboPickupType.SelectedValue prow.Value(pcur.FindField("Notes")) = txtBinNotes.Text prow.Value(pcur.FindField("X")) = Val(txtX.Text) prow.Value(pcur.FindField("Y")) = Val(txtY.Text) prow.Value(pcur.FindField("ADDRESS")) = cboAddress.Text prow.Store() StopEditSession() Catch exception As Exception MsgBox("Error: " & exception.Message) End Try End Function Public Shared Sub StartEditSession() Dim pDataset As ESRI.ArcGIS.Geodatabase.IDataset Dim editor As ESRI.ArcGIS.Editor.IEditor editor = My.ArcMap.Application.FindExtensionByName("esriEditor.Editor") ' If ComboValue Is Nothing Then ' MsgBox("Please Select the edit feature in the combobox!.") ' Exit Sub ' End If m_pLayer = GetLayer(ComboValue) pFLayer = m_pLayer pDataset = pFLayer If editor.EditState <> ESRI.ArcGIS.Editor.esriEditState.esriStateEditing Then editor.StartEditing(pDataset.Workspace) editor.StartOperation() End If End Sub Public Shared Sub StopEditSession() Dim pDataset As ESRI.ArcGIS.Geodatabase.IDataset = Nothing Dim editor As ESRI.ArcGIS.Editor.IEditor editor = My.ArcMap.Application.FindExtensionByName("esriEditor.Editor") m_pLayer = GetLayer(ComboValue) pFLayer = m_pLayer pDataset = pFLayer If editor.EditState <> ESRI.ArcGIS.Editor.esriEditState.esriStateNotEditing Then Try editor.StopOperation("Add/Edit Container") editor.StopEditing(True) Catch ex As Exception MsgBox(ex.Message, MsgBoxStyle.Critical) End Try End If End Sub I'm banging my head against the wall here. I can't see why this works on my network and not on the clients. Any help would be very much appreciated. Jeff
... View more
04-01-2016
01:33 PM
|
0
|
1
|
4056
|
POST
|
Hello and thank you for the help I've gotten from this community on other questions. I'm developing an add-in in VB.Net. When the user opens a map, I'd like to be able to make the add-in's toolbar or a menu button blink if there are records in a table. Is this possible?
... View more
08-15-2015
05:56 AM
|
0
|
0
|
2869
|
POST
|
Hi all, I'm a contractor working with the local city government on a project. I don't normally work with ArcGIS but the city was able to allow me to check out a license and install ArcGIS 10.0. That install also included the VB.Net ArcObjects 10.0. They recently upgraded to ArcGIS 10.2. When I ran the upgrade, it required that all of ArcGIS 10.0 be uninstalled, including ArcObjects. The install for ArcGIS 10.2 did not include the option to install ArcObjects 10.2. What do I need to do? I've looked for someplace to download ArcObjects without success. The city IT department is understaffed, so it takes them a long time to respond to any request. Thank you for any advice you can offer. Jeff
... View more
06-29-2015
07:04 AM
|
0
|
1
|
3203
|
POST
|
I found an example of using the iReportEngine interface to generate and export reports, but it looks to me like that was included in ESRI.ArcGIS.ArcMap in a version after ArcObjects 10.0. Is that the case? If so, is there something similar that I'm missing in ArcObjects 10.0? ArcMap has the report viewer available on the View menu, so I'm hoping that's it. Thank you, Jeff
... View more
02-19-2015
03:23 PM
|
0
|
0
|
2845
|
POST
|
I was getting that same error. I looked at the query filter string that I was sending and discovered a SQL error in it.
... View more
01-26-2015
07:17 AM
|
0
|
1
|
1679
|
POST
|
My apologies for the newbie question, but I'm a little confused on the steps to add a point to a layer in VB.Net. I've created a tool that gets the X and Y when the user clicks on the map. If they clicked on a point, it returns data about that point. This is all working well. If they click on an area without a point, I want to create a point there and then allow the user to enter attribute information in a form that will then save to the attribute table. Can you point me toward a sample or walkthrough that shows the process? Thank you.
... View more
01-21-2015
07:14 AM
|
0
|
0
|
2896
|
POST
|
Hi all, I am brand new to programming for ArcGIS, so please bear with me. I'm hoping that there is a sample or walkthrough for this. When a user clicks on a point I need to be able to read the value in a field in the attribute table for that point (I will then open a form that reads data from an external database and allows the user to edit it. In the same vein, I need to allow the user to click on a tool and then click a spot on the layer and create a point there, then open the same form as above and enter the data about the point. Any guidance would be greatly appreciated. I'm programming in Visual Studio 10 (VB.Net) and ArcGIS 10. J
... View more
01-15-2015
05:03 PM
|
0
|
2
|
4413
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|