Select to view content in your preferred language

Customized input for child table

1258
2
04-13-2010 10:29 AM
DonaldDukleth
New Contributor
I am new to ArcPad and ArcStudio 8.0.  I have customized an input form for my feature file with little problem.  I would like to also customize/control the input for my related table(child), but cannot seem to access it in Studio.  I see that the demo data with 8.0 has done it, but must be missing some step which appears to not be documented easily enough for me to locate it.

Any help would be appreciated.

Don
Tags (3)
0 Kudos
2 Replies
EricHajek
Deactivated User
Unfortunately, the only way to deal with related tables is to use SQL queries. The Riverside example you refer to has some good example code to look at, but you have to open the AXF and check out the VBS files inside to see the parts that deal with tables.

Basically, you have to open a Datasource and feed it an SQL command. The Riverside example seems pretty complex taken as a whole, but I'd recommend just trying to pick out the bits of code necessary to perform a query (in Inspections_onSetActive in the example), add a row to a related table (InsertInspection), modify a row (UpdateInspection), and load values from a domain table (FillCodedValues). If you're modifying / adding anything to your tables or feature classes (you can manipulate the feature classes using SQL in the same way) make sure you use the AXF_Status / AXF_Timestamp fields to flag the records as being updated, since that's how the check-in process knows to update them.

When trying to save values to a related table I'd recommend doing it during "onunload" of the form, since the feature the table is related to needs to be added before you add a row.

Hope this helps!
0 Kudos
DonaldDukleth
New Contributor
Thank you for your assitance in pointing my direction of attack!
0 Kudos