Hi!
How are you all?
I'm trying to use some of the codes from the sqlexample from the UserGuide.
I don't want to show rows ids, then I changed the first column to show date (ColumnName(0) = "data").
When I select some row and hit the Edit button I'm getting an error:
"android.database.sqlite.SQLiteException: near "10": syntax error (code 1): , while compiling: SELECT * FROM registros WHERE data = 08/08/2017 10:23:43"
If I use table ID, it works fine.
Can someone pls point me what I need to do to use date instead of ID?
Another thing: Is there some document showing how works the table from the SQLExample? It would be great for me because I am very new to B4A. That table is amazing!
Thank you so much, dear friends!
How are you all?
I'm trying to use some of the codes from the sqlexample from the UserGuide.
I don't want to show rows ids, then I changed the first column to show date (ColumnName(0) = "data").
When I select some row and hit the Edit button I'm getting an error:
"android.database.sqlite.SQLiteException: near "10": syntax error (code 1): , while compiling: SELECT * FROM registros WHERE data = 08/08/2017 10:23:43"
If I use table ID, it works fine.
Can someone pls point me what I need to do to use date instead of ID?
Another thing: Is there some document showing how works the table from the SQLExample? It would be great for me because I am very new to B4A. That table is amazing!
Thank you so much, dear friends!