Questions tagged as 'sqlite'

1
answer

ERROR: java.lang.NullPointerException: Attempt to invoke virtual method 'android.database.sqlite.SQLiteDatabase

I'm having a problem with a class I've done in Android Studio that extends from SQLiteOpenHelper . The problem is this: I have created a class that extends from SQLiteOpenHelper that handles a table from a database. I have already c...
asked by 05.07.2018 / 20:27
1
answer

SQLite does not work

I'm trying to use sqlite, but it does not work for me. I'm just making the structure this is the code of my class conexión() : class conexion { String url = "C:\Users\Juan\Documents\NetBeansProjects\JavaApplication4\doc_sal.db";...
asked by 25.05.2018 / 15:34
1
answer

Select and Update in SQLite with Android

I try to save some data in SQLite database and then show it in an activity but for some reason I do something wrong. "BD" activity: public class BD extends SQLiteOpenHelper { String sqlCreate = "CREATE TABLE jugador (codigo INTEGER PRI...
asked by 21.04.2018 / 09:10
1
answer

Can you recycle an activity to use it in various activities in Android Studio?

I'm doing a project of an app that will have a button to make a new record, the app has as main activity the listing of data in listview by clicking on it the previous activity appears but to update. SqlLite     
asked by 25.03.2018 / 03:15
2
answers

Starting with SQLite

I work with NodeJS , for a while, I've been working with JSON files to store information from many users, but now I'm facing a problem, the corruption of the data (the file is being rewritten almost constantly), so I want to move all functi...
asked by 03.01.2017 / 21:15
1
answer

Insert data in sqlite cordova in related tables by foreign keys

I am trying to insert information into a database on a mobile device using a cordova plugin to make use of the sqlite APIs, but I have not been able to do so. I am developing my application using the Ionic development framework. The code I...
asked by 23.12.2016 / 01:46
1
answer

Save image in MySQL and read it in Android

Well, I have the following problem: I have a web application with which I want to be able to keep records of 2 tables, which must contain images. I want to save those records (with everything and images) in a MySQL server so that later I can...
asked by 18.08.2016 / 02:10
1
answer

android ListView OnItemClickListener sqlite

I have created a query using a ListView from a local database, I do not need to show all the information in the registry, only the basics, since I have also created an OnitemClickListener so that when you press a data of the existing ones in the...
asked by 01.12.2018 / 03:37
1
answer

Problem with SQLite query (Unanticipated Result)

Good I want to make a delete using SQLite and I would like the query not to run if the field of the where did not exist, is this possible? Then I leave an example of my query: delete from SANCION_DETALLE where SANCION_DETALLE.SANCION = 47...
asked by 07.11.2018 / 20:36
1
answer

QUERY does not filter result correctly

I have the following query: SELECT pe.id_person , pa.id_person_patient , * FROM patient as pa INNER JOIN person as pe on ( pa.id_person_patient = pe.id_person ) WHERE pe.elimination_date is null OR pe.elimination_date = 0 AND pe.name =...
asked by 31.07.2016 / 19:15