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
-
3
votes2
answers638
viewserror: "table sales has 6 Columns but 5 values Were supplied"
I created the following table in sql CREATE TABLE vendas ( ID INTEGER IDENTITY(1,1), Empresa VARCHAR (20), Modelo TEXT, Preco REAL, Kilometragem REAL, Ano INTEGER, PRIMARY KEY(ID) ); I put as key…
-
3
votes1
answer5459
viewsDjango: Reverse for '' not found. '' is not a Valid view Function or Pattern name
I am trying to put a url based on my views.py but it returns me the error: Reverse for 'create_student' not found. 'create_student' is not a Valid view Function or Pattern name. py urls of the…
-
3
votes1
answer54
viewsBest practices/correct way to upgrade your local base
Good morning, I got an APP started by a colleague in the company. The problem is that I’m not flying yet with android. I need to make changes to the structure of the local bank (With the APP in…
-
3
votes1
answer88
viewsIs it possible to have a list as an attribute of a table in a relational database?
I’m doing a Java project using Sqlite as a relational database. Basically the project is a database of passwords, where a User can have several registered platforms and each platform having its…
-
2
votes1
answer1615
viewsHow to copy SQLITE database from internal memory to SD card command Linux
Good morning, you guys, One day I managed to find the database of an android application I am doing in the internal memory via Linux commands, the application is in Delphi XE but the storage…
-
2
votes1
answer337
viewsINNER JOIN WITH OR CLAUSE
I have the following select: SELECT linha._id, linha.numero_onibus, linha.nome, percurso.nome FROM linha INNER JOIN percurso ON linha._id = percurso.id_linha AND (linha.numero_onibus LIKE ? OR…
sqliteasked 10 years, 3 months ago Marco Aurélio 23 -
2
votes1
answer2723
viewsData update Sqlite Android
How to take the information that is on the screen and do an Update in the database. Code displaying information in Edittext. public class DatabasesDAO extends SQLiteOpenHelper { private static final…
-
2
votes1
answer982
viewsError searching in Sqlite
Could someone help me? I’ve done several ways but the app gives error and closes. I am using database (Sqlite) when have to search gives the error: 01-05 03:40:18.544: E/AndroidRuntime(12226): FATAL…
-
2
votes2
answers1837
viewsHybrid app database using Cordova
What are the possible and most viable solutions to use a database in a hybrid APP (Android/iOS) made on Intel XDK (Cordova)?
-
2
votes0
answers755
viewsHow to sync Sqlite with Mysql
I have an application in Ionic and Angular that receives information through a $http. I’d like to know how I keep the information offline of the application updated with those of the Mysql database…
-
2
votes1
answer426
viewsHow to get the path to my Sqlite database?
I need my app to allow me to back up and re-store the data that is recorded in Sqlite. I followed some tutorials from the internet but I’m not able to make a copy of the data! String packageName =…
-
2
votes1
answer790
viewsHow do I use Sqlite in a Cordova application?
Gentlemen, I have a hybrid application that I built in HTML, CSS and Javascript (Jquery Mobile) using Cordova, and now I would like to access the device’s database. Unfortunately I don’t know where…
-
2
votes3
answers1012
viewsRecover md5 password from an Android application
I created an Android application where asks for a password to access the application. The user registers this password (numeric) and an email to recover password, the data is recorded in Sqlite and…
-
2
votes1
answer1890
viewsWhat is the real use of Sqliteopenhelper on Android?
I was watching a course online devmedia explaining about Sqlite on Android, in the example of the course was made a basic crud, were created 1 bank and 2 tables. In the example, I was creating two…
-
2
votes2
answers276
viewsInsert sqlite in android app
I’m developing a sqlite database for the application part. At this time I am using the Sqlitebrowser, and would like to know how to do to grab the database and put to the application read this. I…
-
2
votes1
answer115
viewsDeployment of Sqlite together with . Net application
I finished the C# app with Sqlite, but I saw that I need to send along with the Sqlite base and DLL. Which Sqlite DLL files need to attach and which folder do I have to play these files in?…
-
2
votes1
answer333
viewsSqlitedatabase turn back into json
Good afternoon, I need to do a query but I can’t use the cursor. Example I have an object that I created that is called Databasehelper, within it I created some methods…
-
2
votes1
answer4232
viewsAndroid Sqlite: Displaying bank content in textView?
I would like to know how I do to display content from the Sqlite database in textviews. I am using the following method to display in a Customlistview: public Cursor getAllData () { String buildSQL…
-
2
votes2
answers387
viewsHow to return strings that are in crescent date format in Sqlite?
I took a long and recorded on the bench in this format SimpleDateFormat("dd/MM/yyyy") which is a string and now I need to organize the dates. I tried to use this command but it comes in descending…
-
2
votes1
answer579
viewsUsing Webservice + Sqlite
My doubt is the following, I am developing an application that has an access to a Webservice, however I think it is important to save some internal data in the application, as for example, if the…
-
2
votes0
answers149
viewsError searching DB SQLITE information
I’m using the class sqliteopenhelper from android to database connection, our save() method, is working perfectly, but our search() method, where my cursor lists all registered cities, is not…
-
2
votes1
answer1229
viewsEmbedded database with C#
I’m developing a local app for desktop. As there will be no database servers, I studied some, such as Firebird, Sqlite, Access and even Localdb. But I still feel "lost" in which to work. I know the…
-
2
votes0
answers275
viewsExternal database is not loading on android
I need to make an application Android who accesses a servidor, low files .s3db and query about the downloaded files. I can download normally to data/data/meu-pacote/databases/ and I can also do…
-
2
votes1
answer115
viewsPhonegap + Cordova + sqlite
I have a problem with a stoned database file. I created a . db file with all columns and contents and compile it along with apk. The last change I made in the bank after performing a new build is…
-
2
votes2
answers1877
viewsHow to check if there is any sqlite database in the application?
I have the following dilemma: I’m setting up an app where I perform a synchronization between a Mysqle database and Sqlite using a Webservice. My database is already available in Mysql, and in my…
-
2
votes2
answers706
viewsInform a date, and catch the interval of the week of the month of that date (from Sunday to Saturday)
I am in need of an SQL command (Sqlite for android), which returns the interval of one week (from Sunday to Saturday) of an informed date. For example: inform the date '05-05-2016', hence the sql…
-
2
votes0
answers409
viewsError saving data to Sqlite database
create table works, but when you set the code to save, the application compiles but does not save. Which can be? SQLiteDatabase winlife; EditText edt_meta; EditText edt_tempo; EditText…
-
2
votes1
answer372
viewsSqlite MAX function - Grab the highest value
I have in the Sqlite a field called date_start, which saves the date of a walk. This one, it’s like Long and keeps the date on milisegundos. I would like, through a query, to return the highest…
-
2
votes1
answer202
views -
2
votes2
answers3051
viewsPopular Spinner with Sqlite Database -
I have the following table in the database: CREATE TABLE turma(_id integer primary key autoincrement, nome varchar(20)) I need to fill out a SPINNER with this data, so that the class NAME is…
-
2
votes1
answer74
viewsAndroid Device Monitor
I’m trying to use android device monitor to extract my database, only it keeps giving this error.…
-
2
votes1
answer343
viewsSqlite being accessed remotely
Would it be possible to create an App connection on Android with the Sqlite service with PC Local? I’m not talking about a database inside the Android itself, but communicating with the same PC.…
-
2
votes1
answer187
viewsHow do I let "bind" to "Sqlitestatement" accept a null value in Sqlite?
I decided to use Sqlitestatement because it is faster to insert data in Sqlite, but at some point a null value can come object.getAlgumthing() and in this case an error with the message that the…
-
2
votes4
answers311
viewsCreating Data Base through Stringbuilder
I am creating my database with the class sqliteOpenHelper, passing the creation of DB by String through the StringBuilder. The problem is, it’s just creating the first table, and then it doesn’t…
-
2
votes0
answers611
viewsHow to save an image in the bank
I want to take the image of imageView save in the bank and make the last saved image back when open the app code to transform the image in byte ByteArrayOutputStream saida = new…
-
2
votes1
answer8769
viewsCreate/Modify table without deleting data Laravel Migrate
I have a question about the Migrates. I am using Laravel 5.1 with Sqlite database. When I turn the remote php artisan migrate or php artisan migrate:refresh, generally to add new tables or insert…
-
2
votes1
answer238
viewsHow to use a Sqlserver script to create a database in Sqlite?
I have a generated script from SQL Server it contains multiple tables and views, I plan to carry this database to my Android Sqlite. How do I run the script on Sqlite on Android ?…
-
2
votes1
answer777
viewsError changing table SQLITE - in such column
I included a new column in a table. I reinstalled the application and at the time of saving the data there is a message saying that there is a pathImage column, in my case in the clients table. I…
-
2
votes1
answer1936
viewsEncryption in the sqlite
I am needing to store some data in Sqlite, but this data needs to be encrypted, and when the user needs it, decrypted. What’s the best way to do that?
-
2
votes1
answer439
viewsStore vector in Sqlite
I am creating an application in C# that must have a database. At first I’m thinking of using Sqlite for simplicity. But for each data entered in my bank must have : Identifying (int, char, bool)...…
-
2
votes1
answer184
viewsList more borrowed books
I would like to list the books in order of most borrowed, but there is no book that was borrowed so it shows none. I’d like you to show it in order but even if the book hasn’t been borrowed at all…
sqliteasked 7 years, 10 months ago Jose Felipe 177 -
2
votes1
answer236
viewsXamarin - Dependencyservice NULL
Dear friends, good morning! I started seeing a tutorial to develop a simple app in Xamarin with Sqlite, but I have a problem, with an object that calls Dependencyservice, they always come null, and…
-
2
votes0
answers51
viewsOpening Sqlite3 in Windows10
When I open Sqlite3 on Windows 10, it simply opens the command prompt, giving command permission in front of the line sqlite>. Already in windows 7 and 8 it opens normally. My intention to use…
-
2
votes1
answer101
viewsUse of Sqlite Android
I developed two apps to learn Android and used Mysql database. So far I found no need to use Sqlite and to be honest I did not understand even why of its existence. What is the usefulness of Sqlite…
-
2
votes1
answer37
viewsC# helps error with sqlite
Where is the error ? does not update at all SQLiteConnection conn = new SQLiteConnection(conexao); if (conn.State == ConnectionState.Closed) conn.Open(); SQLiteCommand cmd = new…
-
2
votes1
answer918
viewsObject Reference not set to an instance of an Object
I’m learning to do App using the Xamarin 2017, and when I try to connect to the database I created via SQLite, the application shows this error: Object Reference not set to an instance of an Object.…
-
2
votes0
answers62
viewsTransfer Information from One View to Another
Good afternoon! I came across a question, I am developing a project Xamarin Forms Shared, using MVVM standard, in a certain View Model1 linked to View1, when performing a search and existing the…
-
2
votes3
answers434
viewsSynchronous query in Sqlite using Ionic
I have the following function below: public requisicaoXPTA() { this.database.executeSql("SELECT * FROM tbl_xpta", []).then((data) => { // o resultado retorna aqu na variável data }, (error) =>…
-
2
votes0
answers110
viewsLocal Network Android App
I would like to know where to start studying to create an app that works on a local network. I have a version of this App that works using Firebase with my online database. I wanted now to do…
-
2
votes2
answers607
viewsHow to select a database blob and transform into bitmap?
I have the following error in my project, I select an image of the gallery turn it into byte register in the database, but at the moment of loading it to imageView it does not appear and not the…