Questions tagged as 'sqlite'

Tagged questions
1
answer

Insert SQL values in Android Spinner

I select a table and it returns a complete row. I put that row into an object. My intention is to collect the value and inflate a spinner so that if it finds for example in the select: "8" I generate a spinner with values from 1 to 8. I have fou...
asked by 04.06.2017 / 19:00
1
answer

SQL - Update multiple columns in several rows of the same table

I work with NodeJS and SQLite , seeing my use of the I / O of the SSD disks on my Azure server (which were extremely high), I would like to make a serious optimization. My table has the following format: ID points...
asked by 18.04.2017 / 20:17
1
answer

How to convert a data to "1" or "0" and be registered in a datagridcheckbox?

I am new to programming and I am learning by practicing. The first thing I did was the sqlite connection with c # . Then store the data ("generated" and "not generated") of the fields "cpComprobante" and "cpEstado" in a table. I need help on...
asked by 17.04.2017 / 19:30
1
answer

Create database using splash screen ANDROID

I have a splash screen in which I try to verify the existence of a database and create it in the case of not existing but I do not know how to call the methods of the class AppSQLiteHelper.java as I could do it? In addition, my intention is that...
asked by 22.04.2017 / 23:38
1
answer

Set progress from Splash-Screen checks

How can I replace the CountDownTimer that is responsible for simulating the progress of the progress bar to this form: My idea is to check if there are four tables in the database that the application must have created and also verify the exi...
asked by 02.05.2017 / 10:44
1
answer

Problems with DATABASE and JavaScript

The database works perfectly for me, it keeps the information I want, the problem comes when I add a new member (DATE) to the listView, I close the application when I start, LOG: 12-29 19:17:07.187 24552-24552/prueba.nuevointento E/SQLiteLog:...
asked by 29.12.2016 / 15:50
1
answer

this.lastID returns null when I make a bind in the callback of a db.run () - NodeJS

I'm trying to insert a data series into a database SQLite3 from NodeJS by means of a loop with INSERT , however, I need to have the variable I use for the callback function perform the for loop. It occurred to m...
asked by 29.11.2016 / 13:48
1
answer

Erorr when inserting a data. sqlite.SQLiteConstraintException: UNIQUE constraint failed: tags.name

I have the following table which contains tag names (tags) and an identifier for each: public static final String TABLE_CREATE_TAGS = "CREATE TABLE " + TABLE_TAGS + " (" + COLUMN_TAG_ID + " INTEGER PRIMARY KEY AUTOINCRE...
asked by 02.02.2017 / 13:33
1
answer

How to make a foreign key in SQlite.net from c #

Hello friends I am working on a project of c # I am new to this and I can not find the way to declare a foreigner from a class with c # code I clarify that I am using the MVC model but I give you one of my classes class producto { [SQLite...
asked by 05.04.2016 / 01:16
0
answers

Ask for insertion or update query in SQLite Android

In my application I have defined a database in which I will store numbers from 1 to 99 as they go out, if they leave more than once it will be stored how many times each one has left. The problem comes to me when formulating the query, I need th...
asked by 29.12.2018 / 19:38