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
votes1
answer36
viewsPivot Room Sqlite
Good night, you guys. I am using select below, but I would like the turns to be columns. As there is no pivot option, how can I do this? select tma.turma as TURMAS, tno.turno as TURNOS, count…
-
0
votes1
answer19
viewsHow to get the Primary Key ID of the information from a line clicked on Listview?
Hello, I am new to Android programming and am doing a project of which I need to do a CRUD with a litView, anyway, I already have it displaying the data, however I would like to know how I do to get…
-
0
votes1
answer21
viewsI cannot insert data into the SQLITE3 table (NODE.JS)
Whenever I try to add data the SQLITE table appears this error. Someone helps me, pfv. I’m starting at the Back-end now ;-; const Database = require("../db/config") module.exports = { async…
-
0
votes1
answer30
viewsDisplay Future variable on an Elevatedbutton
I am making the call in my database of the boarding number, I need to put this number inside a button, but my variable "boarding" appears as undefined inside the Elevatedbutton import…
-
0
votes0
answers36
viewstype 'Future<Dynamic>' is not a subtype of type 'Set<Marker>'
Basically this code searches for the delivery locations already inserted in the databank and adds a marker on the map for them, in addition to showing the real-time position of the user. The error…
-
0
votes1
answer32
viewsFunction to create buttons according to the database
I have in my database several information and that for each information there should be a button that directs the user to the screen where a guide will be displayed according to the chosen option.…
-
0
votes0
answers14
viewsTDD with Jest and sequelize - POSTGRES Migration error for SQLITE
I am implementing TDD with Jest in a Node with express application, my database is POSTGRES and I have several sequelize Migrations already configured, and for my test scenarios I am running these…
-
0
votes0
answers11
viewsdisplay data stored on sqfliter in flutter
Personal I am trying to display data that I take from sqlfliter and display in a listview but always gives error: [ERROR:flutter/lib/ui/ui_dart_state.cc(199)] Unhandled Exception: type 'int' is not…
-
-1
votes3
answers4045
viewsDBMS to Sqlite
Can anyone recommend me a good SGBD Sqlite as I am using the sqlitebrowser to manage the databases of my Android applications, but I can’t do almost anything on it.
-
-1
votes1
answer767
viewsUpdate Android Database
I’m creating a database on Android that has a column called status where is saving (0 or 1) 0 for when you are without internet and 1 for when you have internet, I want to do the update from the…
-
-1
votes1
answer57
viewsQuery returns nothing
I’m making an application on android using sqlite but I’m not able to return anything with these Where statments. I have the following table: id day month valu1 valu2 and the following cursor:…
-
-1
votes1
answer124
viewsDoubt - Google Drive + Sqlite
Good night, You could use the Google Drive service as Sqlite HOST? Thank you!
-
-1
votes2
answers88
viewsCredit card in android app
Personal is the best person to save the number, due date and card cvv, in the app itself (sqlite) or in the web database?
-
-1
votes1
answer818
viewsSave an Arraylist<> to an SQLITE table
Speaks Galera, I’m wanting to save an array list in a table in SQLITE, can I do it? If yes, how? This is my table: db.execSQL("create table amc (_id integer primary key autoincrement,tipo text not…
-
-1
votes1
answer609
viewsSyntax Error! Java + XML
The database should be implemented in the Sqlite and should have the tables; tbprevisao and tbcidade The system should keep the data of the cities already consulted in tbcidade to avoid having to…
-
-1
votes1
answer746
viewsSqlite giving "near "CREATE" error: syntax error (code 1):"
Does anyone know what’s wrong to be making that mistake? I/System.out: ERRO 1 :android.database.sqlite.SQLiteException: near "CREATE": syntax error (code 1): , while compiling: CREATE TABLE…
-
-1
votes1
answer99
viewsError in Java database
Hello, I "created" an application with user registration and login, after the login screen that comes the problem, the system to log in is working, started to give problem after I created a screen…
-
-1
votes1
answer37
viewsSelecting gaps in database
I’m trying to build a select that will locate the missing items from a database. This is super unusual, 'select' the items that don’t exist. Let’s say I have a table called TBL795 with the column…
-
-1
votes1
answer118
viewsRelationship between different file tables
In Access it is possible to link between tables that are in different databases (files), this resource is called in Access table binding. I mean, I can have a table called CLIENTE in an archive…
-
-1
votes3
answers458
viewsListview images and quantity - Android
Next, I have 2 questions that relate, so I’ll ask on 1 topic. Well, I use this query to return a list of strings with product names. public List<String> getMedico() { List<String> list =…
-
-1
votes1
answer697
viewshow to popular the object array with Sqlite data
Well come on, I’m doing an application, this will have several student names. I made a method that add each name in a table of BD. in the comic is like this(Antonio, Pedro, Caio, Felipe......). I…
-
-1
votes1
answer70
viewsI’m not getting the inclusion of the bank
I’m studying android and I’m doing the bank’s CRUD... only I made the code and put to run it does not work. It has the layout with a field to write what you want to save and on the side a button,…
-
-1
votes1
answer849
viewsAttempt to invoke virtual method on a null Object Reference
Error: 09-12 17:13:09.088 26022-26022/costamilam.guilherme.contatosempresariais E/AndroidRuntime: FATAL EXCEPTION: main Process: costamilam.guilherme.contatosempresariais, PID: 26022…
-
-1
votes1
answer110
viewsHow to edit items in sqlite.net with Xamarin
I’m learning to use sqlite.net in the Xamarin, but when editing an item is not working, I debug the code and gave a breakpoint in the EditItens() and saw that the values passed to…
-
-1
votes1
answer47
viewsSqlitedatabase db error = this.getWritableDatabase();
public ArrayList<String> addMigracaoCadIndividual(String QUERY){ SQLiteDatabase db = this.getWritableDatabase(); return null; } java.lang.Nullpointerexception at…
-
-1
votes1
answer51
viewsSqlite with java, error
I have made a database of Bank Bank Accounts, each of these accounts has its own id to identify, and has his tipo, to know what type of account the user is accessing at that time, type, he can have…
-
-1
votes2
answers861
viewsConnection to db SQLITE and SELECT * FROM reciclagem_data WHERE $variable
I am making a program that allows the user to enter the ID of the person in question and later shows in a table all the data of it. So far, I have these two codes: <!doctype html> <html…
-
-1
votes1
answer35
views -
-1
votes1
answer32
viewsI can’t send my App data to the database
Ola I have had some problems with my Sqlite database in Android Studio when I try to add a new user it does not insert and presenting the error message when inserting users. According to what I…
-
-1
votes1
answer155
viewsHow to update a database (Sqlite DB) using the Workmanager library?
I am using the workmanager library to show a notification to the user indicating the time to take his medicine. I am also using the Sqlitedatabase library to store medicine information such as:…
-
-1
votes1
answer352
viewsError in sqlite and javascipt
I was making a video lesson and followed the exact same steps of the teacher, but this giving the following error when I execute the code in the powershell Even before you start entering the sqlite…
-
-1
votes1
answer20
viewshow to save data from an api with ruby and sqlite3
I’m creating an app only in ruby, with sqlite 3,I have to create the bd in bin setup to save the parameters of the api,I’m trying to make this foma: #!/usr/bin/env ruby require 'sqlite3' require…
-
-1
votes1
answer58
viewsHow to Insert Multiple Items using React-Native-sqlite-Storage
I was developing an application using the React-Native-sqlite-Storage but I came across a very strange problem, time my code works and time does not, I can not understand, to try to investigate I…
-
-1
votes0
answers7
viewsHow do I blur the table "X" act when saving Document in Table "Y"?
I need that when saving a subject to a student, the request for said subject is deleted. i access requests through the Solicitudcontroller public function solicitudes() {…
-
-2
votes1
answer257
viewsSqlite database in android project
Good afternoon, I’m having a question, I’m doing a project on Android Stúdio and my application has an idea of notepad, and I was wondering if it has how to show the annotations when initializing…
-
-2
votes1
answer27
viewsSqlite DOUBT BASIC A
Guys I’m learning sqlite and I learned to do the crud taking doubt if when I finish making the apk and put on the mobile he will create alone the bank file and will create and search or I have to…
sqliteasked 6 years, 10 months ago Aleander Rayson 37 -
-2
votes1
answer101
viewsI would like to know how Sqlite works
My question is this:: Whether database data is stored in a db file. on my computer. Or externally.
-
-2
votes1
answer43
viewsConnection with Sqlite returns Unsupported driver [C]
I’m trying to use Sqlite in a project but when performing any command with Sqlite returns: Unsupported driver [C]. this is my configuration on database php. 'sqlite' => [ 'driver' => 'sqlite',…
-
-2
votes1
answer484
viewsHow to enter data (registration) in Sqlite?
Hello, my Sqlite connection is as follows: Connection connection = null; try { // create a database connection connection = DriverManager.getConnection("jdbc:sqlite:database.db"); Statement…
-
-2
votes1
answer1071
viewsAdvantages and disadvantages of Sqlite
Sqlite is a powerful API for working with structured data, but it requires a lot of effort from the programmer to use it. According to Developer (2018), the programmer faces the famous "Boilerplate…
-
-2
votes1
answer54
viewsHow to pass the value of Sg. Input to a variable in another part of the code?
I’m doing a program to present in the college project, but I’m doing it through the window method by pySimpleGUI, I wanted when the person typed in Sg. Input a quantity, that quantity was calculated…
-
-2
votes1
answer56
viewsDoubt about finding information in the database
I’m trying to make a simple system of login, would like the system to check the logins that are already registered in the database, so that you have no more than one equal registered. I am using the…
-
-2
votes1
answer25
views -
-3
votes1
answer62
viewsCRUD: List Method
Good evening, I am learning about CRUD in my mobile programming course, we are programming in a database Sqlite, as the project is not yet ready for reasons of the teacher himself, to check if the…
-
-3
votes1
answer41
viewsLOGIN ROUTE ERROR
Hello, I am a student of programming, and during a project I came across a mistake that I cannot solve. I am basically in the creation part of "login" route, whose purpose is to search in the…
-
-4
votes1
answer1528
viewsSave images in the database and then show in a listview
I want to save images by sqllite and then display them for a listView, but I don’t know how to do it. Can someone help? No need to show lines of code I just want to know the logic I should follow or…
-
-4
votes1
answer81
viewsJava Help: Save a Key-Value Arraylist in a BD
I would like to know how to save a key and value Arraylist in the database using Java; I had already made an implementation earlier in php similar, whose I created the array and used the function…
-
-4
votes1
answer482
viewsSqlite Database is in 'binary' format in Visual Studio Code
Hello, I’m inexperienced with VS Code yet, and I’m creating a web application, but I’m having a problem and I haven’t found the solution on any other site...(I’m using knex db). I’ve tried to erase…
-
-4
votes1
answer62
viewsDbsqlite Android Studio Problem
Good afternoon, I have syntax problem in my Sqlite code in Android Studio. Could someone help me? package.com.projetofinal; import android.content.Context; import android.database.Cursor; import…
-
-5
votes1
answer48
viewsMy code only takes the last element of the database
My code only takes the last element of the database, but it lists the correct amount there and the log.i shows that is catching all. Why it does not work? package br.app.lista; import…