Questions tagged as 'sqlite3'

I want to insert in sqlite a blob field from console I'm working on android I try to use this (I give a simple example) Person table (storage database) id - identification field name - text photo - blob and I try to insert in this wa...

I do not know how to solve this error that appears to me when trying to start the SQLite3 Login with Adminer. I searched and I get a code (I put lines below) to implement it and I can log in but I get other errors (the compatibility). How can i...

With the "users" table created, I am ready to enter data in it. These data are entered by the user, and then inserted in the table. I have the following function: int registrarUsuario(string name, string second){ sqlite3 *db;...

Greetings to everyone, I'm doing a support control system in VB.Net Community 2017 my database is SQLite , the connection is fine and makes the perfect query and as I wish but when changing database I gives the following error:  ...

CREATE TEMP TABLE var(nombre VARCHAR(255),entero INT(5),texto VARCHAR(255)); CREATE TEMP TABLE param(nombre VARCHAR(255),entero INT(5),texto VARCHAR(255)); INSERT INTO param (nombre,texto) VALUES('criterio',''); INSERT INTO param (nombre,entero)...

For now I am only commenting on the table columns. To put comments at the time of creating it I am using this query: CREATE TABLE KBase ( n1tId INTEGER UNIQUE PRIMARY KEY AUTOINCREMENT NOT NULL /* ####### AutoNumerico */, a1tNomb...