Questions tagged as 'sqlite3'

Tagged questions
1
answer

Attempt to invoke virtual method 'java.lang.String android.widget.Spinner.toString ()' on a null object reference

I'm trying to save data from a spinner to a variable via findviewbyid, and then it's saved to SQLITE. The data is, name, type, third, and date. But when I try to set this data, it is generating the following error: FATAL EXCEPTION: main...
asked by 12.07.2017 / 20:04
1
answer

SQLite inoperable in Python program executable created by cx_Freeze

I made a simple application in Python 3.6 and SQLite3. When I generate the main program executable by cx_Freeze and install it on the machine I developed the application (where Python and SQLite are installed), the application works fine, inc...
asked by 28.04.2017 / 01:55
1
answer

Locale database + node.js

I'm working on a project using node.js. I need to use a local database, but I wanted to reconcile performance with security, and if possible, portability as well. I only know MS Access (.accdb) and Sqlite3. [MS ACCESS] Prós: Senha...
asked by 13.11.2015 / 20:08
1
answer

Error: Undefined reference to 'sqlite3_open'

I am creating a software in C that uses SQLite 3 as a database, but when compiling the project Codeblocks returns me the following error message:    createdata.c || undefined reference to 'sqlite3_open' |       undefined reference to 'sqlite...
asked by 26.10.2015 / 23:18
0
answers

Problems using FK, SQLITE3 and C

I'm having trouble writing records to my log table that has an FK from the client table. The error is in the insert_log () function SQL to create tables sql_create_client = "CREATE TABLE cliente (id INTEGER NOT NULL PRIMARY KEY AUTOINCR...
asked by 02.11.2015 / 01:42
0
answers

Problems with SQLitePlugin Cordova / Phonegap

I'm trying to create a connection with a SQLite database created within my application and returns the following error. SQLitePlugin.executeSql[Batch](): Error=no such table: fornecedor_motorista (code 1): , while compiling: INSERT INTO fornec...
asked by 27.08.2014 / 19:13
3
answers

SQLite DBMS [closed]

Can someone recommend me a good SQLite DBMS, as I'm using sqlitebrowser to manage the databases of my Android applications, but I can not do nearly anything on it.     
asked by 09.04.2014 / 03:13
1
answer

SQLite giving "near" CREATE error: syntax error (code 1): "[closed]

Does anyone know what's wrong to be giving this error? I/System.out: ERRO 1 :android.database.sqlite.SQLiteException: near "CREATE": syntax error (code 1): , while compiling: CREATE TABLE tbcliente ( IdCliente int(11) NOT NULL, IdEmpresa int...
asked by 27.12.2018 / 19:34
1
answer

SQLite3 - unrecognized token

Hello! Can you help me? I have tested in several ways, but I could not understand. With up to 3 variables this form works, however with 7 variables it presents the error in the image below. I've been stuck with this problem for more tha...
asked by 09.12.2018 / 02:14
1
answer

Selecting gaps in database

I am trying to mount a select that finds missing items in a database. This is super unusual, 'select' items that do not exist. rsrs Let's say I have a table called TBL795 with the NRBEM column that should, in theory, not have gaps in the sequenc...
asked by 27.12.2016 / 16:39