Questions tagged as 'cursor'

Tagged questions
0
answers

I need to export an NVARCHAR from JAVA in excel

I am using the sql server database in which I am using a cursor. I need to read this NVARCHAR from java so I can export it in excel from java. Take into consideration: that these columns of my Excel will be added more in the future. e...
asked by 09.03.2018 / 20:43
1
answer

Data from a table through Android sqlite buttons

I'm creating a song library connected to a database The data is stored in a form (title, letter, urldelvideo) and added to a listview that only shows the title and id. When selecting the listview item (in the listview it only shows the title)...
asked by 03.05.2018 / 22:14
1
answer

How can I adjust the text entry position in JAVA?

I have the following code: System.out.println(""); System.out.println("SELECCIONE UN MODO PARA LA GENERACION DEL REPORTE:"); System.out.println(""); System.out.println("1. MENSUAL");...
asked by 10.07.2017 / 14:44
1
answer

Update records using a TRIGGER FOR DELETE using SQL Server

I want to make a trigger that as soon as I make a dismissal to the rest of the employees I raise the salary by 20%, but I do not know how to operate directly with the cursor explícito in this trigger , since the query would g...
asked by 14.02.2017 / 23:03
1
answer

Cursor position SearchView Android

I am looking for a way to position the cursor of a SearchView at the beginning of the text. What I do is that I rescue a text and place it in the SearchView and the cursor is positioned at the end of it. I know that in EditText there is the s...
asked by 15.12.2018 / 20:45
0
answers

ORACLE SQL CURSORS

We are doing a job for the university for the subject Databases One of the sections asks us to create a PROCEDURE with cursors We do not have much idea but we have tried to do it. We have 3 tables: exit, company_transport, seed with the...
asked by 12.08.2018 / 21:21
0
answers

Problem with while (! cursorIsAfterLast ())

I have this method public ArrayList<Estadisticas> getStats(int p_id) { String[] columnas = new String[]{"_id", "user_id", "letra", "jugadas", "errores", "acertada", "tiempo"}; Cursor cursor = this.getReadableDatabase().query("est...
asked by 28.06.2018 / 17:48
0
answers

query or cursor mysql

I have a problem with this type of query or it would be better with a cursor I leave you an example table: *create table table11( cod_table int, dni varchar(9), doc_slug varchar(100), doc_tipo int, fecha_vecimiento date, fecha_carga date )...
asked by 13.06.2018 / 22:50
0
answers

Error closing select cursor with SQLite and changing fragments

I have a difficult problem to explain and that I can put code if you wish but I think it is better to comment as you can and give me opinion. I have an android application that works with several activities, but it contains a main one and in...
asked by 23.05.2018 / 17:19
0
answers

delete records of a cursor filled with the result of a query

Hi, I've made a very simple query and it gives me this information. select * from personas ORDER BY CAST(checkm.orden as integer) I have placed the results in a cursor. to then show them in a listview As you can see, the type fi...
asked by 28.01.2018 / 02:07