Questions tagged as 'sqlite'

1
answer

Subquery - Group By - SQLite

Ok, I have two Queries, the first one I ask for the names of the clients and I order them alphabetically: SELECT Firstname, Lastname FROM customers ORDER BY Firstname In the second I request the total of purchases: Select Custom...
asked by 13.02.2018 / 05:14
2
answers

Error with array (java.lang.ArrayIndexOutOfBoundsException: length = 5; index = 5)

I have an array that has several elements, all this contained in a database, but when I want to delete it with a method (with split) it does not leave me and it throws me the error of the title, how do I solve it ?, and all this , how can I see...
asked by 19.12.2017 / 09:15
1
answer

Error: SQLiteException: no such column: comments (code 1) :, while compiling

I'm trying to access the database in local to get the list of all the plays and I get the error SQLiteException: no such column: comments (code 1) :, while compiling I've been using the debugger and the error jumps just at the moment you try...
asked by 15.11.2017 / 22:24
2
answers

How can I handle this sqlite error?

I have a class% co_of% parent: public class DB extends SQLiteOpenHelper { private static final int VERSION_BASEDATOS = 1; private static final String NOMBRE_BASEDATOS = "DB.db"; private Context context; public DataExpoAuto(Context context) {...
asked by 27.06.2017 / 22:26
2
answers

Error to populate listview with cursor and sqlite

I want to populate a listview with information from a sqllite table, but it gives me an error. This is the structure of the project In fragment clients I have the call to the cursor in the following way private class ClienteLoadTask...
asked by 21.04.2017 / 19:29
1
answer

My SQLite database is not generated

I am making a music player for android and I am developing it in android studio . I get to show and play the songs on my device, but when inserting the "paths" of those songs in the database, I can not even get this bbdd created. I know...
asked by 30.03.2017 / 13:02
1
answer

Cordova SQLite with Ionic app

I am developing an application in which I occupy the Cordova Sqlite plugin. I have a problem in the Ios platform when the device does not have internet, every time I enter the application it stops working, in the logs I receive absolutely not...
asked by 04.04.2017 / 16:30
2
answers

Why are the records shown null? [closed]

Good morning have colleagues, I would like to know if anyone has any idea why the records are shown null. My JSON has data which are the following. This is the script I'm using to perform the internal SQLite database public s...
asked by 15.03.2017 / 19:16
2
answers

Problem when displaying Data in ListView Android

To show the data from the database I use a do-while loop that runs through the whole table but when adding the data to the vector I do not know what happens that are not added well and in the listView only a group is shown and if I add an...
asked by 02.02.2017 / 15:38
0
answers

Help Android Studio database

I am doing an App of test questions, in which 30 questions should be left with their possible markable answers in the same layout. My doubts are when I have to create a database. I have created the res -> raw folder where I keep the questions an...
asked by 17.01.2017 / 13:39