Questions tagged as 'sqlite'

Tagged questions
2
answers

List always returns only the first row of the bank sqlite [closed]

I have a list, which shows all sqlite bank data, image path, latitude and longitude, but in the list only changes the image path, latitude and longitude always stays the first record. public List<Foto> todasFotos(){ List<Foto>...
asked by 27.09.2016 / 16:59
2
answers

insert a cursor within a while in android

In android I have a cursor where it looks for the data in the database and perfectly returns the data but .. How do I insert a second cursor into the first one? to pull data from a second table My code try { StringBuilder sbQ...
asked by 20.12.2017 / 07:35
1
answer

How to use aggregate functions in a WHERE?

I'm doing college work on Database, and one of the Query I should do is this: Show all lenders who have had a larger total purchase that R $ 5000.00; I tried: SELECT NomeCredor, SUM(Compras.Valor) FROM Credores, Compras WHERE (...
asked by 11.12.2017 / 18:41
1
answer

Transfer data from SQL Server to SQLite with Android

I have software that is connected to a SQL Server database, but now I'm doing the software on Android using SQLite. I need to transfer the SQL Server database (with data) to my SQLite. Backup works? Even with the views I have in SQL Server...
asked by 10.02.2017 / 06:04
1
answer

Return string in a query in SQLITE

I need to return a user's name in an SQLITE query: I'm using the following code: public String verificarUsuario(String login) { try { String selectQuery = "select nome from usuarios where login = " + login;...
asked by 26.06.2017 / 20:44
1
answer

SQLITE cursor taking the last value

How do I make the SQLITE Cursor, cause the variables not to stop at the last value? I made a SetAdapter to which it lists all the data in the ListView, so that's fine, but when I put some variable inside the WHILE, it sets the last value, and I...
asked by 08.12.2014 / 15:28
2
answers

Splash screen while receiving web service data

Hello!  I have a following problem: I need a splash screen that stays on screen while the app receives the data from the web service to popular a BD sqlite on the iPhone.  I tried using the Xcode image launch, but the image only stays on the scr...
asked by 19.07.2014 / 19:09
1
answer

fetch all records from an sqlite column

I need to save the names of the users table in a list and save them in an ArrayList. I did this: public List<String> buscarUsuarios() { List<String> nomes = new ArrayList<String>(); String selectQuery = "select nome...
asked by 05.07.2017 / 20:40
2
answers

The method openOrCreateDatabase (String, int, null) is undefined for the type DatabaseData

I'm having trouble creating a class that created and manipulated the database! But in criar() method gave a problem saying that    "The method openOrCreateDatabase (String, int, null) is undefined for   the type DatabaseData ". Doe...
asked by 03.03.2014 / 19:01
1
answer

How to use Select

I was able to save information to my SQLite database, but I can not call them. I'm trying using the following method: private void verPessoas() { ArrayList<RespostasAguaCasa> pessoas = new Read().getLista(); for (int i = 0; i...
asked by 10.06.2018 / 22:25