Questions tagged as 'sqlite3'

Tagged questions
0
answers

Removing rows in PyQt

I need to remove a row in the Pyqt table. In fact it load the lines as per the filter. But at the time it's going to open it pulls the IDs of the lines out of the filter, how do I resolve this?     
asked by 20.04.2018 / 13:25
0
answers

Inserting bank value in ExpandableListView via hasmap

I'm having trouble inserting values in the ExpandableListView of the SQLite Android database. In my app, I have a main table called DISCIPLINES and another table that has a foreign key reference to this main, called NOTES. In my Expandable...
asked by 13.11.2017 / 22:04
1
answer

See records from the same month

I'm having difficulty searching the sqlite3 database, records for a specific month, I searched the internet but found nothing that could help me. I have an account template that has belongs_to with the class Location that is an enum where it has...
asked by 25.07.2017 / 22:14
1
answer

SQL to notify a certain date 2 days before the same in SQLite

Dear Programmers, I am a beginner and I would like to know how to make a sql notify me of a certain date in the bank, for example: 06/28/2017 I want it to arrive two days before give me a return in this case day 26 / 06/2017. Can anyone help...
asked by 22.06.2017 / 17:16
1
answer

How to represent in the database (android sqlite), one class that extends another? [closed]

Hello, I'm working on android, I have a case where one table extends another. example: Exercise table - > String dataInicio, String description ....... etc Football table - > String startTime, Int duration ... etc Football exte...
asked by 08.05.2017 / 14:44
1
answer

beforeupdate sequelize does not work

I'm trying to make the data update encrypt the user's password, but it simply does not work and does not give an error. Have the following sequelize model. import bcrypt from 'bcrypt'; export default (sequelize, DataType) => { c...
asked by 28.11.2016 / 06:36
0
answers

"Invalid class typecast" when loading stream from SQLite (delphi)

I'm trying to fetch an image I've already inserted into my SQlite database, however on the line ms:=query.CreateBlobStream(query.FieldByName('imagem'),TBlobStreamMode.bmRead); I have the error "Invalid class typecast" note: I'm using del...
asked by 20.01.2016 / 12:06
1
answer

Problem when inserting into a SQLITE table using RAD STUDIO XE6

Good afternoon, I am having a problem in my code, I use Rad Studio XE6 connected to an SQLITE base, when I insert values with point in the table the following error occurs for example = 'near' 6.75 ": syntax error 'being 6.75 the value, when I p...
asked by 09.09.2014 / 20:43
2
answers

How do I get 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) label2 = Label(jan, text="Idade:") label2.g...
asked by 11.08.2018 / 19:09
1
answer

OperationalError: near "?": syntax error python sqlite3

Good evening. I'm trying to put a pivot with the function class db(): def __init__(self,coluna): self.coluna = coluna def inserir_coluna_tabela1(self): import sqlite3 as sql conn = sql.connect('db/dbase.db'...
asked by 16.07.2018 / 04:57