Questions tagged as 'sql'

Tagged questions
2
answers

Name of object not valid SQL

I want to create a function that allows generating a sales report per employee, in a certain year. The function must return: the data of the employee, the number of registered orders and the total amount per employee. This is an exercise of a PD...
asked by 30.07.2018 / 21:06
1
answer

select data from two tables without mysql relation

I am creating a form to update data, I bring the information from the table escolar called T1 to update it, and another table ge_jornada called T2 that does not has relation with T1, I genre again the options for a dropdown, wh...
asked by 21.07.2018 / 00:40
2
answers

Why do you throw the following error when clicking on the table of my jFrame?

Basically schedule a view in which I could enter data, modify, elminate, so that if I clicked on the table it would let me modify the data that I want, the problem is that it throws me an error that I do not understand and this does not let me m...
asked by 19.07.2018 / 11:17
0
answers

SSIS: Could you help me to know how an input parameter of integration service is inserted in an excel field?

In the red boxes I would like to enter the start and end date, these data are the parameters I use to consult and export in Excel In the red boxes I would like to enter the start and end date, these data are the parameters I use to cons...
asked by 13.07.2018 / 11:39
3
answers

Subquery with data from the same table in sql server

I am using SQL SERVER 2012 I want to make a subquery with data from the same table that has the query relating three fields, I mean, the query is SELECT m.COMPROBANT, COUNT (m.COMPROBANT)Item_ENTRADA, m.FECHA_TRS,m.COD_PROVEE,m.COD_AREA, SU...
asked by 26.07.2018 / 00:52
0
answers

Backup in oracle db using triggers

I have 2 identical tables, just change the name table1 and table2 , when you enter 3 records in table1 the information in this table must be copied to table 2 and table 1 must be empty again.    The solution must be reached using tri...
asked by 25.07.2018 / 22:09
2
answers

I can not connect my database in my Hosting

This is my connection: Using CodeIgniter $db['mysql'] = array( 'dsn' => 'mysql:host=mysql.hostinger.co;dbname=u201535648_regis', 'hostname' => 'mysql.hostinger.co', 'username' => 'u201535648_germa', 'password' => 'password'...
asked by 23.07.2018 / 22:47
1
answer

Display user data logged in php

I'm trying to show data that the user has connected, but I can not. What I want to show is the text of the alert that that connected user has. As you see and done a print_r and I get SELECT alerta FROM usuarios WHERE usuario='test@gmai...
asked by 21.07.2018 / 21:05
0
answers

Get data from MySQL to JTextField Java

I'm trying to get data from my db and display it in TextField's, my problem is that you only get the values of the first table in my list, when you select the second, they are not updated I charge it with MouseClick This is the first fie...
asked by 08.07.2018 / 06:11
3
answers

how to pass scrip variables that interpret a sql statement?

Good is the first time that I participate I am wanting to make the variables: xco, xto, xde, xcc recognize me in the query sql q I do below in vsql, it will not be possible if you can give me a hand or some idea to be able to find that way, than...
asked by 15.07.2018 / 20:53