Questions tagged as 'query'

Tagged questions
1
answer

SQL query error when executing

I am trying to make a query in SQL Server in which I do: Round(Convert(float,A)/(Convert(float,B),2) and you return this message:    The conversion of the nvarchar value '2968922618' overflowed an int column. The value of the denomin...
asked by 22.02.2017 / 16:17
2
answers

Filter query using foreign key

I have the following tables: Tabla 1 ---------- id *fk_ciudades datoX1 datoX2 Tabla 2 ---------- idCiudades nombreCiudades And I want to make a query that selects one of the rows of Table 1 , when a variable x that I pass, is equa...
asked by 18.02.2017 / 23:17
1
answer

executeUpdate - incompatible types: int can not be converted to java.sql.ResultSet JAVA

I am trying using a JDialog of a high vehicle form to make an insert in a table in the database. Pressing the " Enviar/OK/Insertar " button to add it to the database gives me the following error: Uncompilable source code - incompa...
asked by 28.12.2016 / 14:01
0
answers

Concatenate results of last numFile (id) registered and another update field

I need to know how to concatenate results obtained after a insert and update a field, with the information ... The insert, the isset and others work correctly, all I want to do is after if ($result > 0) . In $query2 I'm...
asked by 04.01.2019 / 19:08
2
answers

Reports in SAP Crystal Reports with SQL queries

In SAP B1, you already have a report called "Provisional Balance" by default, and it shows you the initial Balance, Debit, Credit and Current Balance. It's the Next: Well here the question is to generate that same report in SAP Cryst...
asked by 05.04.2017 / 19:14
1
answer

Nest several tables to show records with the most recent date

I have a question with a query, I need to make a query that shows me the most recent date of the registration of a price of a product that has a record of several prices with different dates, I just want to obtain the most recent date for each p...
asked by 20.12.2018 / 19:08
2
answers

Query in Mysql to get records that have the same records in another table

I have the following three tables: With the following information: Recipe: Ingredient: RECIPE_INGREDIENTE: Now for example I want to bring the recipes that have the ingredients leche(6) y Azúcar(7) The res...
asked by 23.11.2018 / 02:00
1
answer

Globe orders auto refresh

I'm with the back of a website that is a store, and I'm preparing the typical balloons that are on top of the cart, to notify you how many orders there are new on the web, check them in the database. Script with which I check and print every...
asked by 08.10.2018 / 09:16
0
answers

eloquent query does not bring me records when I make a select

I have the following query in eloquent that shows me the records Usuario::with(['rutas'=> function($query){ $query ->select('rutas.*','puntosDeVenta.id_puntodeventa','puntosDeVenta.codigo') ->join('puntosDeVenta...
asked by 26.09.2018 / 17:11
0
answers

Help with putting together a query in Oracle?

I have a table called ESTRUCTURA that has the fields ID_ESTRUCTURA, NOMBRE_TRABAJADOR, ACTIVO And a table called TRABAJADOR_RANGO that has the fields ID_TRABAJADOR_RANGO, ID_ESTRUCTURA, ID_SERVICIO, TIPO_RANGO What I want...
asked by 05.10.2018 / 05:57