Questions tagged as 'sqlite'

Tagged questions
2
answers

Which database is ideal for my scenario?

I am developing a commercial automation system (C # and Windows Forms) that can be installed on one or more machines on the same local network. I've also done the mobile part of the system, where you can place requests through any device th...
asked by 31.05.2016 / 06:11
2
answers

Database graph does not appear python matplotlib

The outline of the graph appears, but empty, with no data. import sqlite3 import matplotlib.pyplot as plt import matplotlib.dates as mdates connection = sqlite3.connect('escola.db') c = connection.cursor() sql= "SELECT DATE_EXTRACTION, NOT...
asked by 05.03.2017 / 22:08
1
answer

Sqlite relationship between tables

About relationship between tables: I tried to run the following code and SQLite returns me the following error:    table "Games" has more than one primary key -- ----------------------------------------------------- -- Table 'times' --...
asked by 18.11.2014 / 04:48
1
answer

How to solve SQLite auto increment gap?

I have a code that deletes a whole row of a database , but there is a problem because I get a hole getting an ID with no data (which I deleted) by this being autoincrement , does not delete the ID value. How do I solve the problem?    ...
asked by 19.07.2017 / 00:08
1
answer

column 'MyColumn' does not exist - Using SQLite Android

Hello, I'm trying to retrieve the data stored in my database, but when I run a function to return the value of one of the columns created in the SQLite database in the phone memory, it displays the following error: column 'quantidade' does not...
asked by 09.04.2018 / 03:50
1
answer

SELECT in SQLite - Android

I'm new to Android development, I'm using SQLite as a database. I need to do a SELECT, and return the values of three columns in my table . Then I need to set the attributes of my object with the return values of this SELECT . I have an obj...
asked by 13.11.2017 / 22:13
2
answers

Error: android.database.sqlite.SQLiteException: no such column:

I added a column in the Users table, invited is an integer. I need to do a select in the table by filtering this field, and I get the following error: android.database.sqlite.SQLiteException: no such column: invited (code 1):, while compiling...
asked by 28.11.2016 / 21:39
2
answers

Synchronizing data on android

So, I'm in a project that needs to save a large mass of data coming from an api json in android's SQLite, something like 20,000 records, so you can work offline with no problems. Only the synchronization of this mass of data is taking a long...
asked by 11.10.2016 / 17:07
1
answer

Insert two commands (INSERT and UPDATE) into the same statement in SQLite via R Language

Hello, people I have a problem with how to insert two commands (INSERT and UPDATE) into the same SQLite statement via the R language. I do not know if this is impossible because of SQLite or the DBI package of R. Here is an example of w...
asked by 26.07.2018 / 20:20
1
answer

How do I install SQLite on Android?

How do I install SQLite on Android? I downloaded the program and it has no installer in it. What do I do? I downloaded it through the PC, not the smartphone.     
asked by 04.12.2017 / 16:24