Questions tagged as 'sqlite3'

Tagged questions
1
answer

PROBLEM WITH SQLITE - View with multiple selects

I have three tables that I have to take a die in each to make an algorithm in the app, but I would like to know if I have a view that brings me the three data that are in the tables. I would like to know if I have to do this because none of the...
asked by 17.04.2014 / 14:27
1
answer

How to view and maintain a SQLite database [closed]

Hello, I recently started to study the SQLite database and would like to know if there is a way to view my tables and the entire database structure, just like pgAdmin and MySQL Workbench. If at least via USB I can access and modify these bank...
asked by 15.11.2017 / 22:12
1
answer

Update in Sqlite table via ImageButtom Android Studio

I have a project that I'm developing in Android Studio where I use a Custom Adapter, an Employee, and a DatabaseHelper. What happens, I use an already populated database that is in the Assets folder, which is copied to the application's Datab...
asked by 30.01.2017 / 21:18
1
answer

Problem with login using sqlite

My method is not returning the teacher logged in. public Professor autenticarUsuario(String usuario, String senha) { String SQL = "select * from PROFESSOR where USUARIO = ? and SENHA = ? "; String[] selectionArgs = new String[] {...
asked by 09.09.2016 / 04:27
1
answer

Error creating database with sqlite [closed]

Colleagues, I'm trying to create a database on a computer with Sqlite . It is installed and all OK, but when trying to create it using the cmd command:    C: \ Users \ José Roberto> sqlite3 C: \ Users \ José   Roberto \ Desktop \ databa...
asked by 04.08.2016 / 23:09
1
answer

Luasql (Sqlite3) accepting only a "value"

I'm trying to create a simple table, just with names, but when I enter a value, you can not enter any more. How I am doing: require 'luasql.sqlite3' local env = luasql.sqlite3() local con = env:connect('database.s3db') con:execute([[ CREATE...
asked by 03.03.2015 / 15:40
1
answer

Return from a sub menu to the main menu of a function in Python

I created a simple Python application for an agenda system with Sqlite3. There are 3 files in the main menu agenda.py o contato.py and usuario.py that will log in to the system. In the file 'agenda.py' I log in the user b...
asked by 11.10.2018 / 00:30
0
answers

Error: "sqlite3.OperationalError: no such table"

I have the following error:    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 import sqlite3 root = Tk() root.geome...
asked by 09.08.2018 / 02:38
1
answer

Django + Python how to update a table item

Speak people, I have a registration flow where in a first step except the student and then the data of the responsible, but after that I need the student to make a description and that description has to be inserted in the respective student, ho...
asked by 17.08.2018 / 15:18
0
answers

How 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() cur.execute('CREATE TABLE IF NOT EXISTS BancoDe...
asked by 17.08.2018 / 16:31