Questions tagged as 'sqlite'

Tagged questions
1
answer

How to sort the records correctly using DISTINCT

In my table I have the column DESCRICAO and the DATA_DE_CADASTRO of items. In my Android application I would like to display the last 10 records that were recorded. There are a number of attributes that must be reported when wri...
asked by 07.09.2016 / 15:47
0
answers

How to maintain the SQLite database in Raspberry Pi?

I have an application running on Raspberry Pi with Windows IoT, but every time I give deploy on a new version or when I restart Raspberry the whole SQLite database is deleted. I saw something related that he by default creates temporary banks. H...
asked by 16.09.2016 / 19:01
2
answers

How to use a ready database on Android with SQLite

I'm developing an application that downloads a database according to the user's state (UF). Does anyone know how I enter data into the database? Note: the database file can reach 200 MB.     
asked by 24.07.2016 / 22:17
1
answer

Error while compiling a project in delphi seattle for android sando SQLite

I'm getting this error while compiling for android. On windows, it compiles and runs the app without any problems. If anyone can help, I will be immensely grateful. [DCC Error] E2597 C:\Users\Public\Documents\Embarcadero\Studio.0\PlatformSDKs\...
asked by 17.08.2016 / 18:23
1
answer

How to select by the database the value of the column that I used the method random ()

I made a project in Android that is a little game of the gallows, where I can write in the SQLite database the word and a tip. In my DatabaseHelper class I created the normal database, and made some selects from the column where the words are st...
asked by 15.06.2016 / 02:32
1
answer

How to send a select made by a StringBuffer to a class

I do not know how to send a select into my DatabaseHelper class and send it to a public class, so from there make my code work normally. My DatabaseHelper class and at the end select : class AddressBookDatabaseHelper extends SQLiteOpenHel...
asked by 14.06.2016 / 00:07
0
answers

Querying a record in SQLite

I am having a problem to perform a query in an SQLite database of an android application that I am studying. I can retrieve all records that the database contains, but I can not search for a single record in the table. It follows the code of the...
asked by 05.07.2016 / 12:02
1
answer

Sqlite no longer runs android - app

I'm having a problem with my app, sqlite apparently is not running. All functions related to it are not working, in this application I use some functions based on external mysql these are "ok". See below how to build my base: package com.db...
asked by 29.04.2016 / 00:59
1
answer

SQLite does not initialize Cordova / Phonegap

I added the cordova-sqlite-storage plugin in my phonegap project but when I create the database it does not create and does not initialize. document.addEventListener("deviceready", onDeviceReady, false); var db; function onDeviceReady() {...
asked by 27.04.2016 / 21:19
1
answer

Error saving image path SQLITE: table .. has no column named [closed]

ItisgivingerrorinsavingthepathoftheimageinSQLITE.ItsaysitdoesnothaveacolumnnamedpathImageinthetableproductsattachedimagewitherrorforbetterunderstanding.MyDaoProductClass:importandroid.content.ContentValues;importandroid.database.Cursor;importbr...
asked by 24.01.2016 / 18:52