Latest Contributions by ForrestKaye

Thanks for the reply.  It was very helpful but I am still stuck. I have found the Subtype and associated CVD through the methods described above.  However, I cannot find which fields they are associated to.  Type -- associated with field_x? What I am trying to to is link a field in a form to the subtype, and a separate field in the same form with the Coded value domain per the subtype.  I have a form already populated with all of the feature attributes but can't find a way to link the fields with the subtype/CVD now.  I know that my type is associated with my field FEATURE_TYPE however I cannot figure that out from either return value. Here is what I get when I return getFeatureTypes(): [Type: [ id: 0, name: HumanFeature, domains: {FEATURE=CodedValueDomain: [ domainName:dom_AllFeatures_HumanFeatures_Ca codedValues:{Cultural=Cultural, Culvert=Culvert, Gate Cattleguard=Gate Cattleguard, GTLF=GTLF, Guzzler=Guzzler, Land Treatment=Land Treatment, Mine=Mine, Monitor Measure=Monitor Measure, Sign=Sign, Well=Well, Other AssetFacility=Other AssetFacility, Other Barrier=Other Barrier, Other Forestry=Other Forestry, Other Fire=Other Fire, Other HazMat=Other HazMat, Other Hydro=Other Hydro, Other Minerals=Other Minerals, Other Range=Other Range, Other Recreation=Other Recreation, Other Transport=Other Transport, Other Wildlife=Other Wildlife, Other=Other} ]}], Type: [ id: 1, name: NaturalFeature, domains: {FEATURE=CodedValueDomain: [ domainName:dom_AllFeatures_NaturalFeatures_Ca codedValues:{Barrier=Barrier, Fauna=Fauna, Flora=Flora, Geologic=Geologic, Hydrologic=Hydrologic, Monitor Measure=Monitor Measure, Paleo=Paleo, Spring=Spring, Other=Other} ]}], Type: [ id: 2, name: HumanEvent, domains: {FEATURE=CodedValueDomain: [ domainName:dom_AllFeatures_HumanEvent_Ca codedValues:{Explosive=Explosive, Fire=Fire, Hazmat=Hazmat, LawEnforcement=LawEnforcement, Recreation=Recreation, Other=Other} ]}], Type: [ id: 3, name: NaturalEvent, domains: {FEATURE=CodedValueDomain: [ domainName:dom_AllFeatures_NaturalEvent_Ca codedValues:{Astronomic=Astronomic, Fire=Fire, Geologic=Geologic, Hydrologic=Hydrologic, Meteorologic=Meteorologic, Other=Other} ]}], Type: [ id: 4, name: Other, domains: {FEATURE=CodedValueDomain: [ domainName:dom_AllFeatures_Other_Ca codedValues:{Other=Other} ]}]] Here is what I get when I return getEditableAttributeFields(): [Field [name=FEATURE_TYPE, alias=Feature_Type, type=esriFieldTypeSmallInteger, type_int=20, editable=true, length=0, ], Field [name=FEATURE, alias=Feature, type=esriFieldTypeString, type_int=60, editable=true, length=50, ], Field [name=NOTES, alias=Notes, type=esriFieldTypeString, type_int=60, editable=true, length=100, ], Field [name=BUFFER_FT, alias=Buffer_ft, type=esriFieldTypeInteger, type_int=10, editable=true, length=0, ], Field [name=DISTURBANCE_PCT, alias=Disturbance_Pct, type=esriFieldTypeInteger, type_int=10, editable=true, length=0, ]] Thanks for any more assistance you can provide. ... View more

Pretty sure you're going to need to do some sort of spatial query to your offline database then handle the results in some way. ... View more

The geodatabase was not created from ArcMap.  It was created from an online resource (Create Runtime Geodatabase sample) and downloaded as an editable runtime Geodatabase, so that is not the issue.  I am trying to use the 10.2.3 offline capabilities.  I did notice as I've been working through this that I was using Feature instead of GeodatabaseFeature.  Could this be where some of the issue stems from? Is my understanding correct in that a map.Feature is a graphic?  But can also have geometry and attributes?? com.esri.core.map.Feature vs com.esri.core.Geodatabase.GeodatabaseFeature ... View more

Thanks for the replies. They have definitely helped.  A few questions and thoughts... So I am interested in the Python option.  Are you saying that it is possible to access the IArcPadExchange through python, or at least run a fully custom checkout through python?  I don't quite follow. That is very annoying that they have removed the IArcPadExchange from Arc10.  I haven't really thought of using the ArcPad geoprocessing tools because they don't seem to offer the same flexability running a standard Check Out.  As you mentioned it doesn't put the script files in the .axf.  For a while I was using a work around by designating the script file path in the .apl's as some known path "\My Arcpad\Scripts\Mylayer.js"  This works fine on a mobile device but this path doesn't exist on a desktop. So I then had two different configurations, One for Mobile device and one for a Desktop device.  The only difference between the two was the script path in the .apl.  I guess it would be easy enough to use a file path that exists on both windows mobile devices and desktop devices but either way the extra maintenance of a "disconnected" script file is painful.  It seems like there should be a way to connect to an .axf file after is has been created and insert the script file into the "AXF_FILESTORE" table as binary.  This is the way that it normally handles it.  I am in the process of testing this.  I just recently figured out how to connect to an SQL database so connecting to an SQL Compact Database should do just as smooth, then convert the script file to binary and insert into the "AXF_FILESTORE" Table. ... View more

Thanks! The ADO.Net worked great.  It took me some time to figure out the connection string, but its working now. ... View more

This would be a bit of a work around but have you thought about opening the .axf in ArcPad studio and exporting the shape file of interest and then load the shape file data directly to the database.  You could then run ArcMap tools to fix the problem.  -Forrest ... View more

There is no out of box way for arcpad to handle this situation.  You will have to dive into code. ... View more

They way you instanciate a related table as an arcpad object is throught the CreateAppObject("DataSource") method.  Here is an example. JScript: var ds = Application.CreateAppObject("DataSource") ds.Open(Application.UserProperties("dbPath")) //Set User prop earlier as...Appliction.UserUserProperties("dbPath")=Map.Layers("MyLayer").DataSource.FilePath var strSQL = "SELECT * FROM [MY_TABLE]" var recs = ds.Execute(strSQL) if (recs.RecordCount >0){      recs.MoveFirst()      while (!recs.EOF){           Mylistbox.addItem(recs.Fields("NAME").Value)           recs.MoveNext()           }      } This would create a recordset object and loop through the entire recordset adding all the names to a listbox if you had a column called "NAME". ... View more

Not sure I fully understand what you need to have happened but here is what I am currently doing with what I think is a similar situation. Our crews use an automated checkout procedure that is written in VBA.  The user will get all the data that is available on their replicated database.  As for background data none is checked out.  If your background data is static then you can create it once and place on all devices.  The user will then have to add the .shp files to the map.  This will eliminate the need to check it out constantly. I am looking toward converting my automated checkout code in VBA to either .NET or python so that it will continue to be supported by later versions of Arc.  I am curious what your python automated checkout code looks like. ... View more

This is very helpful, Thank you. The method previously described is basically how I handle things currently but do not use the .ToArray() method. Rather I keep the records in a recordset and utilize the MoveNext() Method. I have heard that using an Array is quicker than cycling through a recordset object. However my intention was to skip this process entirely by allowing Arc to handle it.  This would eliminate seemingly redundant code since ArcPad already has a process for handling this.  Furthermore it would make custom applets much more dynamic. ... View more