Android Question MYSQL b4xtable code 1 SQLITE_ERROR[1]

sigster

Active Member
Licensed User
Longtime User
Hi

I am reading from MYSQL database
I can connect and from the LOG I get data from the database

But know I get this error
b4xtable_createtable (java line: 1232)
android.database.sqlite.SQLiteException: near ")": syntax error (code 1 SQLITE_ERROR[1]): , while compiling: CREATE TABLE data )

if I disable , Datagridview.SetData(Data) then it is fine so the error is here


B4X:
Public Sub Calldatabase As ResumableSub

    Dim Data As List
    Data.Initialize
    Wait For (CallSub(Starter,"Connect")) Complete (Success As Boolean)
   
    Dim sf As Object = Starter.mysql.ExecQueryAsync("mysql", "SELECT * FROM WORK", Null)
    Wait For (sf) mysql_QueryComplete (Success As Boolean, Crsr As JdbcResultSet)
   
    Do While Crsr.NextRow
        Dim row(2) As Object
        Dim idst As String = Crsr.GetString("ID")
        row(0) = idst
        Log(idst)
        Dim idst As String = Crsr.GetString("ID_CON")
        row(1) = idst
        Data.Add(row)
    Loop
    Crsr.Close
    Datagridview.SetData(Data)
End Sub
 

sigster

Active Member
Licensed User
Longtime User
Ok There is a simple reason for this I was finish to disabled AddColumn and did not see it :(
 
Upvote 0
Top