Hello everyone !
A sudden mistake appears in my code this morning without modifying anything !!!
Here is a code I use since days :
I'am loading a B4XTable. It worked fine for days, but this morning, The app renders the following error with this code:
The error:
android.database.sqlite.SQLiteException: near ")": syntax error (code 1 SQLITE_ERROR): , while compiling: CREATE TABLE data )
The code:
Looking at the forums, I have not found a correct answer for my case.
I'm asking what near ")" means regarding to my syntax.
Is it an error from my code but where or an error detected in the class code ?
Could the B4XTable be crashed ?
Thanks for the ones who comes here.
A sudden mistake appears in my code this morning without modifying anything !!!
Here is a code I use since days :
I'am loading a B4XTable. It worked fine for days, but this morning, The app renders the following error with this code:
The error:
android.database.sqlite.SQLiteException: near ")": syntax error (code 1 SQLITE_ERROR): , while compiling: CREATE TABLE data )
The code:
loading b4XTable:
Sub chargerLesValeursDansB4Xtable
Dim data As List
data.Initialize
Try
Dim rs As ResultSet = Starter.sql1.ExecQuery("SELECT id, date, fournisseur," & _
"ville, affectation,montant,numfacture,modepaiement,numcheque,comptepayeur," & _
"titulaire,sousaffectation,note,codebarres, An,Mois,Jour,amj" & _
" FROM tachats ORDER BY amj DESC")
Log("rs.RowCount = " & rs.RowCount)
Dim t As String
Do While rs.NextRow
Dim n As Int=0
Dim row(18) As Object
'-------------------
t =rs.GetString("amj")
row(n) = t
n=n+1
row(n) = rs.GetInt("id"):n=n+1
row(n) = rs.GetString("date"):n=n+1
row(n) = rs.GetString("fournisseur"):n=n+1
row(n) = rs.GetString("ville"):n=n+1
row(n) = rs.GetString("affectation"):n=n+1
row(n) = rs.Getdouble("montant"):n=n+1
row(n) = rs.GetString("numfacture"):n=n+1
row(n) = rs.GetString("modepaiement"):n=n+1
row(n) = rs.GetString("numcheque"):n=n+1
row(n) = rs.GetString("comptepayeur"):n=n+1
row(n) = rs.GetString("titulaire"):n=n+1
row(n) = rs.GetString("sousaffectation"):n=n+1
row(n) = rs.GetString("note"):n=n+1
row(n) = rs.GetString("codebarres"):n=n+1
t=rs.Getint("an")
row(n) = t
n=n+1
row(n) = rs.Getint("mois"):n=n+1
row(n) = rs.Getint("jour")':n=n+1
data.Add(row)
Loop
rs.Close
Wait For (B4XTable1.SetData(data)) Complete (Unused As Boolean)
B4XTable1.SetData(data)
Catch
Log("pas possib', erreur")
End TryLooking at the forums, I have not found a correct answer for my case.
I'm asking what near ")" means regarding to my syntax.
Is it an error from my code but where or an error detected in the class code ?
Could the B4XTable be crashed ?
Thanks for the ones who comes here.