I have this code in my ArcPAD 8 sp 4 project....I moved it to ArcPad 10 and getting an error on the line: iCount = pDS.Execute(sSQL) Is the .Execute command still viable for ArcPAD 10? the code works fine in ArcPAd 8Thoughts?
Dim sSQL
sSQL = "INSERT INTO OUFALLS_HISTORICAL (INSPECT_BY, AXF_TIMESTAMP, AXF_STATUS) VALUES ('" & varcbo_User & "', getDate(), 1)"
' Get the project and open the Data Source
Dim strFileName2
strFileName2 = varAXFFileName_2
'++ open the selected AXF file
Dim pDS
Set pDS = OpenAXF(strFileName2)
If (pDS Is Nothing) Then
Console.Print "Open DataSource failed"
Exit Sub
End If
' Run the SQL Statement
Dim iCount
iCount = pDS.Execute(sSQL)
' Close the Dataset
pDS.Close()