Questions tagged as 'android-sqlite'

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
2
answers

Android: SQLiteDatabase can not resolve symbol

I'm trying to make a database for a game using libgdx, but there's no way it works for me. An error appears as soon as you start with the code: you do not find anything related to SQLite. The start of the code is: public class DBAndroid extend...
asked by 05.06.2018 / 18:48
1
answer

Create text file: error java.lang.IllegalArgumentException: contains a path separator "

I need to create a .txt file in a specific path that I created and write data that is in my BD inside that file, the way I found is OutputStreamWriter, but it sends me an error that says:    "java.lang.IllegalArgumentException: sample / examp...
asked by 15.10.2018 / 18:39
2
answers

Make a backup copy of a database to the sd card

I have this simple database and I want to backup the sd card, how can I do it? public class Usuario extends SQLiteOpenHelper { String sql ="CREATE TABLE Cliente (id INTEGER, nombre TEXT, apellido TEXT)"; public Usuario(Context contex...
asked by 28.06.2017 / 02:17
1
answer

How to interpret sqlite insert response

I am implementing sqlite in app, but the insert returns -1, as I interpret the messages. That's how it works public long IngCliente(SQLiteDatabase db, cliente cliente) { return db.insert( clienterEntry.TABLE_CLIENTE,...
asked by 21.04.2017 / 02:03
1
answer

Error generating SQLite Database android studio

I create a table with foreign keys and it generates error in the execution, I can not understand the error is the following ... 01-11 08:57:28.821 27100-27100/company.viral.organizadorjec E/AndroidRuntime: FATAL EXCEPTION: main...
asked by 11.01.2017 / 13:21
1
answer

Implement "onClickListener" in RecyclerView working with Cursor

A few days ago I asked a question asking for help and guidance on how to create a RecyclerView with a CursorAdapter to be able to create a list where% data RecyclerView were extracted from the internal DB (in SQLite) from the ap...
asked by 10.06.2016 / 16:13
1
answer

I can not get the cursor to read what the SQL statement returns- Android Studio

I am creating a calendar-type app and when I run the app and I give it the option to see events I get an error in the cursor: The error is as follows " Could not read row 0, col 1 from CursorWindow Make sure the Cursor is initialized correctly...
asked by 02.01.2019 / 17:56
2
answers

Data entry throws datatype mismatch (code 20)

The problem happens when you start the app with SQlite, you fall for the topic that says data that does not match if someone has any idea about this error would be of great help any contribution to solve it Helper public class ConexionHel...
asked by 12.11.2018 / 04:28
0
answers

Image processing with WEB REST C #

I am making a mobile application with Android Studio and I synchronize it through a WEB REST in C #, the problem is that when synchronizing the images between SQLite and SQL Server, it sends me an error in the data types in my Web Rest. I clarif...
asked by 29.10.2018 / 20:08