Questions tagged as 'sqlite'

Tagged questions
1
answer

Display Local Bank data on the screen, Ionic

The function that makes select and throws the data to result is this: $scope.queryAndUpdateOverview = function(){ f_Select("SELECT * from cadastroPessoa",[], function(results){ $scope.dados = results;...
asked by 28.08.2015 / 20:09
2
answers

How to save a SQLite database table to a text file on Android?

I have an application that saves the data of a form in a SQLite database table. So far, I've only been querying these data within the application, no problem. Example: My form saves information such as name and phone number. This information...
asked by 16.04.2015 / 14:17
1
answer

Is there any problem in using multi-threaded software with SQLite?

Is there a problem with using multi-threaded software with an SQLite database? This bank will only have one connection, however the software that will access it is multi-threaded (application server). Is there a problem? Is the SQLite library ca...
asked by 27.04.2015 / 20:46
1
answer

Filter month in QSqlTableModel

How do I filter the month in QSqlTableModel ? I'm doing this: model = new QSqlTableModel(this); model->setTable("tabela"); // db sqlite model->setFilter("strftime('%m', campo_dataCadastro)='04'");//db YYYY/MM/DD HH:MM:SS model-&...
asked by 23.04.2014 / 17:26
1
answer

How to set SELECT values in TextView?

I have the following class for database queries: package com.example.tais.books.Dados; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; /** * Created by Tais on 27/10/2016. */...
asked by 02.11.2016 / 00:16
1
answer

Save Log of operations in the bank with system user field

Hello, I would like to know how to by means of triggers in the database I can besides save the operations performed and in which table also performed the user logged in the system (not the user of the bank, if the user of the system) at the m...
asked by 14.06.2016 / 17:29
4
answers

Creating base date using StringBuilder

I'm creating my database with class sqliteOpenHelper , passing DB creation by String through StringBuilder . The problem is that you are only creating the first table, and then you do not create the next table, in which case I...
asked by 10.11.2015 / 23:27
2
answers

Error saving SQLite data (no such table)

DatabaseHelper class: public class DatabaseHelper extends SQLiteOpenHelper { private static final String BANCO_DADOS = "MakeRequestApp"; private static int VERSAO = 1; public DatabaseHelper(Context context){ super(context, BANCO_DADOS, nu...
asked by 29.01.2017 / 14:17
2
answers

Find SQLite database on Android

Next, I'm creating an Android application, where I use a local SQLite database, never gave any type of registration or database query, so I never needed to get the database directly in the emulator, but now I need the problem I can not find this...
asked by 01.03.2018 / 21:32
3
answers

Recover md5 password from an Android application

I've created an Android application where I ask for a password to access the app. The user registers this password (numeric) and an email to recover password, the data is written in SQLite and I am using MD5 to save to the database and "log in"...
asked by 18.09.2014 / 08:22