Questions tagged as 'sqlite'

2
answers

How can I see the structure of a table in SQLite?

In MySQL, we can use the DESC <table> command to discover the structure of a table. What about SQLite? How could I do that?     
asked by 04.01.2017 / 12:08
1
answer

First element in listView does not appear

I have a listView that lists through an adapter. The list is updated after a search in SQLite. The problem is that it only appears from the second element of my table .... could anyone help me? Adapter: public class ItemListHistoryAdapter e...
asked by 02.07.2015 / 15:01
1
answer

Install database together with the C #

I am finalizing a meeting room agenda that will be in the company reception, so I opted for the base to be locally and not networked. I want to use MySQL or SQLite. Can I install the database together with the application? For example: when unde...
asked by 14.08.2015 / 20:22
1
answer

Java design pattern for code reuse

I'm developing a simple program in Java Desktop using SqLite to store local data, I would like to know which design pattern I can use to reuse Java to develop the same application for Android in my project I'm using t...
asked by 01.04.2014 / 22:12
2
answers

Count number of records in a database

I want to count the number of records in a database table. I have 3 records in my DB, but the result is always 1. I used this code: $base_hndl = new SQLite3("p.sqlite"); $select = "SELECT COUNT(*) FROM users"; $resultat = $base_hndl->exec($...
asked by 10.11.2014 / 01:13
3
answers

How to install SQLite to be part of a C # project?

I'm creating a desktop application in C # of registry that will use database. Which database to use? I was advised to use SQLite , but I'm not fully understanding how to use it. What version of SQLite should I download, could you help me...
asked by 18.12.2015 / 20:18
2
answers

Error: Object reference not set to an instance of an object, how to solve?

I have the ChamadaEfetuada(MAluno) : bool method that verifies that the call was made for a given student, this method is used in another method ChamadaEfetuada() : bool that instead of checking if the call was made to a single stu...
asked by 19.11.2015 / 02:57
4
answers

How to get the number of records in a query in SQLite?

I'm listing the records of a table with the code below: SQLiteCommand comando = new SQLiteCommand("SELECT * FROM Cadastro " +filtro, conn); SQLiteDataReader receber = comando.ExecuteReader(); But before listing, I need to check if there is...
asked by 19.08.2015 / 21:13
1
answer

Import already populated sqlite database

I'm making an app need to do only queries on a database. As this is a very large amount of data, I think it would be counterproductive to feed this database using an insertOrThrow for each item in a table. I do not know the best way to do this...
asked by 17.09.2015 / 23:52
2
answers

Migrate data from one version to another - Sqlite Android

In the application I'm working on, I have to save the data from a specific table when the application is updated. This action must happen before the table is dropped in the onUpgrade method. I need to do this because when the application is upda...
asked by 17.09.2015 / 16:18