.Execute error

[JayKappy]

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

[JayKappy]

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.