Questions tagged as 'sqlite3'

Tagged questions
0
answers

Disadvantages to enter records with Adminer

Hello everyone I have a problem with the Adminer in Windows , on entering I can create Databases and tables without problems but when I try to insert a record it appears this error:    you have not privileges to update this table It al...
asked by 12.09.2018 / 20:04
0
answers

how to pass script from sqlite3 to shell script?

My query is as follows: I open a .db file from the cdm of sqlite3, with some queries and I want that same code to be executed as a script from the powershell, so I can create an automated process to execute it in certain time of day. Is th...
asked by 28.08.2018 / 17:19
0
answers

Error that will not let me compile file in c ++ / sqlite3

The program throws me an error about an entry not recognized in the code. Referring to this piece of code: if (sqlite3_open("C:\ProgramData\PROISER\ISASPSUS\datastore\dsfile.db", &db) != SQLITE_OK) { printf("ERROR: can't open da...
asked by 24.08.2018 / 19:04
0
answers

How to create a trigger with sqlite3 in python

I am making a simple graphical interface of a DB in which a name, password, last name, address and comment are inserted. Then you have four buttons that allow you to create, read, update or delete that information entered from the database. The...
asked by 17.08.2018 / 12:34
0
answers

Display data from sqlite3 table in a DataGridView

How will I show a DataGridView in Tkinter? I have the following code: from tkinter import * from tkinter import messagebox import sqlite3 root = Tk() root.title("Gestión BBDD") root.geometry("300x400+500+300") root.resizable(width=Fals...
asked by 23.07.2018 / 17:47
0
answers

is it possible to speed up a Sqlite3 query in python if I need to search all the elements in the table?

I made a code that makes it work well, evaluates the value of column 2 (plan) for each of the elements in column one (nrocaja). The plan is a list of lists serialized as a BLOB, which the code retrieves, deserializes and evaluates each of...
asked by 09.06.2018 / 04:29
0
answers

Why do not you recognize the column name with sqlite3?

I am developing a simple code to store and retrieve information in a database to learn how to use sqlite3 in python. The save part works fine but not the recovery part, I throw the following error when the column does exist: sqlite3.OperationalE...
asked by 02.06.2018 / 21:28
1
answer

Sqlite3 problem with duplicate values

. Tables involved: data_incidence data_ticket I try to execute this query: select t1.fecha_carga, t1.hurtos, t2.fallas, t3.ticket from (select count(ttc) as hurtos, fecha_carga from data_inciden...
asked by 20.05.2018 / 19:02
0
answers

Error executing a query in sqlite3 + crontab

I have a script made in python3 that makes scraping a web page and saves the info in a sqlite DB. To all this I have it mounted in a VPS. The problem is when I create a crontab so that the script runs every so often, when it runs and arrives at...
asked by 16.03.2018 / 04:51
0
answers

Why does data.rows.length return 0 when making an insert in a BD SQLite?

I'm having problems inserting data into a SQlite database on Ionic 2. basically I do not know if it's really inserting me. This is the method of the creation I insert test = "prueba"; initializeDatabase(){ return this.sqlite.creat...
asked by 25.02.2018 / 15:23