Questions tagged as 'sqlite'

1
answer

Error "no such table: tablename (code 1):, while compiling: Query", code: 0

I am trying to consult information that I insert in a table, which I created previously. The error is as follows: Object {message: "no such table: HorarioP (code 1): , while compiling: SELECT * FROM HorarioP", code: 0} The code where I cons...
asked by 16.05.2016 / 05:33
1
answer

Error loading image path (Sqlite)

I select an image from the gallery and I save the path in Sqlite and up there everything is fine, the problem comes when trying to load the image, it shows ImageView empty and in Logcat I receive twice:    Unable to decod...
asked by 01.07.2017 / 15:57
1
answer

Problem when inserting data into a database

I have some data that I want to insert in my BD, but the problem is that they are not inserted. Table creation in BD: public class DB extends SQLiteOpenHelper{ String tabla ="CREATE TABLE Datos (Id INTEGER PRIMARY KEY AUTOINCREMENT...
asked by 08.03.2017 / 23:19
1
answer

empty the string fields in the sqlite database [closed]

Good afternoon I have a problem when saving data of type string in the database and it is that it does not keep them that I can do thanks, it registers empty.     
asked by 10.06.2016 / 00:46
2
answers

Unable to load DLL 'SQLite.Interop.DLL'

This is the error that appears on some computers when I run my application, I have the libraries SQLite.Interop.dll and System.Data.SQLite.dll in the same directory of the executable. I also tried copying the two libraries...
asked by 12.09.2016 / 20:24
2
answers

Why is the result added twice when using SUM () with JOIN?

Hi, I have the following question and it is that the sum is doubled and I do not know why, it adds twice the result when using SUM() with JOIN in Mysql. Each result comes out double in INVERSION_VALOR comes out 492 instead of 246,...
asked by 05.11.2018 / 23:15
1
answer

SQLite and listView does not list

It shows me the following: And the logCAT: The app consists of showing the business of my town in a listView. The Business class I have the getter and setters methods. I have the class: public class NegociosDBOpenHelper...
asked by 15.10.2018 / 16:26
1
answer

Save images in SQLite? [closed]

I wanted to know how to save images (business photos) in the SQLite database. I'm with an app that shows all the businesses in the city where I live. This is the code that creates the table: public static final String TABLE_CREATE =...
asked by 17.10.2018 / 18:12
1
answer

Error with sqlite database on android

I have this code to manage an sqlite database on android: public class ConfiguracionSQLite extends SQLiteOpenHelper { public ConfiguracionSQLite(Context context) { super(context, "configuracion", null, 1); } @Override...
asked by 22.11.2017 / 11:07
1
answer

Error in database, Android Studio

I have a method in the DBHelper class (which is where the database is created), and what I want to do in this method is read data from one table and add it to another table but it gives me the following error: 01-20 23:51:07.697 5880-5888/? W/...
asked by 20.01.2017 / 23:58