Questions tagged as 'sqlite'

Tagged questions
1
answer

How can I create a dynamic database in pyhton [closed]

Can anyone help me with how to create a dynamic database, where can I add and remove items? In the Python language, if possible with Sqlite     
asked by 10.05.2018 / 22:01
2
answers

How to get value from a RadioButon inside a RadioGroup to save in the bank

I wanted to know how I get the value of a RadioButton to save it to the sqlite bank. In the example below the instructor does as follows: public class FormularioHelper { private Aluno aluno; public FormularioHelper(FormularioActivity activit...
asked by 27.09.2017 / 23:05
1
answer

Using database coordinates in google maps API

I'm trying to use in Google Maps the data that is in a sqlite database, but I'm not able to access the loader's return. I used the same logic to connect using the database number and it worked, but for the map, it only returns 0,0 coordin...
asked by 09.08.2017 / 15:47
1
answer

Why does my Database (null) return null when I search for id?

I save in my bank using sugar every time I get a new notification, it works correctly, then in a fragment I populate a recycleview with all the database notifications, it also works correctly, but now when I try to delete from the database by id...
asked by 06.07.2017 / 03:30
1
answer

Do not add to the database when any value is null

How do I not add to the database when the String day is null? Code: public boolean insertData(String disciplina,String sala,String dia,String hora){ ContentValues values = new ContentValues(); values.put(COL_2,disciplina);...
asked by 12.07.2017 / 23:02
1
answer

Update BD after entering record

I use the following code to insert a record in sqlite: public void InsereSenha(String Nome, String Senha, String Dica, String Anotacao) { String sql = "INSERT INTO Senha (Nome, Senha, Dica, Anotacao) VALUES (?, ?, ?, ?)"; try {...
asked by 11.07.2017 / 20:57
1
answer

Error performing a SQLITE table creation

I'm trying the following error: android.database.sqlite.SQLiteException: no such column: np (code 1): , while compiling: SELECT _id, nome, email, np, tipoFunc FROM usuarios ORDER BY nome ASC...
asked by 21.06.2017 / 21:11
2
answers

Insert data when creating SQLite table

In my database I have a State and Cities table, I would like to insert this data once the app is installed, ie when creating the database, these records are already inserted in the tables at once. I made the following code but is inserting only...
asked by 19.05.2017 / 02:28
1
answer

SELECT on multiple SQLITE tables

I have a customer table and I list all items in this table in SQLite I also need to list these clients, also get the lowest date, referring to the client, in another table. Example: **Tabela de Clientes** id | codigo_cliente | nome_c...
asked by 09.03.2017 / 23:49
2
answers

How to delete all records from the database

Good afternoon, in my application has a database that shows the results of the game, I put a button that the function of it will delete all the data from the bank ... how do I do this part? in blogs I did not quite understand ... My get and s...
asked by 25.10.2016 / 18:35