Questions tagged as 'sqlite'

Tagged questions
1
answer

SQLite - Python - refer the table column in a loop

I'm doing a script in Python by accessing SQLite database. I made a For loop but I do not know how to get the value of a column in the table. See the example: cursor2 = cnx.cursor() cursor2.execute("select * from despesas") cursor2.moveToFi...
asked by 18.12.2017 / 21:05
1
answer

Read data from a SQLite 3 database in Python

I'm starting in Python and database and I've had three doubts! For example, inside my database I have a "name" column. Just to illustrate, let's say I want to get the contents of the "name" column corresponding to id = 1 and play on a Pytho...
asked by 15.12.2017 / 03:40
1
answer

Error Syntax! Java + XML

The database must be implemented in SQLite and should have the tables; tbprevisao e tbcidade The system should keep the data of the cities already consulted in order to avoid having to search the CPTEC service for the city code with each new...
asked by 23.11.2017 / 17:23
0
answers

Return Null same with registration in SQLIte bank

I have a problem with this query where I am looking for the product code and the service code. If I make a select without WHERE I get results but doing this form my ProductAttachment object always returns null what I might be missing from this q...
asked by 23.11.2017 / 19:31
0
answers

How to transform a Cursor into a String?

Hello, I need to figure out how to transform a Cursor with data coming from the Android Internal Database (SQLite) into a String or String Array. I've tried it in some ways, but none of it has worked. String lista = "Lista de Compras \n\n";...
asked by 24.11.2017 / 19:42
1
answer

Error while changing table SQLITE - no such column

Include a new column in a table. I reinstalled the application and at the time of saving the data there is a message saying that there is no path picture column, in my case, in the clients table. I read some things about it and was advised to in...
asked by 26.01.2016 / 03:57
0
answers

How to perform an update on a Spinner from the EditText data in Android

I have a Spinner that is being populated with SQLite data, I want to get this data, edit it and update it My method of the SpinnerDataBase class (responsible for the Spinner database) public void alteraRegistroSpinner (int id, String label)...
asked by 19.09.2017 / 21:38
1
answer

Format date in Android and SQLite

I am having difficulty setting the current date of my SQLite database in the% type attribute of my object. The SQLite date comes in the format "yyyy-MM-dd". I'm trying to convert to the format accepted in type java.util.Date and that a...
asked by 15.11.2015 / 06:27
1
answer

How to pass data from one Fragment to another (upQuest SQlite)?

I'm developing an app with SQLite, I want to get the data from a ListView (where I'm displaying the saved information) and I want to play to a Fragment to enable the user to edit it. I tried in several ways, but I can not pass t...
asked by 12.09.2017 / 01:02
0
answers

How to put the values of a db column in an array?

I have a table, which is written below. Busy is the part I'm going to play. the value of busy will change according to the program from 0 to 1, depending on whether you are busy or not. I need to load these values into an array, how can I do thi...
asked by 10.09.2017 / 23:33