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
-
2
votes1
answer195
viewsHow to make a "for each" on Sqlite
I have an A table with n records. For each record of this table, I want to get information from a field x to make a select and, based on the results of select, make a insert in a table B. Only I…
-
2
votes1
answer1293
viewsDelete database when uninstall app
In my app I create the database done in Sqlite in the folder: System.Environment.Specialfolder.Personal But on some devices (Android) when uninstalling the app it seems that the database continues…
-
2
votes1
answer243
viewsproblems when passing data to Edittext Android
I’m having trouble loading data from an sqlite table and sending this data to Edittext, which I may be doing wrong, when I open the screen returns this message in the log Cat 11-03 06:43:30.721…
-
2
votes1
answer607
viewsno such table: tbcarro
After following some examples, I am doubtful about the following error: 11-24 20:49:14.803 18215-18215/tiburski.rg.cadastrocarro E/SQLiteDatabase: Error inserting nome=ggggg modelo=ggggg placa=hhhh…
-
2
votes2
answers1290
viewsError: android.database.sqlite.Sqliteexception: no such column:
I added a column in the Users table, invited is an integer. I need to make a select in the table filtering this field, and I get the following error: android.database.sqlite.Sqliteexception: no such…
-
2
votes2
answers226
viewsLaravel and Sqlite database
Think of me, you have server Laravel with a Sqlite database configured, access to this database in thesis is to be faster, since it is on the server itself. Follow the example: user -> server…
-
2
votes1
answer204
viewsHow to create a compound index in Sqlite via Microsoft.EntityFrameworkCore.Sqlite?
I’m trying to create a unique composite index, but I don’t know how to do it on Microsoft.EntityFrameworkCore.SQLite, I’m used to working only with the Doctrine and Hibernate and I’m totally lost.…
-
2
votes2
answers2553
viewsError saving Sqlite Data (in such table)
Databasehelper class: public class DatabaseHelper extends SQLiteOpenHelper { private static final String BANCO_DADOS = "MakeRequestApp"; private static int VERSAO = 1; public DatabaseHelper(Context…
-
2
votes1
answer345
viewsHow to join records from a table distributed in multiple . sqlite files?
I have several files with extension .sqlite, containing every 1 at least 1000 records thus totaling about 4,000 records. See how they are distributed: vihicles1.sqlite vihicles2.sqlite…
-
2
votes3
answers2965
viewsHow to delete data from database in android studio?
I have an application where when the user logs in the first time, I save the Token and NIU, then the next time he accesses the application, he already enters directly into the Webview using that…
-
2
votes1
answer1838
viewsError while performing findviewbyid
Hello, I want to find the id of two Textviews, but they are returning NULL. Follows my code: private TextView nomeUser; private TextView cargoUser; @Override protected void onCreate(Bundle…
-
2
votes1
answer246
viewsNumerical accuracy in Sqlite
About numerical accuracy in Sqlite v3.20.0. See the sequence of commands below and the result of .dump. The value associated with the INSERT declaration is not the same value obtained. I enter the…
sqliteasked 7 years, 2 months ago Vítor Luís 21 -
2
votes2
answers504
viewsQuery with android sqlite java filter
public ArrayList<Contato> filtrar(String filtro) { ArrayList<Contato> contatoArray = new ArrayList<>(); //Consulta que traz todos dados de todas colunas Cursor cursor =…
-
2
votes1
answer173
viewsSqlite - Too Many levels of Trigger recursion
I’m getting the error below when I try to make an insertion in Sqlite. Error while executing SQL query on database 'BDTESTE': Too Many levels of Trigger recursion Table creation CREATE TABLE…
-
2
votes1
answer29
viewsHow to insert a data in your respective Acitivity via Sqlite
Guys I’m making an app on android and inside it has a listiView fixed sent by a string array for example String[] servicos = {"Eletricista", "Pedreiro", "Pintor", "Encanador", "Arquiteto",…
-
2
votes1
answer81
viewsAutoincremet on Sqlite is not working on Android
Autoincrement is not working on my Sqlite tables. Table: db.execSQL("create table usuario(_idUsuario integer primary key autoincrement, nome text not null, email text not null, senha text not…
-
2
votes0
answers260
viewsCannot load driver class: org.sqlite.JDBC
I’m trying to set up an access from my application to an Sqlite database using the file application.properties Spring Boot, but not recognizing the driver. How can I proceed so that when booting…
-
2
votes0
answers83
viewsSqlite recursive query
I’m starting with sqlite and would like help with a recursive query. I have 3 tables (generic example): CREATE TABLE IF NOT EXISTS tab_componente ( id_comp TEXT NOT NULL PRIMARY KEY, desc_comp TEXT…
-
2
votes2
answers436
viewsSQL parameter in PDO PHP does not work
The following code returns 11 records from the database: $dbh = new PDO('sqlite:db_coleta.sqlite3'); $sth = $dbh->prepare('SELECT * FROM ROTA_VIEW WHERE usuario_id = 1 AND 0 = 0');…
-
2
votes1
answer146
viewsPass database content from one page to another
It seems to be something simple to research, but I’m not getting it. I would like when clicked on a list item, to open a new page with the detailed information of that item, will be the same…
-
2
votes0
answers280
viewsFlask not creating Sqlite database via Slqalchemy
Good afternoon to all! No way my code is creating the database via SQL Alchemy, follow the code snippet. from flask_sqlalchemy import SQLAlchemy app = Flask(__name__)…
-
2
votes0
answers76
viewsHow to use Sqlite in CLI applications written in Dart?
I’m testing the Dart to discuss its feasibility in replacing part of the code base in Java. I didn’t find anything similar to the JDBC specification in Dart, so I’m guessing the language doesn’t…
-
2
votes1
answer209
viewsError while creating tables simultaneously in sqlite database
I’m developing a mobile application that saves data from a form in the local database, using the sqlite. Only every time the database is reset or changed its version it returns me an error that…
-
2
votes0
answers55
viewsPHP error with PDO and SQLITE, Call to a Member Function execute() on bool
Hello, can anyone see why this error is apparently all right function verificarImportados(){ define("DB_DSN", "sqlite:host=localhost;dbname=dbXML.db"); define("DB_USERNAME", " ");…
-
2
votes2
answers88
viewsClause error Where SQLITE
Hi, I have a small problem in the following method: Future<List> getAllTarefasMediaPrioridade(String status) async{ Database dbTarefas = await db; List<Tarefas>…
-
2
votes0
answers36
viewsTrigger after Insert SQLITE
Hello, I have a table of activities (for Deposit or Withdrawal of a piggy bank app) is inserted ID (PK automatica), value (double) Day (Text) type (can be 0 - for deposits / 1 - withdrawals) and…
-
2
votes1
answer53
viewsDelete repeated lines
Good morning, I have a table "Patient" with the columns (NO, Event, Glycozyme, Name, Glycemia, Date, Reading), which is the best way to delete all the repeated lines? Looking on the internet I tried…
-
1
votes2
answers864
viewsHow to get the registry ID that is populated in Listview
How do I get the Listview ID? Follow my shorthand code: UPDATE How do I get the REGISTRY ID that is populated by Sqlite in Listview. public class MainActivity extends ActionBarActivity { private…
-
1
votes1
answer1413
viewsError - in such column
03-21 07:25:47.740: E/SQLiteLog(796): (1) no such column: name1 03-21 07:25:47.750: E/data(796): Error while searching contacts: android.database.sqlite.SQLiteException: no such column: name1 (code…
-
1
votes2
answers287
views -
1
votes1
answer1387
viewsInsert into two tables in Android Sqlite
How do I add data to two tables on Android in a single transaction? I have two tables Client and Address, is last with a foreign key referencing the client table, and must be registered in a single…
-
1
votes1
answer148
viewsList data from two tables in the tableView
What do I do to list two table data on tableView? Sqlite Database(Example): tb_venda tb_produto tb_valor tb_cliente_id (Id do cliente "tb_cliente") tb_cliente tb_cliente_id (id primary key) tb_nome…
-
1
votes1
answer2919
viewsTake data from BD Sqlite without using Listview
My code needs to take the data from the database, in short only the following commands are missing: if (cursor.moveToNext()) { Contato contato = new Contato();…
-
1
votes1
answer1437
viewsHow to return a string from the method that queries Sqlite?
How to make a method that returns a string with a single result? I’m trying something like this: public String getString(String var) { String selectQuery = "SELECT * FROM "+TABLE_STATUS+" WHERE…
-
1
votes1
answer278
viewsUse Core Data or another API to interact with sqlite?
I was researching how to save data on iPhone and iPads and came across many options, each with its complexity and purpose. Apple recommends that whatever the app, use Core Data, which is nothing…
-
1
votes1
answer4434
viewsCheck if it contains Data in Sqlite table
How to check if an Android Sqlite table contains data?
-
1
votes2
answers3645
viewsHow to pass data from an Sqlite table to several Edittext fields
How to take the data from a table and present them each in one EditText? I’m developing on Android. Here I do the List of the data I need: public List<ConfiguracoesSistema>…
-
1
votes1
answer236
viewsPROBLEM WITH SQLITE - View with several selects
I have three tables that I have to take a dice in each to make an algorithm in the app, only I would like to know if there is a view that brings me this three data that are in the different tables.…
-
1
votes2
answers3071
viewsPass information from a selected item in the list to Edittext
Hello, I’m in trouble when I select a client in a Listview, I have to pass his name to a Edittext of the other Activity and pass the address also. But when I select the Customer he is grouping the…
-
1
votes1
answer836
viewsImport PHP CSV file
I have a CSV file with contacts. I want to import these contacts into a sqlite database. How can I read the file and insert it into the database?
-
1
votes1
answer59
viewsHow to delete a record without affecting the query?
I have two tables PRODUCT and CUSTOMERS. I am using Inner Join to link them in my consultations. I call the product and it displays the product, picks up the customer from the CUSTOMERS table and…
-
1
votes1
answer72
viewsPredicate with CAST
Accessing the database .sqlite via sql normally I can use the function CAST('coluna' as decimal). Via NSPredicate using CoreData, how do I do the same thing? I have a column like String and I need…
-
1
votes1
answer313
viewsProblem to the popular a Listview
I need a popular ListView that is using a custom adapter in my app but nothing happens, the list simply goes blank. Here is the adapter: package adapters; import java.util.List; import…
-
1
votes1
answer148
viewsKeep object alive in memory for another class
Hello! I have a very simple doubt, because I have already found a solution for it, but it still seems problematic. I will explain: I created a connection with web service to receive some data, and…
-
1
votes1
answer224
viewsList tables with specific column
I am creating an Android application using Sqlite and need to get a list of tables with a specific column as for example: SELECT table_name FROM sqlite_master WHERE table_column_map = 'imagem' It’s…
-
1
votes2
answers336
viewsAndroid: Problem searching last id inserted with Sqlitedatabase (ORM Lite)
I am having a problem executing a query (with Ormlite) that adds the return to 'ultimaConfiguration' in which you should get the last 'id' inserted in the Configuration table. the method that…
-
1
votes1
answer629
viewsRuby on Rails does not save to bank
Good night, you guys! I created a small form with two fields and in the future I intend to expand this form with one or two more fields. It happens that the insertion of the data in the sqlite is…
-
1
votes1
answer1986
viewsProblem Inserting Into SQLITE Table Using RAD STUDIO XE6
Good Afternoon, I have a problem in my code, use Rad Studio XE6 connected to a base SQLITE, when I insert values with point in the table occurs the following error for example = 'near "6.75":syntax…
-
1
votes1
answer144
viewsDatabase or disk is full?
This is an error on the hosting disk? If yes how to fix it? I am for some time suffering from it I sincerely hope that you answer me
-
1
votes2
answers387
viewsAdd all records before a specific date - Sqlite
I am wanting to add up values from several rows of my table (add up expenditure values) prior to a specific date (for example, add up all values that are lower than the date 2015-26-06). I’m using…