Most voted "sqlite3" questions
Sqlite is a C-language library that implements a built-in SQL database. Programs that use the Sqlite library can have access to SQL database without running a separate DBMS process.
Learn more…142 questions
Sort by count of
-
1
votes1
answer373
viewsWorking with high quality images in sqlite3
In my application I make the selection of an image from the gallery, then I save it in the bank, but if the image has a high quality the app does not save, besides not saving it to work, has some…
-
1
votes2
answers1288
viewsHow to create 1:N relationship tables?
I’ve studied databases and understand how to diagram this type of relation, but now that I’m trying to implement this database using sqlite3 and python I’ve seen some problems. I have the following…
-
1
votes0
answers16
viewsHow to export sqlite and python exceptions log using Import Error
I am using Python and giving import of sqlite3 library and sqlite3 giving import in Error for exception handling! import sqlite3 from sqlite3 import Error def errorlog(erro): errlog =…
-
1
votes1
answer347
viewsReset variable
I am doing a search on the data anchor SQLITE3 inside my program and it returns values inside my variable, however when I make a condition to be executed for when the value is filled it returns…
-
1
votes2
answers1978
viewsHow to count the number of "Rows" in a python table
For example, I have a database called 123, in this database is the players table, which is where the players' accounts are. I want to count how many accounts there are in the database. Finally,…
-
1
votes0
answers65
viewsInserting bank value in Expandablelistview via hasmap
I’m having trouble inserting values in Expandablelistview from Android Sqlite database. In my app, I have a main table called DISCIPLINES and another table that has foreign key reference to this…
-
1
votes2
answers941
viewshelp with storing value of a local variable in python
Hello, well, I am writing an application using SQLITE and Python, everything was going well until I had a problem that I am not able to solve, it happens that I have a db of the fipe, so I need to…
-
1
votes0
answers1062
viewsError: "sqlite3.Operationalerror: no such table"
I’m making the following mistake: sqlite3.Operationalerror: no such table: product I already checked in my database, the product table is there Code: from tkinter import * from tkinter import ttk…
-
1
votes0
answers720
viewsHow do I check a login with sqlite3 + Python3?
from tkinter import * from tkinter import messagebox from random import randint import os import sqlite3 from tkinter import ttk con = sqlite3.connect('BancoDeDadosCadastro.db') cur = con.cursor()…
-
1
votes1
answer469
viewsNo such Column Android Sqlite
I need to accomplish the following select on Sqlite on Android SELECT p.codigo, p.nome, p.preco_padrao, (coalesce((select sum(i.qtd) qtd from tbl_item_compra i inner join tbl_compra c on (c.codigo =…
-
1
votes1
answer75
viewsReturn name instead of foreign key ID
I’m developing a Python system and wanted to return data from the specific database, only instead of the foreign key id I wanted to return the name of that person. The creation of tables:…
-
1
votes0
answers42
viewsSql - How to make a name or surname unique
Guys, the following is a table called sqlite, and I want the following I don’t want data to repeat, but if someone with a name and surname is registered, I want a person with the same name to be…
-
1
votes1
answer587
viewsRelationship Manytoone / Onetomany Typeorm does not save foreign key
Hello, I am developing an Node API using Typeorm and Sqlite3, but when using the Manytoone/Onetomany relationship, it does not save the foreign key. The scenario is as follows: I have a user who can…
-
1
votes1
answer99
viewsWhere in a select on a system using a many relationship type for many
I’m making a basic system that has a table of projects, one of tags and a pivot table, project_tag. Each project has a id, title and a tag. The table of tags has a id and a title . The table…
-
0
votes1
answer320
viewsSaving image data from json/web-service to sqlite on iphone
Hi! I wonder if Voce can help me, I’m trying to save an image in a sqlite bank, on iphone. But I’m not getting it. Briefly explaining how it works... The app connects to the server and receives the…
-
0
votes1
answer355
viewsHow to generate sequential numbers automatically with current year in Rails?
I need that when a new product is created it generates a number ex: 0001/2015 numero/ano_in effect and when it changes year back to zero. I made a helper just to format the number in the views, but…
-
0
votes1
answer646
viewsHow to convert a "Sqlite3 Object cursor" to a list (Python)
In a cell of a table in my database I have a list of pairs. I have a module in Python that I want you to fetch that list from the database and read it as a list. I tried to run this: interpretation…
-
0
votes2
answers9169
viewsError in such table. Sqlite
You’re making this mistake, I wonder if my DAO is right. Error: 08-06 14:19:53.304: E/SQLiteLog(16893): (1) no such table: proposta 08-06 14:19:53.334: E/SQLiteDatabase(16893): Error inserting…
-
0
votes1
answer657
viewsimport image from gallery - android
Eai personal, I need help with my application, I have q select an image from the gallery, make it appear in an imageView and save it in the database(sqlite), so q the person can exit the application…
-
0
votes1
answer784
viewsIs there any way to change a column from an existing table to "auto increment"?
I created a table in Sqlite3, but forgot to add AUTO INCREMENT in the column id. I tried to use ALTER TABLE to solve the problem, but I haven’t been able to. In SQLITE, it is allowed to set a column…
-
0
votes0
answers246
viewsProblems with Sqliteplugin Cordova/Phonegap
I am trying to create a connection to an Sqlite database created within my application and returns the following error. SQLitePlugin.executeSql[Batch](): Error=no such table: fornecedor_motorista…
-
0
votes0
answers498
viewsError entering registration: "No such table" - can anyone help me?
I am developing the registration for my application, but I have an error at the time of registering (insert function), an error that I do not know how to solve, it is in the image: Registration…
-
0
votes1
answer1720
viewsRead data from an Sqlite 3 database in Python
I’m starting in Python and database and I have three questions! For example, inside my database I have a "name" column. Just to illustrate, say I want to take the contents of the "name" column…
-
0
votes2
answers222
viewsFormat year on Sqlite
I need to format a timestamp in the following format: DDMMYYHHMMSS I got it using the strftime, example: select strftime("%d%m%Y%H%M%S", current_timestamp) from stream; But this way it shows 4…
-
0
votes0
answers55
views -
0
votes1
answer152
viewsHow can I create a dynamic database in Pyhton
Could someone help me on how to create a dynamic database, where I can add and remove items? In Python, if possible with Sqlite
-
0
votes2
answers443
viewsHow do I take data from an Entry and add it to the Database (sqlite3)
from tkinter import * jan = Tk() jan.title("Dados") jan.geometry("200x200+250+100") label = Label(jan, text="Nome:") label.grid(row=0, column=0) nome = Entry(jan, width=25) nome.grid(row=0,column=1)…
-
0
votes1
answer136
viewserror in the path to bank connection
I’m trying to add this path to the connection to the bank, and it gives me this error: File "C:/Users/gabri/PycharmProjects/allbd_s/conc.py", line 4 path='C:\Usuario\gabri\SQLite\conx' ^…
-
0
votes0
answers105
viewsSqlite3 with Dev-C++
I am trying to make a connection test with Dev-C++ and Sqlite3 but am having the following error: [Linker error] undefined reference to `sqlite3_open' I’ve already added: #include <sqlite3.h>…
-
0
votes0
answers22
viewsSearching Sqlite database data with php
I’m trying to get the name of my Session, and search the database for the data of those who have this name, but echo returns absolutely nothing. $nome = $_SESSION["Aluno"]; $results =…
-
0
votes1
answer147
viewsPopulated sqlite when install apk
When I compile the app directly on mobile Sqlite comes empty (exactly as is the file in the path specified for DB) but when I use . apk generated in the same compilation he populates the DB…
-
0
votes1
answer546
viewsSQLITE query returning value outside of query rule
I made a program, in python language, that creates a database SQLITE which stores information about a number of closet doors. The information stored are: id (port identification), size (PQ = small,…
-
0
votes1
answer59
viewsUpdate Sqlite with Edittext Android
Good morning gentlemen, I’m trying to update my Sqlite database through my Edittext but it shows error, someone could tell me what I’m missing ? public void insererazaosocial (SQLiteDatabase db){…
-
0
votes1
answer71
viewsMigrations are pending
I’m new to Rails and I’m also learning how to use databases. I’m trying to create a blog that currently has a table that already contains some data. What happens is that I was using the notebook to…
-
0
votes1
answer67
viewsHow to return the data registered in the database using Sqlite3
Good evening guys, okay I’m new here, and I have the following problem, I’m using knexJS with Sqlite3, I was able to do the Insert and is registering the data normally in the database, but when I…
-
0
votes1
answer23
viewsHow do I make it appear in the same folder as the file that creates it?
I create this database in python3 but it appears in a previous folder import sqlite3 nome_banco = 'banco_escola.db' banco = sqlite3.connect(nome_banco)
-
0
votes0
answers35
viewsNPM INSTALL SQLITE3 (Python) error
Good night, you guys! I’ve exhausted my attempts. I installed python 3.9 added in the environment variables, uninstalled the project’s node_modules and package.json installed node_modules again and…
-
0
votes2
answers1720
viewsPHP Fatal error: Uncaught Error: Class 'Sqlite3' not found in /var/www/html/
I have the code below supposedly simple. The intuition is to create a table include values and soon after showing the information, but in the log apache is showing the following: [:error] [pid…
-
0
votes1
answer12
viewsHow to convert a string to number in SQLITE 3 ? Example: How to convert 2020/2 to 2020?
How to convert a string to number in SQLITE 3 ? Example: How to convert 2020/2 in 2020 so that when using the condition WHERE periodo < 2014 will return only periods shorter than 2014?
sqlite3asked 3 years, 3 months ago Fernando Leal 9 -
0
votes0
answers13
viewsSQLITE3 installation via NPM finds 3 vulnerability
Good afternoon guys. I am trying to install sqlite3 with npm, and at the end of the installation it is reported that it had 3 vulnerabilities. I’ve done some research and I’d like to understand…
-
0
votes1
answer138
viewsSqlite inoperative in Python executable program created by cx_Freeze
I made a simple application in Python 3.6 and Sqlite3. When I run the main program by cx_Freeze and install it on the machine I developed the application on (where Python and Sqlite are installed),…
-
0
votes1
answer101
viewsAttempt to invoke virtual method 'java.lang.String android.widget.Spinner.toString()' on a null Object Reference
I am trying to save the data of a spinner in a variable through findviewbyid, to later be saved in SQLITE. The data is, name, type, third and date. But when I try to set this data, it is generating…
-
0
votes1
answer187
viewsError creating a table in mysql
CREATE TABLE EPI ( CODIGO__EPI INTEGER NOT NULL, USUARIO_CODIGO_USUARIO INTEGER NOT NULL, TIPO_EPI_CODIGO_TIPO_EPI INTEGER NOT NULL, EPC_EPI VARCHAR (255) NOT NULL, DATA_CADASTRO_EPI DATE NOT NULL,…
-
0
votes1
answer278
viewsI cannot delete record of the sqlite database selected in the listbox
After formatting the record display in the listbox ('{} Cellular: {}'. format(name, cell phone). lista = self.cur.execute("SELECT * FROM lista") for nome, celular in lista: self.listbox.insert(END,…
-
0
votes1
answer77
viewsSqlite in memory with Dapper generates non-existent table error
I have the following code for table creation: string query = @"CREATE TABLE GVP_USERS_TAGS( ID integer NOT NULL PRIMARY KEY AUTOINCREMENT, DATEINS datetime NOT NULL DEFAULT (DATETIME('now')), NAME…
-
0
votes1
answer45
views2 calls to the same table in Sqlite (output different than expected)
Given the following 2 tables: CREATE TABLE IF NOT EXISTS sugestoes ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, texto VARCHAR(250), autor VARCHAR(250), itens VARCHAR(250), pontos INTEGER );…
-
0
votes1
answer566
viewsOperationalerror: near "?": syntax error python sqlite3
Good night. I’m trying to put a dynamic column with the function class db(): def __init__(self,coluna): self.coluna = coluna def inserir_coluna_tabela1(self): import sqlite3 as sql conn =…
-
0
votes1
answer326
viewsPython does not insert data in sqlite3
I have the following code: #!/usr/bin/python3 import sqlite3 app = '/backup/app/' bd = app + 'bd/' contato_banco = bd + 'contato.db' contato_tab = (('nome' , 'TEXT'), ('email' , 'TEXT'), ('whatsapp'…
-
0
votes1
answer901
viewsHow to delete a table row in sqlite3?
I’m trying to crud sqlite3 with a GUI through Tkinter my table was created in DB Browser for sqlite. I’ve developed a little but it’s not working: from tkinter import * from tkinter import ttk…
-
0
votes1
answer141
viewsIs it possible to use Sqlite3 on Android using the Qpython3 app?
I’m trying to create a table: import sqlite3 def criar_tab_contato(conexao): cursor = conexao.cursor() sql = """ CREATE TABLE IF NOT EXISTS contato( nome text, telefone text, senha text ); """…