Auto populate values in related table - PLEASE HELP!

MatthewWilson1 — Sun, 14 Aug 2011 19:13:28 GMT

Hello,

I am having some trouble inserting values into a related table in ArcPad 10. Once an existing facility is selected from the map, I would like to auto populate the related table (DA_FORM) with values from the GIS feature attribute table. I am not a programmer by any means, so please excuse my ignorance here!

I can select the appropriate values from the GIS feature, but am having trouble executing the SQL statement. I get an error on the execute SQL line saying, "the column cannot contain null values. [,,,Column Name, Table Name,]" Here's what I have so far:

(onformload event)

Sub AutoPop

dim objSelLyr, objSelRS, StrFacilNo, StrStructName

set objSelLyr = Application.Map.SelectionLayer
set objSelRS = objSelLyr.Records

objSelRS.Bookmark = Map.SelectionBookmark

'Get values from structure_existing_area layer
StrFacilNo = objSelRS.Fields("facil_no").Value
StrStructName = objSelRS.Fields("structname").Value

msgbox ("Facility # is " & StrFacilNo & ": " & StrStructName)

Dim DS
Dim SQL
Dim Result

'Set data source
Set DS = objSelLyr.DataSource

'Define SQL statement to insert values into table DA_FORM
SQL = "INSERT INTO DA_FORM (facil_no, facil_type) VALUES ('" & StrFacilNo & "', '" & StrStructName & "')"

'Execute SQL command
Result = DS.Execute(SQL)

End Sub

topic Auto populate values in related table - PLEASE HELP! in ArcPad Questions

Auto populate values in related table - PLEASE HELP!