Questions tagged as 'sql'

Tagged questions
2
answers

MySQL - Search number in a string

DBMS: MySQL I have a table with a column of type Varchar, with the following data: id Descrição 1 Pgto NF 66096 Lg Sistemas vcto: 01/10/2016. 2 Pgto NF 66096 Lg Sistemas vcto: 01/10/2016. 3 Pgto NF 1763 Criare Net vcto: 02/10/20...
asked by 06.01.2017 / 19:19
1
answer

SQL: Record counter with data grouping of different fields

I'm having a hard time building a SQL. I have a address table with the street and crossover fields. I need to count the numbers of records that have the same crossover and group them together Example: id | rua | Cruzamento 1 | Rua Brasi...
asked by 12.12.2016 / 03:21
1
answer

Dblookupcombobox listfieldindex Setting the index the combobox comes empty

I have a problem with Dblookupcombobox, even setting the value of listfieldindex, it is not bringing the item to the combobox cbcPais.ListIndex := 1;     
asked by 17.02.2017 / 13:16
0
answers

SQL query time optimization [closed]

I have a database that stores precipitations marked by multiple sensors at certain dates and times over a year. I am making a query, to fetch all records marked by a single sensor, with the following SELECT p.latitude, p.longitude, h.precipitaca...
asked by 22.11.2016 / 13:57
0
answers

How to pass parameters to a query in a repository?

I'm creating a series of classes that return listings in Java (Android). I'm worried about the format of the parameters that will be passed. My initial approach has been to pass Map with parameters, this way I can add or remove paramet...
asked by 22.11.2016 / 18:01
0
answers

Hibernate does not update information

My problem is that an unsuccessful update follows the code below. EntityManager manager=JpaUtil.getEntityManager(); EntityTransaction trx= manager.getTransaction(); trx.begin(); TypedQuery<Tipi> query = manager.cr...
asked by 03.11.2016 / 14:28
0
answers

Browser Notification

Hello, my name is André Neto, I am developing software, and inside it there is an email center, where the user can send an email from within the system and I save this sending data. Now the problem, I need to notify the person who received the e...
asked by 03.11.2016 / 18:08
2
answers

SQL / Java query

Good morning, guys I'm a beginner in SQL and I need to do the following search. Tenho esta tabela: MINIMO MAXIMO CLASSE 0 20 1 21 40 2 41 60 3 60 10000 4 I need...
asked by 13.11.2016 / 14:12
1
answer

Yii2 dropDownList

I need an example, from dropDownList, where I can make a dropDown between two sqls, in this case A and B. Below is a pseudocode. Introduction to the problem: Table sql A id_A id_usuario nome_A descricao_A Table sql B id_B id_A...
asked by 14.11.2016 / 01:04
1
answer

Take action for each row in a SQL - VB search

I would like to know if anyone can help me with the following question. In a VB code, I want to perform the search for products in an SQL table. For each product found I would like to add a button to a panel. If this is not possible, can I...
asked by 05.01.2017 / 06:03