Questions tagged as 'sqlite'

Tagged questions
0
answers

I have an error in the AdminSQLiteOpenHelper and in the getWritableDatabase

// this is from the bd package com.example.manuu.basededatos3; import android.content.ContentValues; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.support.v7.app.AppCompatActivity; import androi...
asked by 17.05.2018 / 05:21
0
answers

Send fix from android to codeigniter

I currently send the information one by one, going through the bdd sqlite in the following way: do { final Map<String, String> parameters = new HashMap<String, String>(); parameters.put("idse...
asked by 07.05.2018 / 16:29
1
answer

Pass data between Activtiys using the database (Sqlite)?

I have a question about how to pass information between activitys using the database, since I have seen many tutorials on how to do it, but they always do it with a typed key and I use a autoincrementable and I do not know how to use it to pass...
asked by 05.05.2018 / 22:56
0
answers

Spring batch: [SQLITE_BUSY] The database file is locked (database is locked)

I'm doing a Batch that reads SQLite data and transforms it into CSV But every time I run the program it shows the same exception  "[SQLITE_BUSY] The database file is locked (database is locked)" The method that reads the data: @Bean Item...
asked by 17.04.2018 / 20:44
0
answers

Store DataPicker in SQLite [xamarin]

I am in Xamarin.Forms, I can not store the date of a DataPicker in the database. This is the class of the database: public DateTime Fecha { get; set; } public string FechaModificada { get {...
asked by 18.04.2018 / 15:05
0
answers

Error in PHP, constant T_PAAMAYIM_NEKUDOTAYIM

PHP Code - SQLITE <?php include 'connection.php'; // base de datos donde tomar los datos $db_from = new dbProd(); // base de datos para insertar datos de la otra base de datoss $db_to = new dbEncuestas(); // Con los datos o no // $data =...
asked by 11.04.2018 / 19:54
0
answers

They could tell me that I have bad. my method runs half

This is the method and only runs until the creation of myProducts the cursor and the rest does not. someone could tell me that I have bad thank you very much. public List<Product> getProducts() throws SQLException { String[] column...
asked by 26.03.2018 / 20:30
0
answers

SQLite sending parameters

I am starting to work with Sqlite and I wanted to ask if there is any way to create a stored procedure that stores values, sent from the front end, in variables to work with queries? as in common Sql for example I have: @nombre varchar(50),...
asked by 24.03.2018 / 06:09
0
answers

How to decrypt a sqlite3 database?

Where I work there is an application that allows you to generate some spreadsheets with private data of the institution and some members of it based on a configuration that is extracted from a database in sqlite. The program to generate the s...
asked by 21.03.2018 / 13:08
0
answers

In sqlite, A select that searches between schedule ranges

The problem is that I have to get ids that identify a specific date between a specific time, I've been trying for a few hours but I do not get it, The secret is in the WHERE I've obviously made many unsuccessful attempts . Here the tables PR...
asked by 08.03.2018 / 13:31