Questions tagged as 'sqlite'

Tagged questions
1
answer

First element in listView does not appear

I have a listView that lists through an adapter. The list is updated after a search in SQLite. The problem is that it only appears from the second element of my table .... could anyone help me? Adapter: public class ItemListHistoryAdapter e...
asked by 02.07.2015 / 15:01
2
answers

Can I get the value of an autoincrement column before it is saved in the database?

I have three tables: preco , estabelecimento and precoXestabelecimento . The id of price is autoincrement and there is a N: N relationship between the first two tables, which is represented by the third precoX...
asked by 24.11.2016 / 14:31
0
answers

Difficulties in doing an SQLite query Android

I am doing a project for college, but I have difficulties with SQLite queries. I wish you could help me with this. OnCreate: protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.l...
asked by 01.11.2016 / 00:53
1
answer

Update on a table row

I'm starting to use SQLite in a project and would like some help on how to update on a particular line, in this case, only one ID will be updated at a time. Follow the codes: View and where the update button is clicked: @Overri...
asked by 28.11.2016 / 17:07
0
answers

Problem connecting to the external database

When trying to open the connection, an error message appears: W/System.err: java.sql.SQLException: opening db: 'C:\sqlite\AgendaOnline': open failed: EROFS (Read-only file system) W/System.err: at org.sqlite.core.CoreConnection.open(CoreC...
asked by 26.11.2016 / 19:14
1
answer

Check if Registry exists in DB SQLite and if there is no Return Message

Good night, I'm trying to make a small app that consists of searching a SQLite database. For the research I will use two forms, that is through the UN Numero and through the Name. However, I'm encountering a problem, the app pops up in cas...
asked by 27.11.2016 / 23:58
1
answer

sort the dates in the bank

I have the following problem, I can not sort in ascending order the dates that are saved in the bank, I am using the order by no select but only orders the first two houses until arriving in / making the month messy, my project is android but I...
asked by 17.10.2016 / 19:49
1
answer

Comparing dates in string, using SQLite and NHibernate

I'm using SQLite and NHIbernate, and I'm saving my Datas as String in SQLite because I can not store dates on it. Everything was going ok, but I had to compare dates to print a report. Now, I can not make this comparison because it...
asked by 04.11.2016 / 13:39
1
answer

NullPointerException when doing query in SQLite

I am having a problem that is greatly undermining the development of my application. It aims to sort out an issue (not implemented yet, I am using a fixed value for the question id) through a query in SQLite, and pass it on to the TextViews. Her...
asked by 05.10.2016 / 19:18
1
answer

Insert data from a JSON into a Sqlite database with AngularJS

I'm trying to insert the data I get from my API, into the SQLITE database of my app, I already researched a lot but besides not being able to do it, I could not figure out how to do this. Here is the code for my service : app.service(...
asked by 23.09.2016 / 22:00