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
answer2246
viewsBest Database for Android Application
Guys, I have a question on which bank to choose for an android application: Sql Server or Sqlite? I have a little Crawler, which doesn’t need to run every time, just once, and when there’s some…
-
0
votes1
answer46
viewsNullpointerexception when query in Sqlite
I have a problem that is seriously damaging the development of my application. It aims to draw a question (not implemented yet, I’m using a fixed value for the question id) through a query in…
-
0
votes1
answer82
viewsCreate themes in the Android app
Guys, it is possible to customize the color of the action bar on Android, because I’m developing an application and I wanted users to be able to choose the color of the application they like best.…
-
0
votes1
answer657
viewsimport image from gallery - android
Eai personal, I need help with my application, I have q select an image from the gallery, make it appear in an imageView and save it in the database(sqlite), so q the person can exit the application…
-
0
votes0
answers55
views -
0
votes0
answers46
viewsQqlite + HTML5 put results into variables
And I’m doing a query in a Sqlite database and wanted the result to be stored in a javascript variable so I can work with these results in the rest of the code. I’m doing like this:…
-
0
votes1
answer444
viewssort the dates in the bank
I’m having the following problem, I can’t sort in ascending order the dates that are saved in the bank, I’m using order by no select but just sort the first two houses until I get to / causing the…
-
0
votes1
answer812
viewsno such column _id (code 1) while compiling - SQL
I’m having trouble with my code, could help me. Follow the error below and soon after, the codes. But to simplify, I have a home screen and let me go to another to register and then I can go to…
-
0
votes2
answers86
viewsNeed for Sqlite
I want to clarify the following question: I have a project Android who uses a webservice, but I did all the data access on Android and my webservice will be done in Java. After I finished all the…
-
0
votes2
answers993
viewsShow SQLITE data between dates - Android Studio (think be between)
Good, I want the user to choose the data to show between the dates he chooses. I’ve tried everything but still can’t. That is what I want to filter between dates, but the user has to choose them. I…
-
0
votes0
answers309
viewsRead sqlite table and insert content in listview
I’m trying to insert the contents of a table into sqlite within a listview. The table in Sqlite is already filled, the listview was being filled with result of webservice, which also works ok, but…
-
0
votes1
answer784
viewsIs there any way to change a column from an existing table to "auto increment"?
I created a table in Sqlite3, but forgot to add AUTO INCREMENT in the column id. I tried to use ALTER TABLE to solve the problem, but I haven’t been able to. In SQLITE, it is allowed to set a column…
-
0
votes1
answer471
viewsTransfer data from SQL Server to Sqlite with Android
I have a software that is connected to an SQL Server database, but now I am making the software on Android using Sqlite. I need to transfer the SQL Server database (with the data) to my Sqlite.…
-
0
votes1
answer576
viewsError: java.lang.Illegalargumentexception: column '_id' does not exist
Good people, I was developing an app in order to learn where the goal was to register users in an Activity and another to be able to view all registered users through a listview. It turns out that…
-
0
votes0
answers41
viewsHow to know when the Sqlite query ended?
In my app I have a synchronization method, this method downloads several entries from my webservice and inserts them into the local Sqlite database through a for loop. I need to know when the Sqlite…
-
0
votes0
answers70
viewsFilter Data to Database
Good afternoon, I have a problem that I hope someone can help me with. I needed to pass about 700 entries to a database (in this case Sqlite Studio) but I can’t find a way to filter those 700…
-
0
votes1
answer752
viewsWhere are Websql databases saved in Chrome?
I wonder what is the directory of the databases made in Websql, IE, where I can find the database file. Thank you.
-
0
votes0
answers338
viewsQuery Like on Android Sqlite
I’m trying to do a query like on sqlite. Cursor cursor = database.rawQuery("SELECT nome FROM Armas WHERE nome LIKE ?", new String[]{name}); That String I pass like this: data =…
-
0
votes1
answer40
viewsImageview error cannot be converted to Byte[]
I am mounting an application to which you want to save the image in the SQLITE Database. I am not able to proceed because the following error occurs ImageView cannot be converted to Byte[] I ask to…
-
0
votes1
answer714
viewsError saving SQLITE: table .. has in column named
Error when saving the image path in SQLITE. Says it does not have a column named pathImage in the products table attached to the image with the error for better understanding. My Dao Product Class:…
-
0
votes1
answer108
viewsParallelism with Angular 2
I need to insert 30,000 records into the device (in Sqlite) through a file. But at the time of insertion, the application hangs. So I thought about creating an asynchronous service, but I don’t know…
-
0
votes2
answers1011
viewsupdate method (sqlite) does not update database data
I have a listview that displays the items of the database with an update button, this button calls the screen with the values set in editText, I edit, click save, it returns me the updated message…
-
0
votes0
answers61
viewsSqlite database creation on smartphone
I’m having doubts regarding the creation of the bank in Sqlite on the smartphone via USB. When I run my program on emulator, the bank works perfectly and smoothly. But I realize that when I do the…
-
0
votes1
answer601
viewsdisplay listview in the same Activity after consultation
I have this consultation layout with a Listview: After marking the RadioButton and write the search parameter would like the list to appear with the database data (detail, I have a Listview that…
-
0
votes1
answer96
viewsProblem with Sqlite in Asynctask’s onPostExecute method
I’m having a problem running an Sqlite function in the Asynctask onPostExecute method. When I implement the same function in Activity it runs normally, but in onPostExecute it doesn’t even enter the…
-
0
votes1
answer51
viewsSqlite shared between android Flavors
Hi, I’m looking to make a paid ad-free version of my app that is already published in the play store. I wanted that if a person buys the paid version he does not lose all the data already registered…
-
0
votes1
answer124
views -
0
votes2
answers426
viewsReturn when the function is over
How to return to alert("SUCESSO") as soon as you fall into return alert("ELSE");? sincronizar: function () { sincronizarCliente().then(function () { alert("SUCESSO"); }, function () { alert("SEM…
-
0
votes2
answers197
viewsAccording to Like does not work Sqlite
Good, when doing a query: Cursor cursor = database.rawQuery("SELECT nome, imagem, descricao FROM Marcas WHERE descricao LIKE ? OR nome LIKE ?", new String[]{name}); It only returns results through…
-
0
votes1
answer88
viewsSqlite no longer runs android - app
I have a problem in my app, the sqlite apparently is not running. All functions related to it are not working, in this application I use some external mysql based functions these are "ok". See below…
-
0
votes1
answer129
viewsProblem with tablayout and sqlite
Hello guys I’m reformulating an app and includes in the main Activity a tablayout that inflates two Fragments. An Fragment should present on a cardview all data stored in the database. Scrolling the…
-
0
votes2
answers2211
viewsHow to make INNER JOIN between tables on android Sqlite?
I would like to know how to do a more elaborate query using INNER JOIN to join two tables in Sqlite for android. I know how to query using INNER JOIN in Mysql. What I want to know is how to make…
-
0
votes0
answers79
viewsHelp with login by SQLITE
I’m making a login simple here via Sqlite, but at the time of pressing the "Login" button, says that there is no ("Login Failed") everything is correct on the form; $sqlite = "sqlite:teste.db"; $pdo…
-
0
votes1
answer44
viewsHow to send a Stringbuffer select to a class
I don’t know how to send one select made in my Databasehelper class and send it to a public class, then from that make my code work normally. My Databasehelper class and at the end select: class…
-
0
votes1
answer29
viewsRemove values for SQL file not working
I have this code, which takes Strings and puts them in a Database, but the problem is that it is creating Database but I don’t know why , it is not inserting the values in it. Below I leave the xml…
-
0
votes1
answer27
viewsDo not add to database when some value is null
How do I not add to the database when the String dia is null ? Code : public boolean insertData(String disciplina,String sala,String dia,String hora){ ContentValues values = new ContentValues();…
-
0
votes1
answer66
viewsHow to select by the bank the value of the column using the Random() method
I made a project on Android that is a little hangman game, where I can record in the Sqlite database the word and a hint. In my Databasehelper class I created the normal database, and made some…
-
0
votes1
answer134
viewsApp database does not delete
I have a problem. I created an app and it uses sqlite local database, the problem is the following, even if I cleaning the data and uninstalling the app, when I install it again, it recovers the old…
-
0
votes0
answers1569
viewsConsult a record on Sqlite
I’m having a problem to perform a query in a Sqlite database of an android application I’m studying. I can recover all the records that the database contains, but I can’t search a single table…
-
0
votes0
answers41
viewsFailure to perform Sqlite Insert
When executing this code snippet, returns the error below. What can be the cause? public class LivroDaVendaDAO { // sqlite private ConexaoSQLite sqliteDataBase; // nome da tabela de livrosDaVenda…
-
0
votes1
answer333
viewsERROR : Cursorindexoutofboundsexception
public boolean insertData(int id_pedido, int id_item, String nome, int quantidade) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues contentValues = new ContentValues();…
-
0
votes1
answer98
viewsHow to create a Products table that has several prices?
Someone would know how to map a Products table, and the product has different prices for each type of parcel the customer chooses. For example I created a table called PRICES and in it there is FK…
sqliteasked 8 years, 3 months ago Angélica Flausino 182 -
0
votes1
answer72
viewsIntegrity breach not released in BD Sqlite
CRUD in C# is not throwing integrity breach error while deleting BD Sqlite dependent record. query = "DELETE FROM "+ table + " WHERE id = '" + id + "';"; int returnValue = 0; try { conn = new…
-
0
votes0
answers72
viewsHow to turn a Cursor into a String?
Hello, I need to figure out how to turn a Cursor with data coming from the Android Internal Database (Sqlite) into an Array of String or String. I’ve tried it a few ways, but none of it worked.…
-
0
votes1
answer406
viewsHow to order records correctly using DISTINCT
In my table I have the column DESCRICAO and the DATA_DE_CADASTRO of the items. In my Android application I would like to display the last 10 records that were recorded. There are a number of…
sqliteasked 8 years, 2 months ago Reginaldo Rigo 3,638 -
0
votes1
answer74
viewsHow to use aggregation functions in a WHERE?
I’m doing a college paper on databases, and one of the Query what I must do is this: Show all creditors who had a larger purchase total than that R$ 5000,00; I tried to: SELECT NomeCredor,…
-
0
votes1
answer1720
viewsRead data from an Sqlite 3 database in Python
I’m starting in Python and database and I have three questions! For example, inside my database I have a "name" column. Just to illustrate, say I want to take the contents of the "name" column…
-
0
votes1
answer198
viewsInsert data from a JSON into a Sqlite database with Angularjs
I’m trying to enter the data I took from my API, in the SQLITE database of my app, I already searched a lot but besides not being able to do also I could not understand how I can do this. Follow the…
-
0
votes1
answer99
viewsHierarchical database(?) - Sqlite/Android
Good afternoon, I’m starting to study Android and thought of making an app to already study together database. I want to make a "family tree", so that clicking on the person’s name (button) would…
-
0
votes2
answers416
viewsList always returns only the first row of the sqlite database
I have a list, which shows all the data of the sqlite database, image path, latitude and longitude, but in the list only changes the image path, latitude and longitude always remains those of the…