laptop and a wrench

Bug

Recordset.AddNew results in an AXF_STATUS of 'geometry modified' instead of 'created.'

Last Published: January 1, 2015 ArcPad
Bug ID Number NIM075530
SubmittedNovember 17, 2011
Last ModifiedJune 5, 2024
Applies toArcPad
Version found10.0
Version Fixed10.2.2
StatusFixed

Workaround

Use the DataSource object and SQL statements to programmatically add data.The following example programmatically adds a pole to the Riverside sample’s 'Poles' layer. This code references the Poles layer in the Riverside_mdb.axf file from the installed sample data.<a href="file:C:/Users/Public/Documents/ArcPad/Samples/Riverside" target="_blank">C:\Users\Public\Documents\ArcPad\Samples\Riverside</a>Dim objLayer, objDS, X, YSet objLayer = Map.Layers("Poles")Set objDS = objLayer.DataSourceX=Map.PointerXY=Map.PointerYDim strSQLstrSQL = "INSERT INTO [POLES] (POLEID,SHAPE_X,SHAPE_Y, AXF_TIMESTAMP, AXF_STATUS) VALUES (100011" & "," & X & "," & Y & "," & "GETDATE(),1)"objDS.Execute strSQLMap.Refresh(True)Set objLayer = NothingSet objDS = Nothing------------------------------------------------------------------------------When adding new polylines or polygons, users may need to just use RecordSet.AddNew, but before check-in of the AXF data, open it in ArcPad Studio, search for the newly added records then set the value of AXF_STATUS to 'created'. This workaround is based on the assumption that user only creates new records in the field, i.e, no geometry modification is performed at the same time The other workaround - use Map.AddFeature -- can also add new records to the current editable layer in the map and the value of the AXF_Status field is correct in AXF file

Steps to Reproduce

Bug ID: NIM075530

Software:

  • ArcPad

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options