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
answer365
viewsuse ion-select dynamically
I put as options in ion-select, South zone, north, center and west. I want when I click on some option, to show only the information of that zone by taking the information from the database. At the…
-
0
votes1
answer3133
viewssqlite3.Operationalerror: near " ": syntax error
you know what that mistake means? Error: sqlite3.OperationalError: near “ ”: syntax error Code: def alterturma(self): bancoturmas = Bancoturmas() #try: c = bancoturmas.conexao.cursor()…
-
0
votes1
answer118
viewsPick item contained in a Listview item by clicking on the item
My situation is as follows, my listview loads the items into an xml I created for each listview item At the time listing is like this: What I want to do is, by clicking, take these items circled in…
-
0
votes1
answer270
viewsandroid.database.sqlite.Sqliteexception: near "SQL": syntax error (code 1): , while compiling: SQL * FROM Employers WHERE id =?
I’m trying to do the SELECT below passing a value as parameter in the query, only it keeps giving the same error. android.database.sqlite.Sqliteexception: near "SQL": syntax error (code 1): , while…
-
0
votes1
answer830
viewsPython: Tkinter + SQLITE. Save records to database and clear field
I am studying, on my own Sqlite, I already bought some courses, but I need a help. Objective: I would like to save the user typed fields in the database and then clear the same fields to allow new…
-
0
votes1
answer139
viewsError with date time
Guys I’m trying to run my code, I’m having the following error: Typeerror: 'datetime.date' Object is not subscriptable How do I fix it? follow my code below: def making_date(self, *args, **kwargs):…
-
0
votes1
answer654
viewsHow to make a chart from a python dictionary
I am wanting to make a graph in python pulling information from a dictionary. In my case is the following, I have an initial and final date, I made the difference between the two. If the difference…
-
0
votes1
answer1759
viewsHow to use sqlite3 with Docker Compose
Since sqlite3 banks are only files; And containers, by their own logic of scalability are created and excluded according to need; What is the best way to work with both partners? You see, I’m trying…
-
0
votes1
answer202
viewsHow do I not select repeated data that contains a specific value in SQL in a column?
Good evening guys, I’m beginner with Database, I have a Query that runs a filter following a rule: Rule: GSM which is repeated, and has in both STATUS = 'TEMPORARY ANOMALY' and its MOTIVO_ENVIO is…
-
0
votes1
answer56
viewsSearch String Random in Sqlite and then show the Result on the Screen with button
// Create Database. final Sqlitedatabase bankDados = openOrCreateDatabase("Table name", MODE_PRIVATE, null); // Criar Tabela. bancoDados.execSQL("CREATE TABLE IF NOT EXISTS questions(id…
-
0
votes1
answer39
viewsSqlite Ionic 3 - Problem saving SELECT responses to an array
I’m on a project using Ionic 3 and need to manipulate data in sqlite. The current problem is the following, I run a SELECT in a table and store the return in an array (this.list_off) created in the…
-
0
votes1
answer57
viewsSqlite database
Opa galera I’m trying to "play" with a database in android studio. I created this code below... when I run it the simulator opens the already closes alone soon after. I include the log. i in the…
sqliteasked 5 years, 11 months ago Thiago Cordeiro 3 -
0
votes1
answer51
viewsHow do I manipulate a date in an Edittext to add up to 1 day?
I receive in an Edittext a date and I need that when pressing the renewal button this date is increased 1 day. package br.edu.unp.bibliotecavirtual.view; import android.content.Intent; import…
-
0
votes1
answer41
viewsWait for consultation with the bank to give feedback
I’m making an appointment with Sqlite Bank. But the function ends up giving return before the consultation is performed. I am trying to solve this using a type of control while the query does not…
-
0
votes1
answer26
viewsLaravel Sqlite migrate error
When running the Migrate command it gives this error: code of the first migrate: ` public function up() { Schema::create('contatos', function (Blueprint $table) { $table->bigIncrements('id');…
-
0
votes0
answers39
viewsSqlite Android 9
I’m having trouble working with my app on Android 9. On some devices that were Android 8 and have upgraded to Android 9 works, but on the devices that comes with a newer version of Android 9 factory…
-
0
votes2
answers162
viewsPRIMARY KEY AUTOINCREMENT - Android Studio Error
I’m trying to insert records with auto increment, but every time I get failure return. But if it’s auto increment he shouldn’t ask me for the fifth record? Database code: database1.execSQL("CREATE…
-
0
votes2
answers86
viewsProblem inserting data into Sqlite and updating Recyclerview
I’m having problems in my Sqlite bank where I created a method in my DatabaseController.java who is called recuperarUltimoDigitado() - this method retrieves the entered value and then updates the…
-
0
votes1
answer40
viewsDoubt - Query Sqlite
I’m having questions on how to write a query. Follow the problem information: I have 3 tables, the first being an athlete registration table (id, name, age, country...), a second table with…
-
0
votes2
answers235
viewsHow to Update to a DB Sqlite3 with POO?
I have a product registration program with everything working only I lack the update, I can update edit the data in the table and in the bank but it is not working right. It edits all the data and…
-
0
votes1
answer107
viewsFetch data from a JSON-shaped Sqlite table and send Webservice
Good morning guys, I’ve been in this problem for a few days... I know how to send an item from Sqlite to Webservice, but how do I send an entire table at once? Scenario: The user makes a stock count…
-
0
votes1
answer51
viewsListview repeats the last record inserted in Sqlite across the list
I’m learning how to develop mobile for Android using Java and started studies to persist data. Everything was fine until I tried to fetch the Sqlite data and insert it in a listview: the whole list…
-
0
votes2
answers1622
viewsWhere are the application files in the Android Studio emulator
I’m using the Android Studio emulator to test an application, so I’m using Sqlite to save some data, I want to know where the application files are and where Sqlite records, it would just be a…
-
0
votes0
answers27
viewsHow to recover an idUsuario(user_id) from an idAnuncio(ad_id) models by Discount(Discount) Discounts? REST API
I need to do a query to recover a User’s discounts(idUsuario = user_id) by the Discount models' numbers, however, discount is only related to an idAnuncio(ad_id), so it’s like recovering an id via…
-
0
votes1
answer60
viewsError "must exist" when creating registration in Rails 5.2
I’m creating a Teacher model that has a contact: ActiveAdmin.register Teacher do permit_params :name, :contact_id form do |f| f.semantic_errors *f.object.errors.keys f.inputs "Details" do f.input…
-
0
votes1
answer615
viewsCRUD in flutter
I have a doubt, I know what the problem is but I have no idea how to solve. In a crud I have a parameter idade which is int (defined as INTEGER in the bank) and I can not register in the bank but if…
-
0
votes0
answers29
viewsSqlite bank closed when query
Good afternoon, I’m making an android application, I’m having some problems with the bank. When it runs on the emulator it calls the seller’s Activity after saved, it calls login, login has a…
-
0
votes1
answer132
viewsDoubt in Javascript + Sqlite3, return of Select
Hello, I need to retrieve information from a bank and display on a table. I’m using Electron and sqlite3. I have this function to do the consultation. function getTable(){ var obj = []; var aux =…
-
0
votes1
answer226
viewsSet DEFAULT value with empty string and not as NULL in Sqlite3
I created a table on sqlite determining columns with value DEFAULT. The example column is "name_fantasy" and in it I informed that it would be DEFAULT '' (Empty string). When trying to insert a data…
-
0
votes0
answers36
viewsHow do I dynamically delete a Row with Flask?
Guys I have this code in HTML {% for row in rows %} <div class="card border-success mb-3" style="max-width: 18rem;"> <div class="card-header">{{ row['title'] }}</div> <div…
-
0
votes1
answer158
viewsAuthenticate user with SQLITE database
I’m needing the parameters used in the button to query the database (the code was the result of another post response) when trying to implement the function inside the baton I could not get it to…
-
0
votes1
answer58
viewsWhat should I put into parenthesis?
Hello I’m starting to program now and I was following a video lesson and following the teacher’s steps, however arrived in a part that he installed the sqlite, however his version was previous to…
-
0
votes1
answer77
viewsIs my SQL code okay?
I’m learning SQL, and my teacher gave me an activity, I did it, but he gave me 1 grade. I want to know if the code is right. CREATE DATABASE escola; USE escola; CREATE TABLE aluno ( codigo INT…
-
0
votes1
answer62
viewsHow to place the value of an input inside a "cell" of a SQLITE3 table, with Python?
Hello, I’m a beginner in programming and, learning about the SQLITE3 library, in Python, I came across a problem and even after a lot of research I did not find the solution. I would like to be able…
-
0
votes2
answers34
viewsLogic for SQL statement - Sum of values between Table A and Table B
To table A is the table that receives several rows containing different values related to table B which is where the items are stored. Table A Descrição | Valor item 1 | 50,00 item 1 | 40,00 item 2…
-
0
votes1
answer20
viewsNOT IN/EXISTS in more than one table in the same query
I have a table of employees and I need to extract from it a query of employees who are not registered in any of the positions (architect, landscaper and manager). The column COD of employee is the…
-
0
votes1
answer127
viewsSave a PDF to Sqlite
I’m beginner and I’m having trouble saving the pdf in the bank, I don’t even know how I can do it. botaoBusca.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) {…
-
0
votes0
answers36
viewsError while deleting SQLITE base and create again dynamically ANDROID 9
I have an android Java app running for years. After migrating to android 9 (API 28), I’m having problems constantly: database disk image is malformed (code 11 SQLITE_CORRUPT) and Android…
-
0
votes0
answers52
viewsCorrupted Sqlite on Android 9 Pie (API 28)
I have an Android Java application running for years. After migrating to Android 9 Pie (API 28), I’m having the following problems constantly: database disk image is malformed (code 11…
-
0
votes1
answer32
viewsFind the year in which total customers (sum) was higher
I’m using sqlite, and I have a table like: year | clients ---- | ------- 2000 | 1 2000 | 2 1999 | 3 1999 | 5 2000 | 4 1999 | 6 This is just one example. I want to find the year when the total of…
-
0
votes1
answer199
viewsSystem.Formatexception: 'String not recognized as valid Datetime
Hello, I am trying to update data from a row of a db sqlite, however I am having problem in a date field. I enter data in the Registered field with the following code, where Tb_data_registered is a…
-
0
votes1
answer39
viewsC#: Sending data to database (Sqlcompact)
I’m starting now with C# due to the need where I work, I took a project until it was flowing, however, I’m having great difficulty sending the data to the database (a part of the code another person…
-
0
votes2
answers36
viewsProblem showing id on home screen when using sqlite in android studio
i am developing an app in android studio where it shows the id and name of an anime q comes from the database when making the anime registration on the anime registration screen, however when…
-
0
votes1
answer57
viewsDynamic Form with Flask
Hello, I’m creating a website that consists of a teacher creating a quiz and sending it to students to answer, but I’m not finding a way to get the teacher to ask as many questions as he wants. At…
-
0
votes0
answers13
viewsCapture user date and move on to be selected with BETWEEN Sqlite, Android Studio
Personal I am trying to carry out the selection of a list of data in the database Sqlite, using the following code snippet, the selection in the form that is made below is already working well.…
-
0
votes0
answers38
viewsHow do I insert previous tuples into tables in a Sqlite3 database?
I’m developing an RPG-style app using Android Studio. This app needs a database and as there is no need to be online, I am using Sqlite 3. The problem is that some data need to be previously entered…
-
0
votes1
answer75
viewsIf/Else block not working in Javascript
I’m starting in Javascript and I’m creating a Whatsapp bot on Node.js and any block if that I put does not work and always goes to else. It works that way: Get the message; Query the Sqlite database…
-
0
votes1
answer164
viewsState Management with Flutter
Good afternoon, I have a problem, I have my code below, and in it I do the following, when it opens the screen for the first time it searches data from an api and saved in the database. Soon the…
-
0
votes1
answer51
viewsSqlite database conflict when merging into git
I’m working with someone else on a Django project and she owns the main repository. I have a Fork from this repository and want to update it with the original. I created the upstream: git remote add…
-
0
votes1
answer26
viewsinsert data date sqlite - java
Hi, I am trying to pass a date set by the user to the database, but whenever I click add the application crasha and I have the following error: java.lang.Illegalargumentexception: Cannot format…