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
votes0
answers543
viewsListing BD data using SELECT and ORDER BY
Doubt There is a screen with an Edittext and a Button. When entering any information in Edittext and selecting the Button the system should redirect the information from Edittext to an Activity and…
-
1
votes2
answers661
viewsDatabase - Sqlite
I am developing an application that needs a database, I chose Sqlite. As I am new and have no experience in Sqlite I have come to ask you: How can I create a database with Sqlite and React Native?…
-
1
votes1
answer188
viewsIncompatibility of type blob and byte sqlite
I’m making an application to save the image in sqlite. But you are acknowledging the following error in my dao class: incompatible types byte cannnot be converted to byte. My Classes: import…
-
1
votes2
answers6375
viewspython Manage.py syncdb does not work!
When trying to follow a tutorial I can’t go on because the bank wasn’t set up, you can help me? Error: Unknown command: 'syncdb' Type 'manage.py help' for usage.…
-
1
votes2
answers1210
viewsQuery between two sqlite tables
My question is how to make a query between two tables. Would be a table Pedidos with the countryside Idprod, idCliente. The other would be the table of Produtos with the fields Idprod, Descricao. I…
-
1
votes2
answers573
viewsHow to search a table by date and add values contained in it?
It’s the following guys, I’m having a lot of trouble creating a search by date in my android sqlite database. I wanted to search the tables by date, if possible, I wanted to make a condition that…
-
1
votes0
answers216
viewsHow to Insert on Android?
Using Sqlite and Android Studio how to INSERT ? Let’s use as an example a table with the following data: String name Age int Double media Using different data types;
-
1
votes0
answers59
viewsError trying to enter data in mobile database (Android Sqlite)
I am trying to insert 864 objects in the mobile database. I can enter up to 450, but then generates an exception: System.Argumentexception: Busy. Does anyone have any idea what might be going on?…
-
1
votes1
answer548
viewsOpening a database in Sqlite instead of creating in Android Studio
Hello, I would like your help if there is a possibility to open a database. db (instead of creating the file) by android studio using sqlite. I’ve already created a data file. db with the data and…
-
1
votes1
answer55
viewsHow to represent in the database (android sqlite), a class that extends another?
Hello, I’m working on android, I have a case where a table extends another. example: table Exercise -> String dataInicio, String description ...... etc table Football -> String timeInicio, Int…
-
1
votes1
answer198
viewsHow to resolve Sqlite auto increment gap?
I have a code that erases one Row whole of a database, but there is a problem because I get a hole getting an ID without data (what I deleted) for this being autoincrement, does not delete the ID…
-
1
votes1
answer54
viewsWhich type to use to store values that are in an Arraylist<> in an Sqlite table?
I have the following table in Sqlite: db.execSQL("create table amc(_id integer primary key autoincrement, nome text not null, contratada text not null, tipo text not null, data text not null,…
-
1
votes0
answers59
viewsSqlite PHP Injection
Hey there, guys! I am currently using sqlite in a personal project and am using this class: https://github.com/TimOliver/PHP-Framework-Classes/blob/master/db.sqlite.class.php When I use its query…
-
1
votes1
answer672
viewsInstall only the app without overwriting the sqlite database that is already being used
I am developing an application using Delphi Tokyo for Android. But by always compiling it takes the database from sqlite and about writing the that is already there full of data. As this app goes to…
-
1
votes1
answer649
viewsE/Sqlitelog error: (1) in such column
I’m getting a bug in my code and I can’t seem to fix it, I wonder if you could give me a little help? I’m getting the bug "E/Sqlitelog: (1) in such column": 09-27 04:04:14.798…
-
1
votes1
answer71
viewsError trying to save result to database
I would like to record the contact name and contact number in the bank. So I can use it in other activities. But, when returning, from the contact screen to the Activity in question, an error…
-
1
votes1
answer32
viewsProblem with sqlite and boot receiver
I have an application where the goal is to put the name of a stop and after the reboot to android device receive the name of that stop in reboot receiver My boot receiver is working because I have…
-
1
votes1
answer47
viewsHow to view and maintain an Sqlite database
Hello, I have recently started to study the Sqlite database and I would like to know if there is a way to view my tables and the database structure itself in full, equal to pgAdmin and Mysql…
-
1
votes2
answers351
viewsError returning Android Cursor
public boolean insertData( int id_item, String nome, int quantidade) { String preco_unitario = "0"; String id_pedido = "0"; SQLiteDatabase db = this.getWritableDatabase(); ContentValues…
-
1
votes1
answer181
viewsHow do I install Sqlite on Android?
How do I install Sqlite on Android? I downloaded the program and there is no installer on it. What do I do? I downloaded it from PC and not smartphone.
-
1
votes1
answer64
viewsHow to get the result of two sqlite tables
What I want to get is Currencies that belong to a particular country Name. Parents, code.Currencies, name.Currencies, Symbol. Currencies SELECT * FROM moedapais where alpha2Codes = 'AL'; SELECT *…
sqliteasked 6 years, 11 months ago Amadeu Antunes 3,331 -
1
votes1
answer75
viewsInsert or replace does not work
The command INSERT OR REPLACE INTO SYSVAL ( CDDEVICE, DTVALINI, DTVALFIM, SALDO, REALTIME, VALIDADO ) VALUES( '34322910071833580','31-08-2016', '31-08-2016','10','63714560','S') works smoothly on…
-
1
votes1
answer110
viewsSqlite check if data already exists
Hello I have an application where when logging in if you have internet connection it should bring the data from the web service and enter in the bank. So far so good, but my doubt is as follows:…
-
1
votes0
answers612
views -
1
votes1
answer70
viewsProblem with android UPDATE
I got a problem when it comes to giving update in a table on Android/SqLite: I tried both ways I found: String query = "UPDATE MY_TABLE SET VALUE1='VALUE1'... WHERE KEY_ID = KEY_ID" SQLiteDatabase…
-
1
votes2
answers2528
viewsFind Sqlite Database on Android
Next, I’m creating an application for Android, where I use a local Sqlite bank, never gave any kind of problem of registration or database query, so I never had to take the bank direct in the…
-
1
votes1
answer324
views"You must call Xamarin.forms.init() prior to using it" - Problem trying to access sqlite data
Hello, I’m a beginner in mobile programming and I’m committed to a project PCL Xamarin with Xamarin.Forms. The application uses alarms and for this I use dependency injection to access the native…
-
1
votes1
answer149
viewsUpdate on sqlite does not update data
Hello, someone could help me ,the update is not updating the data! Follow the button that calls the method: @Override public void onClick(View v) { Receita rec = new Receita(); String dosradio =…
-
1
votes2
answers539
viewsData synchronization on android
So, I’m in a project that needs to save a large mass of data coming from a json api on android’s Sqlite, something around 20 thousand records, in order to be able to work offline without problems.…
-
1
votes0
answers31
viewsError in single Sqlite database query using Provider content
I am having a problem that when trying to make a query in the database of my application through Content Provider. When the attempt to query the database starts the application breaks.I did tests…
-
1
votes1
answer11
viewsHow to use the AS operator with the Library Room?
I’m not getting the variable total, how do I do? @Query("SELECT SUM(item_valor) AS total FROM Itens WHERE total =>:data") Itens getMes(String data); The IDE warns syntax error in the full…
-
1
votes0
answers17
viewsError picking Phase name - IONIC
Good evening, I am developing an app in Ionic, I created the function to check the correct answer, but in the line that would appear the area being displayed…
-
1
votes1
answer70
viewsAndroid ormlite
I’m having a problem recording a login in the database, when I call create it returns me Null, what could I have done wrong? Remembering that when I give a LOG to see the login, it shows me the data…
-
1
votes0
answers220
viewsFormat a Decimal Type Field and Inlcuir in Xamarin Sqlite Forms with Android
Hello to the Masters of Xamarin Forms, I have a little problem, for you maybe very simple. I am not able to format a decimal type field in monetary value and then do the same Insert in Sqlite. Below…
-
1
votes1
answer342
viewsSqlite filter as date return error with strftime function
Hello I have the error in the following code SELECT L.*, C.DESCRICAO AS CATEGORIA , CASE WHEN L.TIPO_LANCAMENTOS = 'C' THEN 0 ELSE 1 END AS ICONE FROM LANCAMENTOS L JOIN CATEGORIAS C ON(C.CODIGO =…
-
1
votes0
answers250
viewsIs there a Sqlite PHP simultaneous connection limit ?
I currently use Mysql on my server with a limit of 50 simultaneous connections.. thought to use SQL Server which in turn has no simultaneous connection limit but is very expensive!!.. So I thought…
-
1
votes1
answer174
viewsError in getWritableDatabase()?
I’m doing a job for college. My project until a few minutes ago was working normally, inserting User and Book, but out of nowhere it started to give error in getWritableDatabase() and I have no idea…
-
1
votes0
answers38
viewsPopulate Jsonarray with Sqlite3 data
I have a code that is to send my Android data to PHP in JSON, to save in Mysql. But I’m sending one at a time, I want this code to send one JsonArray at once. Method that sends data by parameters to…
-
1
votes1
answer528
viewsSelect and calculate columns - Sqlite
Hello... //selecionar valores da tabela: public Cursor IMC(){ Cursor cursor; String[] campos = {"SELECT (peso/(altura*altura)) FROM medidas WHERE codigo = (SELECT codigo FROM medidas ORDER BY codigo…
-
1
votes2
answers4016
viewsCreating more than one Android Studio table (Sqlite)
I’m trying to develop a mobile app for a final job of my college, it’s pretty simple! The application has to save the information registered in the database. However I would have to create 4…
-
1
votes0
answers345
viewsSqlite: Unable to open database
Application using Ionic/Cordova (Sqlite). I’m using the $cordovaSQLite plugin inside the app. When I save, modify something in the project, the simulation in brownser (Googlechrome) is extremely…
-
1
votes1
answer174
viewsDelete function of my table
I wonder why you’re giving this trouble. I created a function to delete the table from my database and instated the button to perform this function, but when I go to test it presents me an error.…
-
1
votes2
answers144
viewsInner Join Sqlite with Cursor on Android
Good morning guys, could you ask me a question ? How should I make one Inner Join in the SQLite using the Cursor ? Below is my code, but I do not know how to fit it in the line. final SQLiteDatabase…
-
1
votes1
answer601
viewsHow to synchronize auto increment keys between different databases in Firedac?
I am researching how the auto increment fields work in Firedac, using Delphi xE7 and managed to assemble an example of the documentation that synchronizes two master-details tables with the correct…
-
1
votes2
answers146
views -
1
votes0
answers163
viewsMapping issues in Microsoft.Entityframeworkcore
I am trying to create in a class two Mappings Manytoone using the Entity Framework, but I’m not succeeding, if I take either of the two mappings and leave the other, it works but if I leave the two…
-
1
votes1
answer111
viewsCalculate sql table in android
I have the following sqlite database and works well: db=openOrCreateDatabase("BaseDadosDB", Context.MODE_PRIVATE, null); db.execSQL("CREATE TABLE IF NOT EXISTS tabeladados(data date,total…
-
1
votes2
answers162
viewsI cannot enter data in Sqlite Table
I want to insert some data into my Sqlite table. Table creation in . app $cordovaSQLite.execute(db, "CREATE TABLE IF NOT EXISTS tbprodutos( id INTEGER PRIMARY KEY, codbarras NUM, desccupom TEXT,…
-
1
votes1
answer112
viewsError when viewing or adding SQL data
Good afternoon guys, I was trying to make an sql to put the score obtained in a game I’m developing, but when I put to save the score, or even see the score it gives error, I will put an asterisk on…
-
1
votes1
answer1243
viewsFill spinner with Sqlite data
I have an application with Sqlite, I make a select to return the values of a field and save it in a variable. I wanted to use these values in a spinner, but it is not getting in the list but all…