Questions tagged as 'sqlite'

1
answer

Apply in a JPanel the deleted one of a JButton from a BD SQLite

Very Good, It turns out that my program when starting recreates the JButtons based on a DB with a WHILE, and I have already programmed the part in which I can delete the person from a JTable, what happens is that in doing so the JPanel follows s...
asked by 29.08.2018 / 17:42
1
answer

How can I insert data from SQLite to my DataGridView? WindowsForms

I have the next code that is executed each time the ADD ITEM button is clicked and that creates a new row with the data entered in the textBox above in the DataGridView below. // AGREGA UN PRODUCTO private void btnAgregarItem_Cli...
asked by 18.06.2018 / 00:10
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

Copy a value from a Table by a Trigger to another table

I am creating a java app where the user will enter a value and then save said operation so that this value is recorded in a table. What I need is that this value by means of a trigger is copied into a table which does not auto-increment only a p...
asked by 03.04.2018 / 03:37
1
answer

Load Spinner with SQLite Android database

Hello, I need help to load a spinner from a database as easily as possible. I have a class where doing all sorts of methods would ideally be that from the activity call those methods and load the spinner. public ArrayList getAllClientes() {...
asked by 27.10.2017 / 20:23
2
answers

Check Sqlite column and modify the data

I have a Sqlite : public class SqliteDatabase extends SQLiteOpenHelper { private static final int DATABASE_VERSION = 1; private static final String DATABASE_NAME = "DB_NOTAS"; private static final String TABLE_NOTAS = "NOTAS...
asked by 29.06.2017 / 21:04
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

Error editing data from a Sqlite Database

I explain, I can add data to my database Sqlite but I can not edit it, I comment. In my RecordatoriosAdapter I have the following method: private void editTaskDialog(final Recordatorios recordatorios) { LayoutInflater infl...
asked by 20.06.2017 / 00:54
2
answers

Error in SQLite: "attempt to write to readonly database"

All the queries work well for me but when I try to do a insert in SQLite I get the following error:    attempt to write to readonly database     
asked by 04.07.2017 / 20:47
1
answer

How can I store a RadioButton in a database?

I'm doing a database on a survey, and this is a multiple choice, but if I want to store the multiple choice answers, if the course is a INTEGER , the name is TEXT , what can the RadioButton be? Thanks. I add this for someone to help...
asked by 06.03.2017 / 12:42