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 · Accepted solution]

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
‍‍‍‍‍

[IngridHogle]

Works like magic! Thank you!