Questions tagged as 'sqlite'

Tagged questions
1
answer

Error assigning to String cursor value

I have a cursor to find the earliest date but I peta by assigning the string Cursor cFechaAntigua = bd.FechaAntigua(); buscarFechaInicio = cFechaAntigua.getString(cFechaAntigua.getColumnIndex(ArticleDataSource.MOVIMENTOS_FECHA)); This is t...
asked by 17.02.2018 / 16:48
2
answers

When I insert data into a SQLite table, it says that the database is blocked

I am creating an application in WPF which inserts in a table of SQLite every login. When you are about to insert: throw this exception: The code of the method to insert is this: public void InsertValuesToDataBase (str...
asked by 04.04.2018 / 18:04
2
answers

Xamarin can not find refunds - Sqlite

Hello friends I am trying to store some data locally on my device with SQLite , but I have encountered some problems. I was researching that in order to store data on a device from Xamarin we must make different routes for each type of device,...
asked by 14.02.2018 / 01:11
1
answer

Check the existence of a file

This is my problem, in c #, the code generates txt files, I am creating a control panel that verifies the creation of these txt, with 1 if it exists and 0 that does not exist, the problem that arises is that once it finishes verifying the creati...
asked by 22.06.2017 / 19:25
1
answer

Android Studio Debbuger view content from a Cursor

I am debugging an application and would need to know which branch to enter to see the contents of when Cursor.getString (int) is called; To see if you are grabbing something from my Database and if you grab it, check that it's what I'm looki...
asked by 22.11.2018 / 22:50
1
answer

Filtering by dates SQLite C #

I have a table in SQLite with several fields including a Text type date with the following format: "2018-11-04 12:13:00" Since SQLite does not have the Date field in problems to make queries of dates greater or lesser than one that happens...
asked by 04.11.2018 / 18:13
1
answer

Android listview arrayadapter sqlite

I'm trying to fill a listview with data from a sqlite table but I do not know what I'm doing wrong, here's the code if someone can help me, the instruction is at the end in btnconsultar . protected void onCreate(Bundle savedInstanceState)...
asked by 11.09.2018 / 23:18
2
answers

I can not get 1 object from my database, problem with SQLite and PreparedStatement

I'm doing a system with a full CRUD, the only problem I have is that I can not recover 1 object from my database, I can list all the objects but I do not get only 1, I'm using MVC and java web. Here is the servlet that runs the search @Over...
asked by 24.07.2018 / 17:10
1
answer

How to make a Foreach in a SQLite DataReader?

I'm trying to get the data from an SQLite query and then save the fields in a list and show them to the user through a MessageBox. I have two problems: 1) I do not know if what I'm doing is fine. 2) I do not compile the code, and I do not know w...
asked by 26.06.2018 / 04:14
1
answer

Problem making a DELETE with the LIMIT clause in a SQLite query

The following query erases the data coinciding with the search of my database but I only want to delete a single row in case the query matches more than one row of my table. According to what I understand the query would be well done, with the...
asked by 20.06.2018 / 23:38