Creating/Editing 'RecordSet' VBScript problem

ChristopherBowering — Thu, 01 Mar 2012 18:18:51 GMT

I am currently in the process of updating an ArcPad Application for the purpose of outfall/culvert management.

In the .APL Edit Form, there is a tab with multiple buttons which call upon an Applet (.APA) inspection form in one way or another. When I click the button for 'Add New Outfall Inspection Report', or the button to edit a current inspection report, I receive an error pertaining to the last line in the following code section:

' Create a record set and open the inspection history data as a recordset
Set pRecordSet = Application.CreateAppObject("RecordSet")
sInspectionHistoryFilePath = Application.UserProperties("InspectionHistoryFilePath")
Call pRecordSet.Open(sInspectionHistoryFilePath, 2) '2 = read/write

*The 'sInspectionHistoryFilePath' component in the last line is replaced, in the VBScript, by the actual path to the external .dbf table where the inspection data is stored. Within the .APL, there is an almost identical set of code (to the above) which does not produce an error.

It is probably hard to see what I'm describing through a mere snippit of code, but essentially I am unable to call up the Applet inspection form through the .APL as desired.

topic Creating/Editing 'RecordSet' VBScript problem in ArcPad Questions

Creating/Editing 'RecordSet' VBScript problem