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
votes1
answer757
viewsImage in listview with Sqllite / Drawable
I have an app that does a corporate phone search on a Sqllite database. It’s working normally, but I need to get some image into some of these companies. The database field would be only the image…
-
1
votes0
answers152
viewsInsert with Inner Join and various conditions in Where clause
What is the best way to make one SELECT with INNER JOIN and with various conditions using Sqlite Android? I thought I’d do it this way: SQLiteQueryBuilder _QB = new SQLiteQueryBuilder();…
-
1
votes1
answer2186
viewsHow to release the data that are in the "date" folder of Android phone?
I’m making an app where I create the forms from database data, but nothing is appearing on my phone can only view in AVD, how do I release it?
-
1
votes1
answer2360
viewsSqlite relationship between tables
About relationship between tables: I tried to run the following code and Sqlite returns me the following error: table "Games" has more than one Primary key --…
-
1
votes0
answers193
viewsShow data from Sqlite table
When deleting a row from the database, when I refresh again, it does not show in a table that prints the rest of the rows, if it is deleted in the middle of the data. The problem is I have one for…
-
1
votes0
answers287
viewsPrevent removal of a sqlite bank on Android
Prevent sqlite database from being removed when uninstalling the application? I have an application that asks password for access, the password is recorded the first time the user starts the app…
-
1
votes0
answers288
viewsUsing external Sqlite in Assets folder with Fragment
I am using an external sqlite database, in the Assets folder. I followed that model (loading-a-bank-created-externally) and I was able to access the bank. How much testing worked normally on my…
-
1
votes1
answer254
viewsException when searching in Sqlite bank
12-10 09:25:36.029: D/dalvikvm(21543): VFY: replacing opcode 0x6e at 0x0002 12-10 09:25:36.279: I/Adreno-EGL(21543): <qeglDrvAPI_eglInitialize:410>: EGL 1.4 QUALCOMM build: () 12-10…
-
1
votes1
answer485
viewsIs Websql the only local storage form in phonegap/Ordova?
Outside the database created by "browser", what other forms of data persistence we have on android with phonegap?
-
1
votes1
answer894
viewsTake the id of the textview that is inserted in the listview and put in the bd
I have a layout with 2 lists, one complements the other, category and subcategory I would like, when inserting a subcategory by clicking add feed the database with the id of the category that is on…
-
1
votes1
answer1693
viewsGrab database ID when selecting option in spinner?
Usually I get the ID of a selected object/clicked with the onItemClickListener, but it does not work with the Spinner. I tried that way: spn.setOnItemSelectedListener(new…
-
1
votes0
answers185
viewsSqlite and Android database
Hello, I’m making a small app and need to search database data and display them on the screen. Databasehelper.java public class DatabaseHelper extends SQLiteOpenHelper { private static final String…
-
1
votes2
answers579
viewsHow to convert a date that is in string format in the database when doing a query?
I have a date that is in string format in the database "dd/MM/yyyy" and I needed to return in my query the dates from today. How can I do this conversion in the query to compare with today? Thank…
-
1
votes2
answers205
viewsCreate table in Sqlite with array
I am creating a Sqlite Database and I have 2 tables, a LIST table and other PRODUCTS. The LIST table beyond the fields ID numeric, NOME text, has a PRODUCTS ARRAYLIST. Already the PRODUCTS table…
-
1
votes2
answers380
viewsError in getWritableDatabase()
I’m trying to open the database to enter values in the class CadSalario, but I’m making a mistake in dbHelper.getWritableDatabase(); and I looked on the net and I have to call a context, someone can…
-
1
votes1
answer258
viewsWhat are the main programming languages that integrate Sqlite?
What are the main programming languages Sqlite as SGBD in your code?
-
1
votes1
answer164
viewsHow to use SCOPE_IDENTITY in sqlite
I have a mobile application that inserts a BD registration and I need to return the ID of this registration, but I do not know how to use and I do not know if it works SCOPE_IDENTITY in sqlite, my…
-
1
votes1
answer79
viewsHow to make a Seed.Rb by randomly searching Sqlite data in Rails?
Since I already have a register of cities and states, which you can see below, my question is the following, how can I place within the function 10.times in the lines of address_city and…
-
1
votes2
answers83
viewsWhy is there a 'Nsinvalidargumentexception' in this code?
I have a class that manages all my database, my project is in Swift but I have two classes in Objective-C to make the "bridge" between the classes and my Helper. After some testing in iOS simulator…
-
1
votes1
answer1143
viewsView BD Sqlite on Android Device Monitor
I’m trying to view my BD Sqlite on Android Device Monitor, but in the folder data, I don’t see any files to export and so I can’t see my BD. What could I be doing wrong?…
-
1
votes1
answer1358
viewsHow to save and recover a date field in Sqlite3?
The point is that on the Sqlite website itself says that for fields date is to use numeric type or string, all right with numeric I write in the bank the date without special characters, however in…
-
1
votes1
answer630
viewsEncrypt Sqlite3
There is a free way to encrypt Sqlite3 database? I’ve seen some pretty expensive proprietary software.
-
1
votes1
answer202
viewsPre-written database (Phonegap/Cordova + sqlite)
I am developing an App using Phonegap/Cordova and Sqlite, but along with the application it is necessary to go a database containing approximately 50MB of text information. I’m using the app…
-
1
votes0
answers117
viewsWhere the file is: I am developing with Ionic/Angularjs and Sqlite
I’m trying to open the database in Sqlitebrowser, but I can’t find the file created. I used the command : window.openDatabase The alias I gave is "my.db" but I can’t find it anywhere. Where…
-
1
votes1
answer165
viewsWeb Service for Android app
I have a question. Assuming I have a web service saving the data in Mysql, this service is responsible for feeding an Android app. The user accessing the app will sync the data to the device’s local…
-
1
votes2
answers858
viewsHow to check if a table exists using jdbc java
How to check if a table exists in jdbc using Sqlite3?
-
1
votes1
answer2683
viewsHow to Access Real-Time Android Sqlite Data (DEBUG)
How can I access the data contained in the local database of the Android device, ensuring that the information is up to date? My IDE is Intellij IDEA and I use the connection feature with the…
-
1
votes0
answers336
viewsHow to insert an id in android SQLITE?
I am trying to insert the same id that I get from the server database in the android database through sqlite, however, it is generating an id of its own, I am using auto increment in Primary key, I…
-
1
votes1
answer656
viewsRedo autoincrement on Sqlite
I am passing the data from an old bank to a new bank. After running all the querys there were some primary key fields that were "missing". Example by column id jumped from data '11' to data '13'…
-
1
votes2
answers588
viewsPass Activity object id to another
I’m trying to pass the id from my object to another activity using Serializable, but it’s returning to me a damn mistake that I can’t fix. Obs: my object already implements serialiable My code is…
-
1
votes1
answer208
viewsRegister product for logged in user
I’m getting the object through Activity's using putExtra and returning on the other screen with the getSerializableExtra. I’ve already created the fk id_usuario in the product table for the field…
-
1
votes2
answers96
viewsNullpointerexception when deleting register
Good morning. I have a problem I can’t solve. I am developing my first Android app and bumped into this error, Sqlite can not work with Context. I did some research and I couldn’t find a solution. I…
android sqlite nullpointerexception android-context android-recyclerviewasked 8 years, 4 months ago Charles Presidente 91 -
1
votes1
answer1140
viewsError creating database with sqlite
Colleagues, I am trying to create database on a computer with the Sqlite. It is installed and everything OK, but when trying to create using the command by cmd: C: Users José Roberto>sqlite3 C:…
-
1
votes2
answers182
viewsLocal database (serveless) not modifiable with update
Setting: I’m developing a small app WinForm in C# to distribute to sellers to assemble their quotes more quickly and would like to store simple information such as budget issued and registered…
-
1
votes1
answer346
viewsError: Undefined reference to 'sqlite3_open'
I am creating a software in C that uses Sqlite 3 as database, however, when compiling the project Codeblocks returns me the following error message: createdata. c|| undefined reference to…
-
1
votes1
answer38
viewsValue conversion Date no sqlite Android error The method gettext() is Undefined for the type String
I am doing the insertion of a DATE type value in my project, for that I had to convert it, in my corresponding class, my Dt_reading tribute, is declared as string and in the database it is as Date.…
-
1
votes0
answers73
viewsConvert Bitmap to Mat
Hello, I am trying to grab saved BLOBS in a Sqlite database and convert them to Bitmap. After that, I need to convert these Bitmaps into Mat, to use with Opencv. The problem is that when I open the…
-
1
votes1
answer2763
viewsHow to insert images in Android Studio from a drawable folder?
People would like to know if it is possible to upload an image from a drawable folder. For example, I have a Listview with several categories, when a category is selected I would like to see all the…
-
1
votes1
answer1538
viewsValidate Login with Sqlite
I have a problem in the logging method, it is logging in with both the right login and password as with them wrong. When it logs in with wrong login the user id goes as 0 and if it logs with the…
-
1
votes1
answer114
viewsPass CSV content to an Sqlite table
I have a CSV file with student records. I would like to upload these records to a table aluno in the Sqlite. How can I perform this operation?
-
1
votes2
answers286
viewsCan you get the value of an autoincrement column before it is saved in the database?
I have three tables: preco, estabelecimento and precoXestabelecimento. The id of price is autoincrement and there is a relationship N:N between the first two tables, which is represented by the…
-
1
votes0
answers298
viewsUpdate Spinner items at runtime
I have a spinner that returns the saved cities in my comic book, when this city does not exist, I allow to register the same, and after registering and saving, I make to close the city registration…
-
1
votes0
answers61
viewsMultiple update commands separated by ";" (dot and comma) in Sqlite!
Problem I am trying to apply the following script/command to a version of my Sqlite database: UPDATE UF SET DATE_CREATE = DATE_UPDATE; UPDATE CIDADE SET DATE_CREATE = DATE_UPDATE; UPDATE CLIENTE SET…
-
1
votes1
answer333
viewsComparison of an edttext with an Sqlite Bank value
I’m developing an application on android but do not know how to prevent the user register two equal times. Bench: String sql4 ="CREATE TABLE "+TABELAAGE+"(" +IDAGE+ " integer primary key…
-
1
votes1
answer203
viewsSqlite native functions X Sugarrecord
What are the advantages and disadvantages of using SugarRecord when compared to native functions SQLite, Example when creating a table with Sqlite Native Functions DatabaseHelper.java public class…
-
1
votes1
answer97
viewsError while listing Sqlite data
I am making a listing of the information contained in my Sqlite database However, sometimes or other, I get the following error: java.lang.Arrayindexoutofboundsexception: length=13; index=1401 The…
-
1
votes0
answers46
viewsHow to create software in c# with local database?
I am creating a desktop application, however, it will not be for customer, but for user. I mean, people will download and install in their homes. The main question is: how do I get this system to…
-
1
votes2
answers4333
viewsHow to resolve java.lang.nullpointerexception in sqlite application?
I am having problem with this exception. I have seen some tutorials here, but none of them can solve my problem. Even the answers to similar questions could not satisfy my need. I’m making a desktop…
-
1
votes2
answers748
viewsWhen I create two tables in Android Sqlite, only one works
I’m trying to develop a test app that requires two tables (aluno and disciplina) in class DataHelper. I create two tables, but when testing, only the table Aluno works. In summary: the application…
-
1
votes1
answer218
viewsSqlite data not available in Recyclerview
I’m trying to list data in a Recyclerview, but in the 3 lines nothing appears and I don’t know what’s wrong, take a look at the image below: Adapter client.java import…