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
votes0
answers369
viewsUse of various good quality images on sqlite
I need to address a question of how to best use recording several images of good resolution in the database. Better definition would be to perform any and all operation of the sqlite on several…
-
0
votes2
answers227
viewsSplash screen while receiving web service data
Hello! I have a following problem: I need a splash screen that stays on the screen while the app receives the data from the web service to popular a BD sqlite on iPhone. I tried to use the Xcode…
-
0
votes2
answers2314
viewsThe method openOrCreateDatabase(String, int, null) is Undefined for the type Bancodedados
I’m having trouble creating a class that creates and manipulates the database! But in the method criar() gave a problem saying that "The method openOrCreateDatabase(String, int, null) is Undefined…
-
0
votes0
answers25
viewsHow to create an Activity for a single?
How do I rescue the sqlite data and send it to the xml single? My Sqliteopenhelper: // Getting single Contact getSingle(int id) { SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor =…
-
0
votes1
answer1154
viewsOpen gallery, select and save address in database - Android
I was wondering how I can open the gallery in my android app at runtime, select an image and copy that image to a folder of my application in SD card and save the image path in the database, someone…
-
0
votes1
answer31
viewssqlcipher compile plugin in windows
How do I compile the plugin in windows? I’m doing like this: Git Clone sqlcipher - C:\sqlcipher installed MINGW32 - C:\MINGW32 installed msys - C:\MINGW32\msys\1.0 installed tcltk-8.4.1-1-…
-
0
votes1
answer123
views"Interpret 8-bit bytestrings" error in Sqlalchemy
I’m starting with Sqlalchemy and came across this mistake: sqlalchemy.exc.ProgrammingError: (ProgrammingError) You must not use 8-bit bytes trings unless you use a text_factory that can interpret…
-
0
votes1
answer1508
viewsClear database table
use this method to delete a record from the bank public boolean delete(String id) { String where = "id = ?"; String[] whereArgs = new String[] {id}; int retorno = this.banco.delete("pessoa", where,…
-
0
votes1
answer140
viewsSQLITE INSERT problem when app starts
I’m performing a Insert in my Sqlite, however, I’m getting! The Nslog returns : 2014-06-01 23:15:35.664 goTask[25379:60b] open Bank: Bank opened successfully 2014-06-01 23:15:35.666…
-
0
votes1
answer887
viewsWhat is the SQLITE directory?
Where’s the SQLITE database I created in the android studio IDE? I searched and didn’t find it, and I couldn’t find it in the phone itself .
-
0
votes3
answers2766
viewsGet id of the last record inserted in the database
I was wondering if I have how to insert a record in the database and already returns the id of this record in android sqlite use this method to insert public boolean insertH(HistoricoObjeto…
-
0
votes1
answer1222
viewsGet item data in Listview
I’m developing a college project that consists of an agenda that works with Sqlite database. It may seem trivial, but the way I’m proceeding makes things a little more complex. I want that, when…
-
0
votes1
answer1324
viewsHow to create Listview with Sqlite data in Fragment
How do I insert the Sqlite data into this listview of my code: @Override public void onActivityCreated(Bundle savedInstanceState) { String[] sCheeseStrings = {"Emerson","Simone","Samara"};…
-
0
votes1
answer110
viewsAnd I have a question regarding select in sqlite bank in WP
I started using the Sqlite database on Windows Phone. And I have a question about select in Sqlite bank. /* List items = null; items = App.db.Query(“select Nome from Usuario”); ListBox.ItemsSource =…
-
0
votes2
answers353
viewsListview does not display loaded BD data
I have a query screen, where she should display the items already registered. It just doesn’t show. At first, I thought it was because the information wasn’t being recorded in the comic book, but…
-
0
votes2
answers9169
viewsError in such table. Sqlite
You’re making this mistake, I wonder if my DAO is right. Error: 08-06 14:19:53.304: E/SQLiteLog(16893): (1) no such table: proposta 08-06 14:19:53.334: E/SQLiteDatabase(16893): Error inserting…
-
0
votes0
answers51
viewsSqlite being accessed by GCM
I need my GCM, when receiving a message, save the information in the database, but it is giving error, must be because the application is not open. Anybody know what I should do? I have the…
-
0
votes1
answer403
viewsFatal error: unexpectedly found nil while unwrapping an Optional value
I got the following error message: Fatal error: unexpectedly found nil while unwrapping an Optional value In the following code snippet: // Lê uma coluna do tipo String no (BANCO DE DADOS) func…
-
0
votes1
answer6798
viewsView database in Sqlite
Is there any way I can view the Sqlite Database without having to write the command in the application? I would like to see the records inserted in a table, but I do not know if on Android only…
-
0
votes1
answer66
viewsAccess Virtual Machine file by Sqlite Browser
My file . db is in the emulator SDCARD, but how do I open with Sqlite Browser that file inside ? Or take that file that is in the SDCARD folder and put in my Desktop ? Exemplifying: My file is saved…
-
0
votes1
answer111
viewsScript for first load Xamarin Android sqlite
I need to create a first load script for our application, the problem and we have two BLOB fields in our table, it is very large with this I would like to see the best way to implement this first…
-
0
votes1
answer3258
viewsHow to access "data" folder in Android File Explorer using mobile phone as emulator?
I use a p plugin/ view the tables created in Sqlite, but I can’t access the "date" folder when I use my mobile phone as an emulator, only works when I use an AVD. Someone knows how to release this?…
-
0
votes3
answers1106
viewsHow to view query result in Sqlite?
To view tables I use a plugin called Questoidplugin and works very well, but and to view results of queries, has something?
-
0
votes1
answer78
viewsHow to put db data in more than one Fragment?
I want to put the database data in Fragments, in a Swipe, not a list, where each record is loaded into a different Fragment.
-
0
votes1
answer342
viewsFetch data from a particular column and display them in a Spinner
I’m searching for the Sqlite database records and displaying on a Spinner, but Spinner is displaying all the table records, and I need to display only the records of a particular column . I tried to…
-
0
votes1
answer80
viewsObject Product Saved on the first screen but not on the second
Hi, I’m having a problem with a little study project. I have 2 activitys, First Product and Second Product. The first instance of the object Product 1 saves it in the Sqlite bank, when calling the…
-
0
votes1
answer96
viewsError trying to fetch data
I have an application that should insert data in one screen and in the other consult in the bank The problem is that whenever I try to execute the error query: Log 11-16 18:43:31.023:…
-
0
votes1
answer745
viewsProblem with accentuation when entering data in android Sqlite
I’m trying to give a insert in a table, but it gives syntax error. I believe it is because of the accent, but even searching can not solve. Log error: 11-19 00:34:52.959: W/Aquery(21157):…
-
0
votes1
answer759
viewsSQLITE cursor picking up last value
How to make the SQLITE Cursor, make the variables not stop at the last value ? I made a Setadapter to which he lists all the Listview data, so far so good, but when I put some variable that is…
-
0
votes1
answer1137
viewsHow to open the image in the gallery by clicking on it through my application?
My app has a button that when it is pressed opens the camera, as soon as I take the photo, it is placed in an Imageview on the screen and the image path is saved in my database. I would like to know…
-
0
votes0
answers498
viewsInsert Checkbox value into the bank and then use it on the screen
I have a recipe registration screen that contains a Checkbox called "received", I would like to know how to insert in the sqlite a tinyint and then redeem when I want to consult this recipe. Ex : I…
-
0
votes1
answer993
viewsAndroid sqlite - Return _id logged in Listview only one value selected using Where condition
Good evening guys, I’m new here, I’m new to Android programming, but I decided to do my TCC, a project on Android. by doing alone, finding material on the Internet, without taking Android lessons,…
-
0
votes0
answers1263
viewsList data in a List View
I’m studying programming for Android, I’m making a query in the database Sqlite, however I can not play the data obtained in a listview, it always returns me my string in full instead of the value…
-
0
votes2
answers159
viewsJavascript and C language accessing the same database
I’m using a Facebook APP (and Javascript SDK) to use login on a website, in addition I must store some basic information about the user. As required by the teacher, this site was built "using the C…
-
0
votes1
answer154
viewsMeasure access performance to Android’s Sqlite database
Good afternoon, How can I measure access performance to Android Sqlite database? More specifically database entry and selection.
-
0
votes2
answers69
viewsHow to use SQLITE Runintransactionasync
I need to insert a large amount of lines (exactly 221) when I start my WP application. Actually I’m using arrays and loop repetition for, so I’m losing performance when starting the app. I did some…
-
0
votes2
answers345
viewsAndroid sqlite order by com case
I need to sort a query like the example below, where, the searched text is 'un', it first brings the items that start with 'un'. This is exactly what I need, to order the output of the query, so…
-
0
votes0
answers461
viewsBackup and Restore Android Backup
I created an application with the Sqlite database. I would like to put the function in the application to backup and restore backup. I implemented the code of this site…
-
0
votes2
answers1166
viewsHow to create SQLITE BLOB fields with Delphi
I’m developing an android APP through Delphi. recently I have been trying to create a BLOB field in my SQLITE database when I do ShowMessage(query.FieldByName('imagem').ClassName); (request field…
-
0
votes1
answer1038
viewsSqlite android query() / like with accents and without
How to make a query in Sqlite for Android that searches both accented and not accented words? For example: String[]ARGUMENTOS = {"%"+argumento+"%"} query(TABELA_CIDADES, COLUNA_NOME, NOME + " like…
-
0
votes1
answer4030
viewsjava.lang.Nullpointerexception: Attempt to invoke virtual method on a null Object Reference
I’m trying to enter some values in the bank, but you’re always giving exception. My class that inserts in the bank: private String email; private int codigo; private Button btnOkay; private Button…
-
0
votes1
answer175
viewscustom listview repeating last inserted
to learn, I’m trying to create a custom listview, taking values from the bank, created this Metasacvivity where I call the list method public void listarMetas() { ArrayList<Meta> values = new…
-
0
votes1
answer186
viewsUpdate does not update
The app works like this: An SMS is received, so the app checks if the number that sent this SMS is registered, if the app checks the first twenty characters of the message, which I call text…
-
0
votes2
answers343
viewsHow to use a ready database on Android with Sqlite
I am developing an application that downloads a database according to the state (UF) of the user. Does anyone know how to enter the data into the database? Note: the database file, can reach there…
-
0
votes0
answers74
viewsSqlite android.database.sqlite.Sqliteexception
I’m making the following mistake: android.database.sqlite.Sqliteexception: near "@test": syntax error (code 1): , while compiling: SELECT [email protected], test FROM usuario WHERE email =…
-
0
votes1
answer201
viewsIssues with Laravel Sqlite File Permission
I’m having problem with initializing the Sqlite database when I run the command migrate error appears like this [PDOException] SQLSTATE[HY000] [14] unable to open database file My file .sqlite is…
-
0
votes1
answer415
viewsError when compiling a project in Delphi Seattle for android
I’m getting this error while compiling for android. In windows, compile and run the app smoothly. If anyone can help I’d be immensely grateful. [DCC Error] E2597…
-
0
votes0
answers682
viewsAndroid Studio app with Sqlite Java database
I’m developing an app that takes photos and saves it along with a text written by the user himself in the SQL database. For now I can make him take the photo and open the text box for the user to…
-
0
votes0
answers23
viewsError calling another Activity
I’m creating an app for launching student frequency. The app features web service communication. By clicking enter button: The app will check if you have internet connection to update the teacher…
-
0
votes0
answers136
viewsHow to maintain Sqlite database on Raspberry Pi?
I have an application running on Raspberry Pi with Windows Iot, but every time I deploy in a new version or when I restart the Raspberry the entire Sqlite database is deleted. I saw something…