Programmatically set AXF extent

372
2
Jump to solution
10-16-2017 02:20 PM
IngridHogle
Occasional Contributor

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?

0 Kudos
1 Solution

Accepted Solutions
StephenQuan1
Esri Contributor

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

View solution in original post

2 Replies
StephenQuan1
Esri Contributor

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
Occasional Contributor

Works like magic! Thank you!