Questions tagged as 'sqlite'

Tagged questions
1
answer

Sqlite in Unity for Android

I am developing a .APK in Unity, where I have a BD in SQLite . When doing tests within the Unity environment everything works perfectly, but when exporting it to .APK and testing it on my phone, after executing 2 queries in a row...
asked by 31.08.2018 / 12:51
1
answer

Why this error: required java.lang.string found int (Android Studio)?

I have a table in sqlite with an integer field called Tipo , it happens that according to the type number certain options will be shown to the user, so I made a switch but it marks the error in the number of case of switch...
asked by 20.08.2018 / 19:09
1
answer

SQlite Detects me 0 as null

I have to insert a record at run time where one of the parameters is 0; using (SQLiteConnection conexion = new SQLiteConnection(conectionString)) { //Inserta Investigacion1 SQLiteCommand investigacion1 =...
asked by 01.03.2018 / 10:11
1
answer

Invalid index 0, size is 0 (Android)

Hi I try to fill an Arraylist in a Fragment with data from a Sqlite table (the table already has data) and it shows me the error of the title in the catch. Class HomeFragment public class InicioFragment extends Fragment { public Recyc...
asked by 04.09.2018 / 02:46
2
answers

Error SQLiteException: foreign key mismatch

I was doing a database, but after hours of review I could not reach a resolution to my problem, so I come to you in search of an answer. I wanted to make a query of a database, whose tables are the following: db=this.openOrCreateDatabas...
asked by 12.06.2017 / 10:25
1
answer

Because I can not save more than 4096 characters in a Delphi 10.1 string

I'm trying to build a string with multiple SQL queries to run it in an SQLite database, but it only allows me to store 4096 characters in the string, I've tried AnsiStrings but it's the same thing. I am using Delphi Berlin 10.1 This is...
asked by 14.04.2017 / 18:12
0
answers

What is the best way to encrypt a database (SQLite - Android)? [closed]

I imagine two possible ways of encrypting a database, encrypting the data by means of a class in charge of encrypting and decrypting or some mechanism that performs it automatically but I'm not sure what to use.     
asked by 20.10.2016 / 23:19
2
answers

Query C # a SQLITE

I have the following Database CREATE TABLE [Request] ( [IDRequest] INTEGER PRIMARY KEY NOT NULL, [RequestID] VARCHAR(10) NULL, [ReceivedDate] VARCHAR(20) NULL, [RequestStatus] VARCHAR(20) NULL, [ExpirationStatus] VARCHAR(15) NULL, [Respo...
asked by 04.08.2016 / 22:24
1
answer

RecyclerView creates a ghost record when deleting

I have a problem removing an item from my RecyclerView (which is linked to a database SQLite ). After successfully removing the data from both the database and the view, the animation is shown as deleted, but then a new element appears at the...
asked by 27.01.2017 / 17:48
1
answer

Is it OK to use a NOT NULL on a primary key in SQLite?

My question is, is it correct to define as NOT NULL in a primary call in a database SQLite for Android ?, example: ID INTEGER NOT NULL PRIMARY KEY     
asked by 30.08.2016 / 18:09