Questions tagged as 'sqlite'

Tagged questions
3
answers

Get id of the last record inserted in the bank

I would like to know if you have how to insert a record in the database and already return the id of this record in android sqlite I use this method to insert public boolean insertH(HistoricoObjeto historico) { /* Mapa com a coluna e o...
asked by 09.12.2014 / 19:49
1
answer

Clear database table

I use this method to delete a bank record public boolean delete(String id) { String where = "id = ?"; String[] whereArgs = new String[] {id}; int retorno = this.banco.delete("pessoa", where, whereArgs); if(retorno != 0)...
asked by 01.12.2014 / 19:49
1
answer

What is the SQLITE directory?

Where is the SQLITE database I created in the android studio IDE? I searched and did not locate, and I did not even find it on the phone itself.     
asked by 06.12.2014 / 02:50
1
answer

Error fetching data

I have an application that should enter data on one screen and the other query on the database The problem is that whenever I try to run the error query: Log 11-16 18:43:31.023: I/ActivityManager(26887): Timeline: Activity_launch_reque...
asked by 16.11.2014 / 21:54
1
answer

How to create ListView with SQLite data in Fragment

How do I insert the SQLite data into this listview of my code: @Override public void onActivityCreated(Bundle savedInstanceState) { String[] sCheeseStrings = {"Emerson","Simone","Samara"}; super.onActivityCreated(savedInsta...
asked by 10.06.2014 / 01:27
1
answer

"Interpret 8-bit bytestrings" error in SQLAlchemy

I'm starting with SQLAlchemy and I came across this error:  sqlalchemy.exc.ProgrammingError: (ProgrammingError) You must not use 8-bit bytes trings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str)....
asked by 26.05.2014 / 21:24
1
answer

Find data from a particular column and display it in a Spinner

I'm looking for the Sqlite database records and displaying in a Spinner, however the Spinner is displaying all records in the table, and I need to display only the records of a particular column. I tried changing the query: From: String...
asked by 23.09.2014 / 17:21
2
answers

No such table error. SqLite

You're giving this error, I'd like to know if my DAO is right. Error: 08-06 14:19:53.304: E/SQLiteLog(16893): (1) no such table: proposta 08-06 14:19:53.334: E/SQLiteDatabase(16893): Error inserting validadebrinde=x validade=cd idusuario=1...
asked by 06.08.2014 / 19:25
0
answers

Date field with default value in the database

When I create a DataTimeField type field in Django, it has already been defined so that it contains the current date in this way: dt = models.DateTimeField(auto_now_add=True) or dt = models.DataTimeField(auto_now=True) But that way the...
asked by 04.12.2018 / 18:10
0
answers

Searching Data in Sqlite database with php

I'm trying to get the name of my session, and search the database for the data of who has this name, but echo does not return anything at all. $nome = $_SESSION["Aluno"]; $results = $db->query('Select * from alunos where nome = $nome ');...
asked by 13.11.2018 / 21:56