topic Re: Recordset.Find method - Does this work in axf layers? in ArcPad Questions

Recordset.Find method - Does this work in axf layers?

KeithGanzenmuller — Wed, 03 Oct 2012 18:25:45 GMT

I have a point layer in an axf file, I have a reference to the recordset and I am simply trying to use FIND to locate a particular record. The script keeps throwing an "Object doesn't support this method" error.

Is this correct? Does an axf recordset not support Find?

Thanks,
Keith

Re: Recordset.Find method - Does this work in axf layers?

ThaiTruong — Wed, 03 Oct 2012 18:53:10 GMT

Yes, RS.Find doesn't work for AXF Feature Layers

Re: Recordset.Find method - Does this work in axf layers?

KeithGanzenmuller — Wed, 03 Oct 2012 19:00:48 GMT

Thanks. I could not find that written anywhere in the help system and there is no differentiation in the OMD for axf and non-axf feature layers. Very frustrating.

Re: Recordset.Find method - Does this work in axf layers?

ThaiTruong — Sun, 12 Dec 2021 04:45:14 GMT

Here is a workaround for you. I used Riverside.axf\Parcel from ArcPad Samples for this sample code.
The message box shows the address of APN = 225112008

Set objLayer = Application.Map.Layers("Parcel") 
Dim pDS
Set pDS = Application.Map.Layers("Parcel").DataSource
Dim pRS
Set pRS = pDS.Execute("SELECT * FROM PARCEL WHERE APN = 225112008")
If (pRS is Nothing) Then
 MsgBox("No Record Found!")
 Exit Sub
End If
pRS.MoveFirst
Do While Not pRS.EOF
 msgBox(pRS.Fields(3).Name & ": " & pRS.Fields(3).Value & vbnewline & pRS.Fields(5).Name & ": " & pRS.Fields(5).Value)
 pRS.MoveNext
Loop