Questions tagged as 'sqlite'

Tagged questions
1
answer

Query is repeating results - SQLite

I am doing a query in my SQLite bd, but it is returning me some repeated results I can not find the error. cursor = db.Select(DataBaseHandler.TABLE_OS + " LEFT JOIN " + DataBaseHandler.TABLE_SITUACAO + " ON " + DataBaseHandler.TABLE_SITUACAO...
asked by 14.04.2017 / 18:47
1
answer

add information to the database

I wanted to know if it is possible to have a list in database, as in java List<> as in the image below, a comida table that may have one or more ingredientes . How can I do this in the database? For example, ad...
asked by 23.03.2017 / 23:39
0
answers

Sqlite only accesses the bank on a device

I created an application on Android that accesses the SqLite bank, the first application I created works normally! The application that works is version 7.1 of Android, but when I try to run the same code in 4.4, 5.1 or any other emulator to...
asked by 27.03.2017 / 19:08
0
answers

java.lang.NullPointerException error while trying to popular Spinner

Within OnCreate: spnMateriasID = (Spinner) findViewById(R.id.spnMateria); try{ atividadeModel = new AtividadeModel(this); atividadeModel.getWritableDatabase(); materiaModel = new MateriaModel(t...
asked by 14.03.2017 / 00:33
1
answer

Sqlite shared between android flavors

Hello, I'm trying to make an ad-free paid version of my app that is already published in the play store. I wanted it if a person bought the paid version she did not miss all the data already registered in the free version where I stored everythi...
asked by 21.03.2017 / 15:42
2
answers

Problems with reading the database [SQLite] [closed]

Day number 3. The app insists on "crashing" on startup and the frustration is strong at the moment. The problem, I believe, lies with the getFromDb () method, more specifically on the line where I call the db.getReadableDatabase () since the app...
asked by 13.03.2017 / 03:52
0
answers

Query Like in SQLite Android

I'm trying to make a query like in sqlite. Cursor cursor = database.rawQuery("SELECT nome FROM Armas WHERE nome LIKE ?", new String[]{name}); This String I go like this: data = getIntent().getStringExtra("name"); final List<St...
asked by 23.02.2017 / 18:01
1
answer

Parallelism with Angular 2

I need to insert 30,000 records in the device (in SQLite) through a file. But at the time of insertion, the application hangs. So I thought of creating an asynchronous service, but I do not know how to do this using Angular 2. Code: this....
asked by 24.02.2017 / 15:39
0
answers

Filter Data for Database

Good afternoon, I have a problem that I hope someone can help me with. I needed to pass about 700 entries to a database (in this case SQLite Studio) but I can not figure out a way to filter those 700 entries without being manually. Here is an...
asked by 17.02.2017 / 15:59
2
answers

Show SQLITE data between dates - Android Studio (I think be between)

Well, I want you to choose the data to display between the dates he chooses. I tried everything but I still could not. In other words, I want to filter between dates, but the user has to choose them. I already managed with an SQL command, but...
asked by 03.01.2017 / 18:15