Questions tagged as 'sqlite'

Tagged questions
1
answer

How should I manage my Sqlite database on android when I have different modules and each module has a different database?

I am developing an application which was extended to several modules and I divided them into different projects but they all have to communicate with each other, I have the doubt of how to manage the database part to make only a database or make...
asked by 18.11.2016 / 16:54
1
answer

Cordova sqlite-storage does not work with iOS 10

I am developing an application for iOS and Android with Apache Cordova . I am using the plugin sqlite-storage to store data locally. The code I use is the one shown on this site: link The App has been tested on both Andr...
asked by 08.11.2016 / 23:29
1
answer

Return null in SQLite

I try to save the name of a subject along with other information, but for some reason the name of the subject does not save. I try to save in the following way: Nombre_Asig = Horario[i].NombAsig; Asig_Nsp = Nombre_Asig.replace(/\s+/g, ''); Asi...
asked by 20.05.2016 / 02:04
1
answer

Problem with CheckBox and SQLite in Android Studio

It turns out that I have this class in which I keep the information of, among other things, 4 Checkboxes in my SQLite Database, but it does not matter if the Checkboxes are selected or not, I always load "No" in my database. data. To better u...
asked by 19.11.2018 / 22:13
1
answer

Error in sqlite query with SELECT CASE

CREATE TEMP TABLE var(nombre VARCHAR(255),entero INT(5),texto VARCHAR(255)); CREATE TEMP TABLE param(nombre VARCHAR(255),entero INT(5),texto VARCHAR(255)); INSERT INTO param (nombre,texto) VALUES('criterio',''); INSERT INTO param (nombre,entero)...
asked by 17.07.2016 / 17:10
1
answer

Export table from BD to .txt file in Android Studio

I need to export a database to a .txt file delimited by commas, I have researched but I can not find the way, I need the files to be shown in this way:    Data, Data, Data   Data, Data, Data How can I do it?     
asked by 14.10.2018 / 23:46
2
answers

Problems with SQLite [closed]

Good afternoon, I just try to translate and know what the example codes say in order to better understand how everything works, and get stuck in this fregmentom, it is part of a code for a database with multi table in android studio , the code i...
asked by 03.12.2016 / 03:23
2
answers

I want to put, modify and retrieve comments in sqlite, to the database, to the tables and to the columns

For now I am only commenting on the table columns. To put comments at the time of creating it I am using this query: CREATE TABLE KBase ( n1tId INTEGER UNIQUE PRIMARY KEY AUTOINCREMENT NOT NULL /* ####### AutoNumerico */, a1tNomb...
asked by 20.06.2016 / 14:42
1
answer

Perform a Blackup from the database to the sd [duplicate]

How can I make a backup of the database to the sd card in android studio. I have the database made, but I do not know how to implement a backup and that is in the sd     
asked by 27.06.2017 / 23:11
1
answer

Save a database on the sd card

How can I save my database in the sd of my cell phone? Here I have it created: public class DB extends SQLiteOpenHelper{ String tabla ="CREATE TABLE Datos (Id INTEGER PRIMARY KEY AUTOINCREMENT, N text, C text, R1 INTEGER, R2 INTEGER, R3 INTEG...
asked by 10.03.2017 / 05:26