Questions tagged as 'sqlite'

Tagged questions
1
answer

Sqlite Data Does Not Appear in RecyclerView

I'm trying to list data in a RecyclerView, but on the 3 lines nothing appears and I do not know what's wrong, so look at the image below: AdapterClient.javaimportandroid.support.v7.widget.RecyclerView;importandroid.content.Context;importandr...
asked by 08.01.2016 / 05:53
2
answers

Create table in SQLite with array

I am creating a Database in SQLIte and I have 2 tables, a LIST table and other PRODUCTS. The LIST table in addition to the ID numeric , NOME text , fields has a PRODUCT ARRAYLIST. The PRODUCTS table only has ID numeric , NOM...
asked by 11.10.2015 / 23:58
0
answers

Convert Bitmap to Mat

Hello, I'm trying to get BLOBS saved in a SQLite database and convert them to Bitmap. After that, I need to convert these Bitmaps to Mat for use with OpenCV. The problem is that when I open the camera (when these photos should be loaded), the ap...
asked by 28.10.2015 / 14:26
4
answers

Creating base date using StringBuilder

I'm creating my database with class sqliteOpenHelper , passing DB creation by String through StringBuilder . The problem is that you are only creating the first table, and then you do not create the next table, in which case I...
asked by 10.11.2015 / 23:27
2
answers

Error in getWritableDatabase ()

I'm trying to open the database to insert values in class CadSalario , but it's giving me error in dbHelper.getWritableDatabase(); and I looked at the net and I have to call a context , can someone help me? This is the file...
asked by 22.05.2015 / 03:29
1
answer

How to make a Seed.rb by looking for random SQLite data in Rails?

As I already have a register of Cities and states, you can see below, my question is as follows, how can I put inside the 10.times function in the lines of address_city and address_state a parameter to search for cities and random states? within...
asked by 08.06.2015 / 20:05
0
answers

SQLite and Android database

Hello, I'm making a small app and I need to fetch data from the database and display it on the screen. DatabaseHelper.java public class DatabaseHelper extends SQLiteOpenHelper { private static final String BANCO_DADOS = "Nomes"; pri...
asked by 10.02.2015 / 03:47
0
answers

Insert with Inner Join and various conditions in the where clause

What is the best way to do SELECT with INNER JOIN and with various conditions using SQLite Android? I thought I'd do it this way: SQLiteQueryBuilder _QB = new SQLiteQueryBuilder(); _QB.setTables("TABELA_1 INNER JOIN TABELA_2...
asked by 30.10.2014 / 14:43
0
answers

Prevent removal of an sqlite bank on Android

Can you prevent the sqlite database from being removed when you uninstall the application? I have an application that asks for a password to access, the password is written the first time the user starts the app (yes I have to do it this way,...
asked by 23.11.2014 / 19:06
0
answers

Show data from SQLite table

When I delete a row from the database, when I refresh again, it does not show in a table that I print the rest of the rows if it is deleted in the middle of the data. The problem is that I have a for that runs all the rows in the table...
asked by 21.11.2014 / 13:40