Questions tagged as 'sqlite'

Tagged questions
1
answer

SQLite Search Error

Can anyone help me? I've done it in several ways but the app gives error and date. I am using database (SQLite) when it has to fetch it gives error : 01-05 03:40:18.544: E/AndroidRuntime(12226): FATAL EXCEPTION: main 01-05 03:40:18.544: E/And...
asked by 05.01.2015 / 06:44
1
answer

Pass database contents from page to page

It seems like something simple to search, but I can not. I would like to when clicked on an item in the list, open a new page with the detailed information of that item, it will be the same information used on the homepage. But I do not know how...
asked by 17.08.2018 / 22:47
1
answer

How to catch exceptions thrown by the insert () method?

I am using SQLite for a local bank in an Android application, my problem is that I am not able to handle health restriction exceptions. I have a table where the two fields are PK, that is, there can never be equal records. When I try to enter tw...
asked by 07.03.2018 / 03:38
1
answer

SQLite - too many levels of trigger recursion

I'm getting the error below when I try to insert into SQLite.    Error while executing SQL query on database 'BDTEST': too many levels of trigger recursion Creating the table CREATE TABLE INSTANCES ( ID INTEGER NOT NULL PRIMARY KEY AUTO...
asked by 23.10.2017 / 15:48
2
answers

Filter query with java android sqlite

public ArrayList<Contato> filtrar(String filtro) { ArrayList<Contato> contatoArray = new ArrayList<>(); //Consulta que traz todos dados de todas colunas Cursor cursor = database.query(BaseDAO.TABELA_AGENDA, BaseDAO....
asked by 18.09.2017 / 15:54
1
answer

C # help 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 SQLiteCommand("UPDATE PESSOAS SET NOME,ADDRESS = @NOME,@ADDR...
asked by 07.08.2017 / 18:08
1
answer

How to join records from a table distributed in multiple .sqlite files?

I have several files with .sqlite extension, each containing at least 1000 records totaling about 4,000 records. See how they are distributed: vihicles1.sqlite vihicles2.sqlite vihicles3.sqlite vihicles4.sqlite Inside each fi...
asked by 20.02.2017 / 17:44
1
answer

Create / Modify table without deleting data Laravel Migrate

I have a question about laravel regarding the Migrates. I'm using Laravel 5.1 with SQLite database. When I run the command php artisan migrate or php artisan migrate:refresh , usually to add new tables or insert new fields to exi...
asked by 11.11.2016 / 19:45
1
answer

SQlite MAX function - Get the highest value

I have Sqlite a field called date_start , which keeps the date of a walk. This is of type Long and stores the date in milisegundos . I would like, through a query, to return the highest value (the last recorded hi...
asked by 06.06.2016 / 21:19
1
answer

List most borrowed books

I would like to list the books in order of more borrowed, but there is no book that was borrowed so it shows none. I would like it to show in order but even if the book has not been borrowed once it has to be listed. SELECT Livros.Nome, COUNT(...
asked by 29.03.2017 / 16:58