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
-
1
votes2
answers856
viewsDatabase graph does not show python matplotlib
The sketch of the graph appears, but empty , with no data. import sqlite3 import matplotlib.pyplot as plt import matplotlib.dates as mdates connection = sqlite3.connect('escola.db') c =…
-
1
votes1
answer44
viewsWhy does the connection pool close before displaying Sqlite data?
I am trying to display BD data in a Recycleview but get the following error: E/AndroidRuntime: FATAL EXCEPTION: main Process: com.example.emerson.drawer, PID: 8316 java.lang.IllegalStateException:…
-
1
votes2
answers507
viewsError entering data in Sqlite database
Class creating the bank public class CriaBanco extends SQLiteOpenHelper { private static final String NOME_BANCO = "lista.db"; private static final int VERSAO_BANCO = 1; public CriaBanco(Context…
-
1
votes1
answer3816
viewsHow to make a query in Sqlite?
In my project the user must register to enter, when placing the data name, email and password and when clicking the registration I would like to check if the email already exists, how to do ? I have…
-
1
votes1
answer137
viewsHow to make Inserts in table creation in Sqlite?
I would like to know how to do INSERT manuals in the Databasehelper class that extends from Sqliteopenhelper. public class DatabaseHelper extends SQLiteOpenHelper { private static final String…
-
1
votes2
answers467
viewsAuthentication screen with Sqlite
I have to authenticate the user, but when I inform the user and the correct password he enters the menu screen, so far so good. The problem is that when I type an incorrect password or user, I want…
-
1
votes1
answer1028
viewsFill object list with Sqlite data
I have a state object containing the following attributes. idState (String), siglaState (String) And I have a table already filled in the database with the same attributes above. But I would like to…
-
1
votes2
answers415
viewsAccess Sqlite database in another Activity
I’m starting in java android, I’m quite layy yet, I’m picking up the concept of POO gradually. My problem is this, I have a Criabanco class and another Bancocontroller where I have some methods to…
-
1
votes2
answers46
viewsError in Sqlite class
What am I doing wrong in this class of Sqlite ? I’m getting this error: java.lang.RuntimeException: Unable to start activity…
-
1
votes1
answer82
viewsPopular Listview UWP C#
I’m using a bank in sqlite, already done and with data in my application UWP and trying to display in a listview the data in the table Marcas. What I’ve done so far is create a class Marcas: public…
-
1
votes2
answers1048
viewsBringing a sum in Sqlite Android
I have a problem in the development of an App, following, I have a list that all the data of donations in the bank, and in this Activity I created a Textview to receive the total value of those…
-
1
votes0
answers89
viewsError creating sqlite database from installed apk
I used a populated . sqlite database in a project. I imported the bd into the Assets folder and implemented the code for creating and accessing the database. I ran the project and everything worked…
-
1
votes1
answer66
viewsData is not entered in sqlite
Guys I’m starting now on Android, I went to do a test of entering data in the database but the data are not entered, I may be mistaken at some point, follows below the code: protected void…
-
1
votes0
answers12
viewsAndroid project does not delete record in Sqlite database
My application makes insertions and reading the existing records in the Sqlite database, but when I will run a delete I have the following log message: W/Fileutils: Failed to…
-
1
votes0
answers58
viewsSqlite does not save data to table - table users have in column named email
can anyone help me with the following question?? I’m creating a simple APP on android and using Sqlite, but when running the APP and entering the data in the user registration area, appears the…
-
1
votes1
answer138
viewsRuby on Rails Sqlite3::Busyexception: database is locked: INSERT INTO
Hello, I am facing a problem with Sqlite3. When I run the code: user = SystemUser.new(email: "[email protected]", password: "marcos123") user.profile = Profile.new(first_name: "Marcos") user.save…
-
1
votes1
answer188
views -
1
votes1
answer52
viewsSqlite Database is not entering values
I am creating a simple application that involves the Sqlite database and throughout the development my insert function in the table has stopped working. Through the debug I could notice that it is…
-
1
votes1
answer26
viewsHow to get the number of users with less time in each Client?
I have 2 tables: CREATE TABLE `deathrun_records` ( `sid64` STRING, `mapname` STRING, `seconds` REAL ); CREATE TABLE `clan_members` ( `sid64` STRING, `nome_clan` STRING, `prop` STRING ); The first…
-
1
votes0
answers14
viewsDifferent results from the same application with Sqlite
The attached screens are the result of the same query on a tablet with Android 4.1.2 and a Galaxy S3 with Android 4.3 (the one that has Brazil only once, which is correct) and another with the Moto…
sqliteasked 6 years, 10 months ago Daniel Tibúrcio 21 -
1
votes0
answers180
viewsDifficulty listing Sqlite result in Listview Android
I’m creating an application to train mobile development, I’m doing for Android in Visual Studio, using Xamarin. I’m having difficulty listing a result of Sqlite. I created two Activity, one to…
-
1
votes1
answer537
viewsError when connecting with sqlite in the Laravel
Internally everyone is working, migrations, tinker, sqlite3, but in the server application it always queries the mysql instead of the sqlite for all operations, ie he is using Connector.php instead…
-
1
votes1
answer99
viewsHow to capture exceptions released by the Insert() method?
I am using Sqlite for a local bank in an Android application, my problem is that I am unable to handle the integrity restriction exceptions. I have a table where the two fields are PK, that is,…
-
1
votes1
answer48
viewscolumn 'Minhacoluna' does not exist - Android Sqlite usage
Hello, I’m trying to recover the recorded data in my database, however, when I run a function to return the value of one of the columns created in the Sqlite database in the memory of the mobile…
-
1
votes1
answer373
viewsAndroid - How to create and combine two tables within a list of Sqlite tables on Android?
I’m creating an app to monitor aquarium settings using the following schema: The user can monitor as many aquariums as he wants, but every time he adds a new tank, these two tables should be created…
-
1
votes1
answer133
viewsHow to know which is the last item selected from a listview?
Hi, I have a ListView using the simple_list_item_multiple_choice, filled with a ArrayString of all Brazilian states. I need to fill the following SQL command with all the states selected by the user…
-
1
votes1
answer113
views -
1
votes0
answers81
viewsCRUD Android doubts
Good afternoon I’m with 3 doubts regarding a crud I made in my app. 1 I did a field search and it seems that does not pick up any phone of the line J7 and I was wondering if someone can tell me why…
-
1
votes1
answer62
viewsReturn of Maximum value
Good morning, I’m conducting a course and I’m stuck on an exercise. In the exercise I have to return the maximum popularity value of each musical genre by country, so far all well, I managed to…
-
1
votes2
answers941
viewshelp with storing value of a local variable in python
Hello, well, I am writing an application using SQLITE and Python, everything was going well until I had a problem that I am not able to solve, it happens that I have a db of the fipe, so I need to…
-
1
votes1
answer329
viewsInsert two commands (INSERT and UPDATE) into the same instruction in Sqlite, via R Language
Hello, everybody I have a problem in knowing how to insert two commands (INSERT and UPDATE) in the same instruction in Sqlite, via R Language. I don’t know if this is impossible due to Sqlite or R’s…
-
1
votes1
answer87
viewsSimultaneous threading (parallel processing) in R and serialized recording in Sqlite
Hey there, guys. I am trying to develop a code that makes it possible to perform parallel processing (parser) of HTML files using the R Language and, consecutively, record the data extracted from…
-
1
votes0
answers104
viewsReturning number of Sqlite records and displaying in Textview
I have an app and I need to display in a TextView the amount of records stored. public int contagem(){ createBank = new CreateBank(this); connecting = createBank.getReadableDatabase(); String cursor…
-
1
votes0
answers29
viewsSqlite does not input data into the database during an Asynctask
I’m trying to add data to DB inside an Asynctask. In it I catch the Inputstream coming from an httpURLConnection, I interpret the JSON and saved in the local Sqlite. But I don’t even know if this is…
-
1
votes2
answers167
viewsRecover Spinner’s position to use in another Spinner from another Acitivity
I have a Banknote Registration App that has 1 spinner. Spinner contains card registration with Idcard, title and description (Saved in a "Card" table in the database). When save this register from…
-
1
votes3
answers76
viewsHow to Save to Seekbar Android Sqlite Value Database
I am trying to register values in the database in Kotlin from Seekbar, from Datepicker, Radio Group in my Cadastroscrolling.kt I can play the visualization of age // definindo SeekBar seekbarIdade =…
-
1
votes1
answer76
viewsResult of a SELECT in Postgresql is not the same in Sqlite
Good evening guys, I developed a Query in Postgresql to apply a SELECT in my data imposing some rules, and these rules are very important for me to get the right result at the end of the selection.…
-
1
votes1
answer49
viewsDatabase and Listview do not work
I’m trying to create an app that records data and displays it in a Listview, and then gradually sophisticate the app, but when it comes to saving the data in the database, it doesn’t save. In Debug…
-
1
votes1
answer114
viewsInsert method does not save data
I have an application where the goal (at the moment) is to take the data typed in a form and save in the Database. And the Insert method of my Datasource always returns me false I do not understand…
-
1
votes1
answer80
viewsListview returns only one Cursor item
Good afternoon guys, I have a problem with my project. I have a Listview that receives information from Cursor and then sends it to the Adapter, but it is only pulling a record from my database, you…
-
1
votes1
answer375
viewsInsert data into Sqlite
I’m learning to use Sqlite, but I’m not able to enter the data. Come on, I’m creating a simple space for the user to enter his name and password and a button to send the data in Sqlite. My html is…
-
1
votes0
answers71
viewsHow to make the Radio Button appear checked if the database is updated Android Studiop
I’m making an app with questions and answers, I have a radiogroup, a textview and 3 buttons: confirm, next and back. I am trying to get once the question is answered, when returning in that question…
-
1
votes1
answer212
viewsSELECT with SQLITE and Xamarin.Android
I’m trying to run a database check, but it’s not working. I still don’t understand how to do the research based on a criterion, using Sqlite and developing the application using Xamarin.Android. The…
-
1
votes1
answer135
viewsError returning objects saved in database between activites - Null object
I’m developing a simple application to fill out a form, display the registrants and edit them. I’m using the one-to-many relationship where a patient can hold multiple photos, photos that are being…
-
1
votes0
answers38
viewsAndroid only fills product value in version 4.1.1
First of all Good afternoon, everyone. Secondly, I confess that I do not know how to explain, but I will try to talk here what happens. My app searches the data in Sqlite the same way, and returns…
-
1
votes1
answer83
viewsStock Control - "Database locked"
I am doing a C# inventory control and the idea is that when the user clicks a button, the amount of a record in Datagridview is incremented. The first time I press the button, it updates perfectly.…
-
1
votes0
answers42
viewsSql - How to make a name or surname unique
Guys, the following is a table called sqlite, and I want the following I don’t want data to repeat, but if someone with a name and surname is registered, I want a person with the same name to be…
-
1
votes1
answer306
viewsSqlite - Python insert data automatically
Hi, I’m writing an algorithm that collects information from dividend companies. The collection is performed and mounts a table and up to this point everything excellent. but I would like to save in…
-
1
votes0
answers55
viewsCreation of tables Sqlite(Room) on Android with the standard Repository (very simple question.. but I need a clarification)
Guys I have a question in the creation of tables and another in the issue of Repository, so come on. EX: data class Carro( val marca: Marca, val motor: Motor ) data class Marca( val nome: String )…
-
1
votes1
answer39
viewsError entering data in Sqlite
Hello. I’m having trouble with this personal project. When trying to save a product, Sqlite did not like Price, which is set to float, but when saving in db (which is set to REAL, I even changed to…