Programmatically set AXF extent

IngridHogle

Is it possible to programmatically change the extent of a sync-enabled ArcPad AXF (the xmin, ymin, xmax and ymax values within the AXF_SYNC_GEOMETRY property) via a custom python script or via SQL within ArcPad Studio? If so, can anyone advise on how to do this?

StephenQuan1

Open the AXF in ArcPad Studio. Right click and select "Command..." then, the rest is SQL awesomeness.

For example, querying the sync properties can be done by:

<SPAN class="keyword token">SELECT</SPAN> <SPAN class="operator token">*</SPAN>
<SPAN class="keyword token">FROM</SPAN> AXF_PROPERTIES
<SPAN class="keyword token">WHERE</SPAN> NAME <SPAN class="operator token">=</SPAN> <SPAN class="string token">'AXF_SYNC_PROPERTIES'</SPAN><SPAN class="punctuation token">;</SPAN>
‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Syntax for changing it is:

<SPAN class="keyword token">UPDATE</SPAN> AXF_PROPERTIES
<SPAN class="keyword token">SET</SPAN> <SPAN class="keyword token">VALUE</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'...'</SPAN>
<SPAN class="keyword token">WHERE</SPAN> NAME <SPAN class="operator token">=</SPAN> <SPAN class="string token">'AXF_SYNC_PROPERTIES'</SPAN><SPAN class="punctuation token">;</SPAN>‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

If the property doesn't exist, syntax for creating it is:

<SPAN class="keyword token">INSERT</SPAN> <SPAN class="keyword token">INTO</SPAN> AXF_PROPERTIES <SPAN class="punctuation token">(</SPAN>NAME<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">VALUE</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">VALUES</SPAN> <SPAN class="punctuation token">(</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">'AXF_SYNC_PROPERTIES'</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="string token">'...'</SPAN>
<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

You can even execute the statement in an ArcPad applet with something like:

Map<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Layers</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>DataSource<SPAN class="punctuation token">.</SPAN>Execute&nbsp; sql
‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>