Most voted "sqlite" questions
Sqlite is a C-language library that implements a built-in SQL database. Programs that use the Sqlite library can have access to SQL database without running a separate DBMS process, not requiring service configuration.
Learn more…652 questions
Sort by count of
-
0
votes2
answers301
viewsSelect with two columns returning empty
In a mobile application (Android), I have two tables. A login table (user and password) and another (simple registration). The APP has a registration screen, if the user does not have an account he…
-
0
votes0
answers621
viewsSave current and end time to sqlite database
I am developing a project about home automation and at the moment when I click on the CONNECT button would realize the following functionalities: start device, start chronometer, save current time…
-
0
votes0
answers45
viewsData entered into Sqlite3 is not shown in the Pyqt4 application
I made a small Pyqt4 desktop application where I insert data in db sqlite3, but when I go to consult this data that was inserted previously, they are not on the display screen of them, only when I…
-
0
votes0
answers69
viewssqlite with android studio
is already solved. I want to add 3 data (date, location, and price) to my database. already solved some errors in database implementation. but now this error appears to me. I am not very good at…
-
0
votes1
answer385
viewsError while performing an SQLITE table creation
I’m trying the following mistake: android.database.sqlite.SQLiteException: no such column: np (code 1): , while compiling: SELECT _id, nome, email, np, tipoFunc FROM usuarios ORDER BY nome ASC at…
android android-studio sqlite android-fragment sqlite-studioasked 7 years, 5 months ago Lucas Charles 127 -
0
votes1
answer547
viewsScreen login SQLITE
I am trying to perform the verification of user existence and login when performing the access in the system. I’m using the following codes: public int login(String username,String password) {…
-
0
votes1
answer631
viewsReturn string in SQLITE query
I need to return a user’s name in an SQLITE query: I’m using the following code: public String verificarUsuario(String login) { try { String selectQuery = "select nome from usuarios where login = "…
-
0
votes1
answer33
viewsError while editing through SQLITE
I’m trying to edit information that’s saved in the SQLITE gang. I’m working with fragments. But I’m making the following mistake: FATAL EXCEPTION: main Process:…
-
0
votes1
answer135
viewsfetch all records from a sqlite column
I need to save in a list the names of the user table and save them in an Arraylist. I did as follows: public List<String> buscarUsuarios() { List<String> nomes = new…
-
0
votes1
answer50
viewsWhy does my database ( Sugar ) return null when I search by id?
I saved in my database using sugar every time I get a new notification, it works correctly, then in a Ragment I populate a recycleview with all database notifications, it also works correctly, but…
-
0
votes1
answer142
viewsUpdate BD after insert record
I use the following code to enter a record in sqlite: public void InsereSenha(String Nome, String Senha, String Dica, String Anotacao) { String sql = "INSERT INTO Senha (Nome, Senha, Dica, Anotacao)…
-
0
votes1
answer367
viewsAttempt to invoke virtual method 'void
Good evening, I am not able to solve the problem, it says it has an unregistered object (null Object Reference), but it does not have to initialize the following code: public void deletar(int id) {…
-
0
votes1
answer685
viewsRegistration without duplicity in Sqlite
I was able to avoid the double record of romaneio(nr_roman), but I made several attempts to do the same with the plaqueta(plaq),so that if the platelet already exists in the database, it persists in…
-
0
votes2
answers149
viewsWeb2py - Error using SQLFORM.Factory()
I can’t fix one error that appears when I try to expose a form to two tables of the SQLite. The error is as follows: Traceback (Most recent call last): File…
-
0
votes1
answer213
viewsUsing database coordinates in google maps API
I’m trying to use in Google Maps, the data that is in a database sqlite, But I’m having trouble accessing the shuttle’s return. I used the same logic to call using the database number and it worked,…
-
0
votes1
answer429
viewsAdd SQLITE data in Java
Guys, I’m having a problem I’m having trouble solving in Java. The intention is to connect to a database SQLite. But I’m having trouble inserting it. Take a look at the code, please. package…
-
0
votes1
answer120
viewsI think my table is not being created : no such table?
I am trying to make a check to know if there is something inserted in the table, but it always error in this row saying that there is no such table. my database: package…
-
0
votes4
answers1125
viewsLoading an externally created Sqlite database
I need to use a previously created Sqlite database, already with records inserted in it. But the only way I had done until then was when the application itself created the bank, which I internally…
-
0
votes0
answers38
viewsHow to put the values of a db column in an array?
I have a table, which is written below. Busy is the part I will move. The value of Busy will be changing according to the program from 0 to 1, depending on whether you are busy or not. I need to…
-
0
votes1
answer1783
viewsHow to delete not only tables but a database in Sqlite
I would like to delete not only a table but the database as a whole in Sqlite. Searching, I was told of a method Context.deleteDatabase(), but I can’t use, if I try to call in a method, it says it’s…
-
0
votes1
answer220
viewsHow to generate an Insert string from json
I am new and javascript and need to generate a string from Insert to sqlite with this string: { "InputFile" : "PER_02.inp", "RunTime" : 1492167103, "Reservoir" : "5", "Elevation" : 400.000000,…
-
0
votes1
answer496
viewsHow to pass data from one Fragment to another (upadte Sqlite)?
I’m developing an app with Sqlite, I want to take the dice of a ListView (where I am displaying the saved information) and want to play for a Fragment to enable the user to edit it. I’ve tried…
-
0
votes1
answer282
viewsAttempt to invoke virtual method 'long Contactodao.alterar(Contact)' on a null Object Reference
Error: 09-12 14:05:28.662 10410-10410/costamilam.guilherme.contatosempresariais E/AndroidRuntime: FATAL EXCEPTION: main Process: costamilam.guilherme.contatosempresariais, PID: 10410…
-
0
votes0
answers109
viewsHow to update a Spinner from Edittext data on Android
I have a Spinner that is being filled with Sqlite data, I want to take this data, edit them and update them My Spinnerdatabase class method (responsible for the Spinner database) public void…
-
0
votes2
answers195
viewsHow to list the latest message from all conversations
I’m creating a chat in android studio, so I need to list the last message between the chat user and his contacts, regardless of whether he sent or received the last message. I have selected below on…
-
0
votes2
answers2660
viewsHow to take value from a Radiobuton within a Radiogroup to save in the bank
wanted to know how I took the value of a Radiobutton to save it in the sqlite bank. In the example below the instructor does as follows: public class FormularioHelper { private Aluno aluno; public…
-
0
votes0
answers139
viewsReturn Null even with registration in Sqlite database
I’m having a problem making this query where I’m looking for the product code and service code. If I make a select without WHERE I get results but doing this way my Product object always returns…
-
0
votes2
answers144
viewsinsert a cursor inside of a while on android
on android i have a cursor where it searches the data in the database and returns the data perfectly but.. as I insert a second cursor inside the first? to pull data from a second table my code try…
-
0
votes1
answer372
viewsSyntax error when using Sqlite android "DROP TABLE IF EXISTS"
package com.example.wesley.bancodedadossqlite; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; /** * Created by Wesley on 17/01/2018. */ public class…
-
0
votes1
answer720
viewsSqlite error: Foreign key Mismatch (fk incompatibils) when trying to make an insert
I’m trying to create a Associative Entity (N:N) in Sqlite like this: [ Pet --< Vacinapet >--- Vaccine ] And, here is the code of my Associative Entity CREATE TABLE VACINAPET ( vp_data TEXT NOT…
-
0
votes0
answers38
viewsException sqlite in windows 8
I’m getting this Exception when trying to open a window inside a program I made, the program was done in visual studio 2017, with sqlite 3, it opens normal only from this problem when trying to open…
-
0
votes1
answer85
viewsSqlite Visual Studio 2008
I am trying to work with Sqlite in Visual Studio 2008 to make a system for Windows Embedded Compact 7. The problem is that it always gives the following error: A first chance exception of type…
-
0
votes0
answers113
viewsC# Xamarin: Sqlite table from Mappings classes (Entitytypeconfiguration<Class>)
I’m trying to create some tables on sqlite with VS Community 2017 (c# and Xamarin android) from classes that are defined by Entitytypeconfiguration. Below I try to better detail my difficulty. I…
-
0
votes1
answer75
viewsMultiples Inserts with JS (works in the browser but in the app generated by phonegap build not)
Updating by the @Sveen indication solution, in exchange var for const, but it only worked in the browser, in the app it continues replicating only one value: for (var i in dados.valor) { const query…
-
0
votes1
answer21
viewsError editing record in DB
Hi, I’m having trouble editar a record: Follows View _form.html.erb <%= form_with(model: cliente, local: true) do |form| %> <% if cliente.errors.any? %> <div…
-
0
votes0
answers287
viewsShow graph sum of objects - Django/Python/Sqlite
How to show a graph with the sum of objects with Django/Python/Sqlite? In this case we have 'internal boxes' (y-axis) for 'teams' (x-axis) that are rendering'internal boxes' values for each 'team'…
-
0
votes1
answer335
viewsRun sql file with Sqlitedatabase Android
I am implementing in an Activiy the download of an sql file from a server on the web. The Download I’ve managed to do and is working smoothly. However, taking this downloaded file and having it run…
-
0
votes1
answer77
viewsSqlite in memory with Dapper generates non-existent table error
I have the following code for table creation: string query = @"CREATE TABLE GVP_USERS_TAGS( ID integer NOT NULL PRIMARY KEY AUTOINCREMENT, DATEINS datetime NOT NULL DEFAULT (DATETIME('now')), NAME…
-
0
votes0
answers68
viewsThis giving error when I try to insert in my sqlite + java database
package Contas; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.Scanner; import javax.swing.JOptionPane; import BancoConexao.Banco; public class ContaCorrente…
-
0
votes1
answer58
viewsHow to use Select
I was able to save information in my Sqlite bank, only I can’t call them. I’m trying to use the following method: private void verPessoas() { ArrayList<RespostasAguaCasa> pessoas = new…
-
0
votes1
answer675
viewsHelp Android Database Locked (code 5)
I’m with an error Android Database Locked (code 5). I’ve tried all possible solutions found on Google and nothing solved. I have a Databasehelper class that has control of the bank’s connection and…
-
0
votes1
answer695
viewsAndroid: How to create an external Sqlite database dynamically?
I have researched this thoroughly and all the examples I have found and tested have not worked. To make the code more organized I would like to do this using the Openhelper class but I have already…
-
0
votes1
answer701
viewsUsing Tkinter together with a database
I am doing a program of registration of people with interface (still very basic, just to do tests) and I am with several difficulties: I’m extracting the data using the .get(), however, I can only…
-
0
votes0
answers1953
viewsHow to store image in Sqlite?
I have an app with product registration that has 3 Edittext and 2 imageView. I am trying to save these values in Sqlite but there is something wrong because there is no error but also not saved,…
-
0
votes0
answers22
viewsUPDATE Sqlite and PHP error
<?php $ip = $_REQUEST['ip']; $port = $_REQUEST['port']; class MyDB extends SQLite3 { function __construct() { $this->open('Tracker.db'); } } $db = new MyDB(); if(!$db) { echo…
-
0
votes1
answer53
viewsCreate Android Studio Unique Field
I’m a beginner in android development and I’m trying to create a table in sqlite where the value of email will be unique. Only the app is allowing you to register equal emails. @Override public void…
-
0
votes1
answer339
viewsSqlite, check the exact difference between a date, time and minutes of the current date
I need to do a check between two dates, I need to check if the date, time and minutes of a field is greater than or equal to the current date, time and minutes, I am using the sqlite. SELECT * FROM…
-
0
votes0
answers21
viewsSelect android error
I can’t return the value inside my Arry always returns 0 Class Read public class Read { public ArrayList<RespostasAguaCasa> getLista() { SQLiteDatabase db =…
-
0
votes0
answers25
viewsSqliteopenhelper Error(8,8)
I’m starting to program in Android and want to make a class with a database. package josephisaac.com.wmvendas; import android.database.sqlite.SQLiteDatabase; import…
-
0
votes1
answer143
viewsSearch database-specific data in Ionic 3
I would like to know how to filter and receive only the data I want on each page. my database.ts : `getAllProducts(){ return new Promise<Produto[]>((resolve, reject) => { let sql = "select…