Questions tagged as 'sqlite3'

Tagged questions
0
answers

Problems compiling for static in GO with CGO_ENABLED = 1

I created the following script to compile a project as static in go, but I'm not getting a static executable. PASTA=bin/scak_linuxAMD64 ARQUIVO=$PASTA/server_rest export GOOS=linux export GOARCH=amd64 export CGO_ENABLED=1 export CXX_FOR_TARGE...
asked by 02.09.2018 / 19:30
0
answers

Bug when pulling the drawable id straight from the database

I'm developing an application that among one of the functions is to list categories of food products, these categories are registered in sqlite, containing the id, category name and id of the image that is inside the drawable folder of android....
asked by 22.08.2018 / 01:57
1
answer

help with storing value of a local variable in python

Hello, well, I'm writing an application using SQLite and Python, everything was running fine until I had a problem that I can not solve, I happen to have a db of fipe, so I need to load 3 combobox with brand, model and year , then I decided to do...
asked by 02.07.2018 / 04:43
1
answer

SQLite in memory with dapper generates non-existent table error

I have the following code for creating the table: string query = @"CREATE TABLE GVP_USERS_TAGS( ID integer NOT NULL PRIMARY KEY AUTOINCREMENT, DATEINS datetime NOT NULL DEFAUL...
asked by 18.05.2018 / 22:35
0
answers

How can I separate text from a bibliography from sqlite to other columns of the same row in sqlite?

I'm doing a college job where the teacher asked me to get the data from his site " link ", where it contains all the bibliography of his publications, the information about all his publications and organize in a database of automatic way. I was...
asked by 27.03.2018 / 03:25
1
answer

I can not delete the selected sqlite database record in the listbox

After formatting the record in the listbox ('{} Mobile: {}'. format, I can no longer delete the records from the Database. lista = self.cur.execute("SELECT * FROM lista") for nome, celular in lista: self.listbox.insert(END, '{}...
asked by 01.02.2018 / 14:08
1
answer

Read data from a SQLite 3 database in Python

I'm starting in Python and database and I've had three doubts! For example, inside my database I have a "name" column. Just to illustrate, let's say I want to get the contents of the "name" column corresponding to id = 1 and play on a Pytho...
asked by 15.12.2017 / 03:40
1
answer

Error 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, VALIDADE_EPI DATE NOT NULL,...
asked by 04.12.2017 / 20:31
0
answers

Error when inserting registration: "No such table" - can anyone help me?

I'm developing the registry for my application, however I'm having an error when registering (insert function), an error that I can not solve, it's in the image: Classrecord:privateEditTextUsuário;privateEditTextSenha;privateEditTextCsenha;p...
asked by 26.10.2017 / 03:10
1
answer

Variable reset

I am doing a search in the SQLITE3 data loop inside my program and it returns values into my variable, however when I make a condition to be executed for when the value is filled it returns empty, I am beginner in BD Python and Kivy: class St...
asked by 09.08.2017 / 00:30