Questions tagged as 'sqlite'

Tagged questions
0
answers

Post_Event in MySQL

Good night, in firebird we have the functionality to create a trigger with the post_event function, in mysql do we have this function? because I have a delphi application that uses mysql and I have a need that using the FiredacFederal from Fir...
asked by 27.05.2018 / 01:24
0
answers

Ionic 2 Offline

Good Night! I have an app created in Ionic and all information is currently online on a server and the app makes the request, the server returns the data, mounts the page and Ok. But it will come to a point where some of this information should...
asked by 22.05.2018 / 04:40
0
answers

Java - SQLite - Error Querying the Database

I am a beginner and I am creating a small applet designed to carry out the academic control of the students in the Course where I work. I'm using Java + SQLite for the permanence of the data. I'm trying to query in my database, but I'm having...
asked by 15.05.2018 / 23:57
0
answers

SQLiteException: near "ORDER": syntax error (code 1):

My select code: database.query("palavras",new String[]{"_termo"},"LIKE %?%",new String[]{nomeB}, null,null, "_termo ASC"); When making an appointment I get the following error: logcat:    Caused by: android.database.sqlite.SQLiteExceptio...
asked by 23.05.2018 / 02:49
0
answers

accessing SQLite database created by ROOM in Android Studio

I'm using the new android.arch components for persistence with the room , but I could not access the database created in    data \ data \ path \ databases It creates 3 files:    base    base-shm    base-wal    But none...
asked by 19.05.2018 / 05:49
1
answer

SQLite in memory with dapper generates non-existent table error

I have the following code for creating the table: string query = @"CREATE TABLE GVP_USERS_TAGS( ID integer NOT NULL PRIMARY KEY AUTOINCREMENT, DATEINS datetime NOT NULL DEFAUL...
asked by 18.05.2018 / 22:35
0
answers

SQLite error with Java

import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; /** * * @author nathan */ public class Conexao { private Connection conexao; public boolean conection() { try{ this.conexao...
asked by 03.05.2018 / 02:35
0
answers

How to call a function from the component to the template?

Good morning, I'm trying to call a function that displays data from my database. But I'm not sure how to call the template. import { DatabaseProvider } from './../../providers/database/database'; import { AreasProvider, Areas } from '....
asked by 06.05.2018 / 14:55
0
answers

JOIN to search for the most recent date

I'm having trouble doing a specific search through sqlite. I am using this command to join two tables: SELECT p.idpovoamento,p.ostricultor,p.data_inicial, b.data_coleta,b.sistema_producao,b.qauntidadetotal,b.estagio_crescimento FROM povoamento...
asked by 24.04.2018 / 00:05
0
answers

Resolved Cursor.getColumnIndex () returns -1

I'm trying to make a select in the Android database, but every time I try, it generates an error. When doing debug I find that one of the columns, when doing getColumnIndex() is returning me -1 , causing an error in the applica...
asked by 10.04.2018 / 15:41