Android Question SQLite insert problem

[grafsoft]

Hi,

I must be doing something wrong, see the code below.

What I do not understand - I get no error message! Please help me find out how to analyze the problem.

Thank you

Peter

Sub saveittodb (i As Int)
   Dim n,s As String
   n=addslashes(chosencontact)
   
   DateTime.dateformat="yyyy-MM-dd"
   
   s = "insert into voices values ('" & DateTime.date(DateTime.Now) & " " & DateTime.Time(DateTime.Now) & "','" & n & "'," & i & ", ?)"
   
   Dim InputStream1 As InputStream
  InputStream1 = File.OpenInput(File.DirRootExternal, "temp.3gpp")
  Dim OutputStream1 As OutputStream
  OutputStream1.InitializeToBytesArray(1000)
  File.Copy2(InputStream1, OutputStream1)
  Dim Buffer() As Byte 'declares an empty array
  Buffer = OutputStream1.ToBytesArray
   
   
   SQL1.BeginTransaction
  Try
     SQL1.ExecNonQuery2(s, Array As Object(Buffer))
  Catch
     Log(LastException.Message)
  End Try
  SQL1.EndTransaction
   
End Sub

 

[grafsoft]

Sorry, found the solution: TransactionSuccessful
Butt there is apparently no way to delete a post.

 

[eps]

delete a post?

 

[grafsoft]

I found the solution myself, so I wanted to delete the post.

 

[mangojack]

delete what post ?

 

[grafsoft]

delete my own post, because I found the solution and need no help. But - no big problem.

 

[eps]

Ah understood now!! I'm sure Erel can remove for you if you wish.

 

[Erel]

Why delete this post? It can help someone else.