Questions tagged as 'sqlite'

Tagged questions
1
answer

SQLite android query () / like with accents and without

How to make a query in SQLite for Android that looks for both accented and unstressed words? For example: String[]ARGUMENTOS = {"%"+argumento+"%"} query(TABELA_CIDADES, COLUNA_NOME, NOME + " like ?",ARGUMENTOS,null,null,null,null); Wh...
asked by 29.01.2016 / 12:43
0
answers

Can not load driver class: org.sqlite.JDBC

I'm trying to set up my app's access to a SQLite database using the application.properties of Spring Boot file, but it's not recognizing the driver. How can I proceed so that when initializing with Gradle the application recognizes the dr...
asked by 24.01.2018 / 01:27
0
answers

Transfer information from one View to Another

Good afternoon! I've come across a doubt, I'm developing a xamarin forms shared project, using MVVM standard, in a particular View Model1 linked to View1, when doing a search and existing the value in the local bank, View Model1 Calls View2. So...
asked by 10.11.2017 / 18:09
1
answer

Autoincremet in SQLite is not working on Android

Autoincrement is not working on my tables in SQLite. Table: db.execSQL("create table usuario(_idUsuario integer primary key autoincrement, nome text not null, email text not null, senha text not null)"); Insert: public String insertUsu...
asked by 16.11.2017 / 17:59
1
answer

Object reference not set to an instance of an object

I'm learning to do App using Xamarin 2017 , and when I try to connect to the database I created via SQLite , the application has this error:    Object reference not set to an instance of an object. How could I fix this?...
asked by 29.09.2017 / 23:12
0
answers

Opening SQLite3 on Windows10

When I open SQLite3 in Windows 10, it simply opens the command prompt, giving the command permission in front of the sqlite > line line. Already in windows 7 and 8 it opens normally. My intention of using SQLite is for a simple connec...
asked by 31.03.2017 / 17:40
2
answers

Find simple SQLite data

I want to return only two simple data in TextView using SQLite . I have a common "Products" table and another "Information" temporary table that I use SUM() to add the column of the first table. DBHelper : public Li...
asked by 15.07.2016 / 17:42
1
answer

no such table: tbcarro

Following some examples, I'm in doubt about the following error: 11-24 20:49:14.803 18215-18215/tiburski.rg.cadastrocarro E/SQLiteDatabase: Error inserting nome=ggggg modelo=ggggg placa=hhhh android.database.sqlite.SQLiteException: no such tab...
asked by 25.11.2016 / 00:05
0
answers

Error connecting external database

The following error appears E/MYSQL: Erro: java.lang.ClassNotFoundException: org.sqlite.JDBC.Driver E/MYSQL: Erro: java.sql.SQLException: No suitable driver E/MYSQL: Erro: java.lang.NullPointerException: Attempt to invoke interface method 'jav...
asked by 27.11.2016 / 08:43
0
answers

Error Querying DB SQLite information [closed]

I'm using sqliteopenhelper class to connect to the database, our save () method, is working perfectly, but our fetch method (), where my cursor lists all cities is not finding the table, bringing the following error in logcat: no such table...
asked by 20.10.2015 / 01:19