Questions tagged as 'cursor'

Tagged questions
1
answer

How to filter tweets (status) with tweepy (Cursor)

I took the following code from the book "Mastering social media mining with python", which saves all the tweets of a user in the JSON format. But I'd like it saved in json only tweets of a certain date. How to do? This is the code that saves...
asked by 11.09.2018 / 22:13
0
answers

Use cursor to update a MySQL table, based on a search

I would like some guidance on a challenge in MySQL 8. I have two tables: usuarios (id_user, nome, nascimento, endereço, cidade, ...) utilizacao (id_medicamento, nome, nascimento, medicamento, data, ...) The usuarios table stores all...
asked by 24.08.2018 / 15:20
0
answers

Two declared cursor

I would like to leave two cursors declared at the beginning of the procedure DECLARE R CURSOR FOR SELECT C.CODIGO FROM TABELA1; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done2 = TRUE; DECLARE aulas CURSOR FOR SELECT DISTINCT a.codigo FRO...
asked by 16.08.2018 / 19:50
1
answer

Select from cursor

I'm trying to do a procedure with the following mysql block: DECLARE done INT DEFAULT FALSE; DECLARE v_id INT; DECLARE R CURSOR FOR SELECT id...
asked by 29.06.2018 / 16:21
1
answer

Insert a counter within the ListView

I'm using a CursorAdapter to populate my listView, dento of each item in my listView there are two buttons, one to add and one to decrease the value, and a textView to display this value, I wanted to know how to handle this. item.xml xml &l...
asked by 08.07.2018 / 04:49
0
answers

How to assign data in a cursor from an exec and not a select

Context: I have several files in a folder, so I do not want to put the path one by one, so I need to add my command variables. Set @nome_arquivo = '252203408.xlsx' Set @sql='SELECT * FROM OPENROWSET( ''Microsoft.ACE.OLEDB.12.0'...
asked by 17.05.2018 / 20:46
0
answers

How to know the number of rows of a cursor type sys_refcursor - Oracle

I have a procedure Oracle which has a series of input parameters (IN) and an OUT parameter of type SYS_REFCURSOR . I created a dynamic sql that sets the conditions of where based on the input parameters and then I simply exe...
asked by 12.04.2018 / 22:22
1
answer

I think my table is not being created: no such table?

I'm trying to do a check to see if there is anything inserted in the table, but it always gives the error on this line saying there is no such table. My database: package comviewzonazul.google.httpssites.zonazul.infraestrutura; import andr...
asked by 11.08.2017 / 01:00
1
answer

Auto-increment ORACLE / PLSQL

Nome Idade ID João 5 Lucas 5 João 2 Lucas 1 I would like to use a cursor to sort by names and by age and that the ID field would be populated according to the sequence, eg Nome Idade ID João 2 1 J...
asked by 28.01.2018 / 21:34
1
answer

Attempt to invoke virtual method android.database.sqlite.SQLiteDatabase.rawQuery (java.lang.String, java.lang.String []) 'null object reference

Ok, I'm new to Android and I'm developing a somewhat complex application for a course completion. At the moment the problem is to display a listview with information from a local database (SQLite). I'd be calmer if it were not for the fact that...
asked by 27.02.2017 / 23:15