Questions tagged as 'sqlite'

Tagged questions
2
answers

Insert sqlite into android application

I'm developing a database in sqlite part of the application. At this point I am using the SqliteBrowser, and would like to know how to do to get the database and put for the application to read this. I have a slight notion that I have to create...
asked by 20.08.2015 / 01:01
1
answer

SQLite deployment along with .Net application

I finished the C # app with SQLite, but I saw that I need to send it along with the base and the SQLite DLL. What SQLite DLL files do I need to append and what folder do I have to play these files? The installation of the program will be done...
asked by 20.08.2015 / 15:19
1
answer

Using WebService + SQLite

My question is the following, I'm developing an application that has an access to a WebService, but I think it's important to save some internal data in the application, for example, if the user logs in but has no internet, , so I need to make s...
asked by 26.05.2015 / 18:46
1
answer

How to compile SQLite3?

I'm trying to run a short test with SQLite3. I can not run this program so simple! I have already researched solutions on the internet and none of them solved my problem. Follow the program, cmakelists and logs : main.c #include <stdi...
asked by 06.10.2015 / 15:07
2
answers

Database in hybrid app using Cordova

What are the most feasible and feasible solutions for using a database in a Hybrid APP (Android / iOS) made in Intel XDK (Cordova)?     
asked by 11.03.2015 / 12:50
2
answers

SQL Parameter in PDO PHP does not work

The following code returns 11 bank records: $dbh = new PDO('sqlite:db_coleta.sqlite3'); $sth = $dbh->prepare('SELECT * FROM ROTA_VIEW WHERE usuario_id = 1 AND 0 = 0'); $sth->execute(); $red = $sth->fetchAll(); var_dump($red); But...
asked by 07.08.2018 / 14:42
3
answers

Synchronous 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) => { console.log(e...
asked by 01.12.2017 / 16:24
1
answer

How to insert via SQLite a data in its respective Acitivity

I'm doing an android application and inside it has a fixed listiView sent by an array of string for example String[] servicos = {"Eletricista", "Pedreiro", "Pintor", "Encanador", "Arquiteto", "Engenheiro", "Marcineiro", "Serralheiro"};...
asked by 14.11.2017 / 21:46
1
answer

How to create a composite index in SQLite via Microsoft.EntityFrameworkCore.SQLite?

I'm trying to create a single compound index, but I do not know how to do this in Microsoft.EntityFrameworkCore.SQLite , I'm used to working only with Doctrine and Hibernate and I'm totally lost. This is my template class:...
asked by 05.01.2017 / 16:00
2
answers

How to format / separate date and time from a datetime field of sqlite

I have the Postings table with the following fields: CREATE TABLE [LANCAMENTO]( [ID] INTEGER PRIMARY KEY ASC AUTOINCREMENT NOT NULL UNIQUE, [VALOR] DECIMAL(8, 2), [DATE_BUY] DATETIME, [DESCRIPTION] VARCHAR(150), [TYPE_RELEASE] VA...
asked by 14.10.2017 / 16:49