Questions tagged as 'sqlite'

Tagged questions
1
answer

Hierarchical database (?) - SQLite / Android [closed]

Good afternoon, I'm starting to study Android and thought of making an application to already study database together. I want to make a "family tree", so that clicking on the name of the person (button) would appear other buttons with the names...
asked by 26.09.2016 / 22:20
1
answer

import gallery image - android

Hey guys, I need help with my application, I have to select an image from the gallery, make it appear in an imageView and save it in the database (SQLite) so that the person can exit the application and keep the picture for when it comes back, i...
asked by 13.10.2016 / 02:14
1
answer

How to create a table Products that have different prices?

Someone would know how to map a Products table, and the product has different prices for each type of parcel that the customer chooses. For example I created a table called PRECOS and there is FK of the PRODUCT, but at the time of creating the f...
asked by 12.08.2016 / 02:29
1
answer

Integrity violation not released in BD Sqlite

CRUD in C # is not releasing integrity violation error while deleting dependent registry in SQLite DB. query = "DELETE FROM "+ table + " WHERE id = '" + id + "';"; int returnValue = 0; try {...
asked by 30.08.2016 / 02:11
1
answer

ERROR: CursorIndexOutOfBoundsException [closed]

public boolean insertData(int id_pedido, int id_item, String nome, int quantidade) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put(COL_1_ITEM_ORDER, id_pedido);...
asked by 03.08.2016 / 20:24
1
answer

Problems with Laravel's SQLite file permission

I'm having problem with SQLite database startup, when I run the command migrate the error appears so [PDOException] SQLSTATE[HY000] [14] unable to open database file My file .sqlite is located in the storage folder and its nam...
asked by 08.08.2016 / 14:59
1
answer

Problem with SQLite in the onPostExecute method of AsyncTask

I'm having a problem running an SQLite function in the onPostExecute method of AsyncTask. When implementing the same function in the Activity it executes normally, but onPostExecute does not even enter the breakpoint I put in the function. Th...
asked by 06.04.2016 / 16:03
1
answer

display listview in same activity after query

I have this query layout with a Listview: AftertypingRadioButtonandtypingthesearchparameterIwouldlikethelisttoappearwiththedatabasedata(detail,IhaveaListviewthatreturnsallthedataregisteredinthebankworkingnormally),butIIclickonsearchandnothin...
asked by 30.01.2016 / 14:52
1
answer

SQLite android query () / like with accents and without

How to make a query in SQLite for Android that looks for both accented and unstressed words? For example: String[]ARGUMENTOS = {"%"+argumento+"%"} query(TABELA_CIDADES, COLUNA_NOME, NOME + " like ?",ARGUMENTOS,null,null,null,null); Wh...
asked by 29.01.2016 / 12:43
2
answers

How to create SQLITE BLOB fields with delphi

I'm developing an android APP via delphi. I have recently tried to create a BLOB-type field in my SQLITE database at the moment when I do ShowMessage(query.FieldByName('imagem').ClassName); (I ask the data type of the field) returns me as T...
asked by 20.01.2016 / 16:36