Questions tagged as 'sqlite'

Tagged questions
2
answers

python manage.py syncdb does not work!

When you try to follow a tutorial I can not continue because the bank was not created, can you help me? Error: Unknown command: 'syncdb' Type 'manage.py help' for usage.     
asked by 02.03.2017 / 01:49
2
answers

I can not insert data into the SQLite table

I want to insert some data into my SQLite table. Creating the table in .app $cordovaSQLite.execute(db, "CREATE TABLE IF NOT EXISTS tbprodutos( id INTEGER PRIMARY KEY, codbarras NUM, desccupom TEXT...
asked by 10.02.2017 / 12:21
1
answer

How to synchronize auto increment keys between different databases in Firedac?

I'm looking at how auto-increment fields work in Firedac, using Delphi xE7, and I've been able to put together an example documentation that syncs two master-details tables with the correct key. The doubt arose when I wanted to mirror my Firebir...
asked by 28.12.2016 / 03:06
1
answer

Error while listing SQLite data

I am making a listing of the information contained in my SQLite database However, sometimes I get the following error:    java.lang.ArrayIndexOutOfBoundsException: length = 13; index = 1401 The intriguing that this only occurs from tim...
asked by 26.01.2017 / 20:53
1
answer

Comparison of an edttext with a SQLite Bank value

I am developing an android application but I do not know how to prevent the user from registering two equal times. Bank: String sql4 ="CREATE TABLE "+TABELAAGE+"(" +IDAGE+ " integer primary key autoincrement,"...
asked by 05.12.2016 / 21:09
2
answers

Creating more than one Android Studio table (SQLite)

I'm trying to develop a mobile application for a final job in my college, it's quite simple! The application has to save the information registered in the database. But I would have to create 4 different tables to store the data, the table...
asked by 05.12.2016 / 20:35
1
answer

Sqlite Filter as error in return date with strftime function

Hello, I have the error in the following code SELECT L.*, C.DESCRICAO AS CATEGORIA , CASE WHEN L.TIPO_LANCAMENTOS = 'C' THEN 0 ELSE 1 END AS ICONE FROM LANCAMENTOS L JOIN CATEGORIAS C ON(C.CODIGO = L.COD_CATEGORIA) WHERE strftime('%m', L.DATA)...
asked by 17.11.2016 / 18:19
1
answer

Select and calculate columns - SQLite

Hello ... //selecionar valores da tabela: public Cursor IMC(){ Cursor cursor; String[] campos = {"SELECT (peso/(altura*altura)) FROM medidas WHERE codigo = (SELECT codigo FROM medidas ORDER BY codigo DESC LIMIT 1)...
asked by 02.12.2016 / 15:50
1
answer

Insert or replace does not work

The command INSERT OR REPLACE INTO SYSVAL ( CDDEVICE, DTVALINI, DTVALFIM, SALDO, REALTIME, VALIDADO ) VALUES( '34322910071833580','31-08-2016', '31-08-2016','10','63714560','S') works seamlessly in SQLiteStudio, but does not work when run...
asked by 31.08.2016 / 15:10
2
answers

NullPointerException while deleting log

Good morning. I have a problem that I can not solve. I'm developing my first Android app and I'm going to stumble over this error, SQLite can not work with Context. I did some research and found no solution. I hope some charitable soul helps me...
asked by 12.07.2016 / 15:35