topic Re: Programmatically set AXF extent in ArcPad Questions

Programmatically set AXF extent

IngridHogle — Mon, 16 Oct 2017 21:20:05 GMT

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?

Re: Programmatically set AXF extent

StephenQuan1 — Sat, 11 Dec 2021 13:43:39 GMT

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:

SELECT *
FROM AXF_PROPERTIES
WHERE NAME = 'AXF_SYNC_PROPERTIES';
‍‍‍‍‍‍‍

Syntax for changing it is:

UPDATE AXF_PROPERTIES
SET VALUE = '...'
WHERE NAME = 'AXF_SYNC_PROPERTIES';‍‍‍‍‍‍

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

INSERT INTO AXF_PROPERTIES (NAME, VALUE)
VALUES (
    'AXF_SYNC_PROPERTIES',
    '...'
);‍‍‍‍‍‍‍‍

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

Map.Layers(1).DataSource.Execute  sql
‍‍‍‍‍

Re: Programmatically set AXF extent

IngridHogle — Mon, 16 Oct 2017 22:12:03 GMT

Works like magic! Thank you!