.Execute error

JayKappy — Tue, 10 Aug 2010 20:10:05 GMT

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 8

Thoughts?

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()

Re: .Execute error

JayKappy — Thu, 12 Aug 2010 12:03:56 GMT

error was fixed....I think it was a value in a domain or the spelling....
The code as is works fine....the error was in the SQL statement as I was using an older version of the project for testing in ArcPAd 10.

topic Re: .Execute error in ArcPad Questions

.Execute error

Re: .Execute error