Questions tagged as 'sqlite'

Tagged questions
1
answer

Error DataBase Locked Sqlite / Java

I have the following problem: in an insert that I am trying to perform, I do not know if it is an error in the database or something in the programming in java, however every time I try to perform an insert of the client table I get the error: p...
asked by 24.12.2016 / 18:24
1
answer

Offline database in Phonegap app

I'm creating an app with Phonegap and need to consume / manipulate information from an existing SQLite database inside my WWW directory but in 3 days searching for tutorials I just found ways to create the database on time and then insert...
asked by 07.11.2014 / 15:32
1
answer

android - Cache images and show listview

Good afternoon friends, is as follows: I'm going to use Volley to get webservice data, and so I write the list in my local DB with SQlite. In this webservice will come a JSON with items, each item has its data and an image. I need to save thi...
asked by 22.06.2016 / 21:15
2
answers

Database in does not reflect changes in the same activity

I'm trying to update the database in my application. Trying to simulate a possible production error intentionally I give DROP to a table, and then I make a SELECT in the same table and it works. When changing Activity the same pr...
asked by 16.12.2013 / 17:14
1
answer

Separate content from the row in the BufferedReader loop

I have txt files with approximately 5,000 items, and these do not have a default, for example: 10 20 30 40 50 60 70 80 90 100 I need to import this to SQLite , each value being 1 register. Example: ID | VALOR 1 | 10 2 |...
asked by 26.04.2018 / 21:26
1
answer

Two databases in an Android application

I have an Android application and it works with an internal database. Now I need this application to work with 2 internal databases. Is this possible on Android? Any examples that might help?     
asked by 01.07.2014 / 16:26
1
answer

Read values from a table in SQLite

I need help in the following situation: I need to get the values of a column in the bank and write these values into a variable, and then this variable will randomly generate one of those saved data. Below the class where I create the bank:...
asked by 13.06.2016 / 06:22
1
answer

Password validation saved in SQLite

Hello, I'm doing a project for college and I'm new to Android, I'm making an application that it's intended to check if the password is correct to finish the application, but I'm not able to validate the password, I do not need validate somethin...
asked by 16.11.2016 / 19:21
1
answer

ORM LITE problems in saving columns bytes

My user app can use the camera to take a photo and need to save it in the database. To save to the database I convert the image to an array of bytes, however I noticed a problem in this process when the camera resolution is high (4: 3 16 MB) doe...
asked by 16.09.2018 / 00:35
1
answer

How to create a crosstab view in SQLITE via Android?

I have the following tables: ┌──────────────┐ ┌──────────────┐ ┌─────────────────────────────┐ │ TABLE pessoa | | TABLE lente | | TABLE pessoa_lente | ├──────────────┤ ├──────────────┤ ├─────────────────────────────┤ │ _id,...
asked by 22.02.2014 / 06:41