Select to view content in your preferred language

AXF Update Query

586
1
06-19-2013 01:30 PM
matthewreyes
Emerging Contributor
Hello,
I placed an event script on my tree form "onload" that is:

sub SQLUpdate
        Dim myDataSource
set myDataSource=map.layers("tree").datasource
Dim sqry
sqry="update treeg set TRG_STAT_Cd=1 where REMOVED='False'"
        myDataSource.execute(sqry)
myDataSource.close()
end Sub

The script runs without error, but it does not update the values in the layer.  Any suggestions?

Much Appreciated,
Matthew
Tags (3)
0 Kudos
1 Reply
matthewreyes
Emerging Contributor
Any suggestions?
0 Kudos