Questions tagged as 'sql'

Tagged questions
1
answer

System.DataRowView Error loading ComboBox C #

I have the same problem friends, I understand how the DataTable works but when I'm trying to load a ComboBox through a query that contains 2 tables it shows me the System.DataRowView private void CargarComboCentrales() {...
asked by 20.06.2018 / 07:50
2
answers

Create "on the fly" records of an SQL query in the interval between 2 dates

I do not know if it is possible, I pose the problem. I want to create records from a SQL query in date range One record per day. From the start date to the end date. SQL query: SELECT TRFEC1 as fecha_inicio ,TRFEC2 as fe...
asked by 31.05.2018 / 21:12
1
answer

Error: 150 "Foreign key constraint is incorrectly formed

I had an error in creating a FOREIGN KEY. I'd like to know what I'm doing wrong. Well, I've been trying for some time to find out what the error is. Thank you Annex code Sql: CREATE DATABASE freatico; USE freatico; CREATE TABLE medicion (...
asked by 18.05.2018 / 22:20
0
answers

Who can help me build this table in html?

I want to show a table in html of a query of the database of three tables that are related, the tables are structured as follows: Restaurant | Platos | Precios ----------------------------------------- id | id | id nombre...
asked by 21.05.2018 / 05:19
1
answer

Count different variants of a value in a VBA recordset - Access

I have a Recordset in VBA , I want to count how many variants there are of a value. That is, what in a query SQL would be:    SELECT COUNT (tag)       FROM table       GROUP BY tag Table would be the Recordse...
asked by 16.05.2018 / 10:45
0
answers

How can I store data from a datagridview to a MySql database?

I have a datagridview that is filled with student data according to a search made through a combobox preloaded with workshops in which students register. My question is: How can I insert only specific datagridview fields into the database? I...
asked by 25.05.2018 / 05:31
0
answers

Testing in ASP.NET project?

I have an application in ASP.Net, with web forms, but without any tests, and I would like to do them, now, unit tests would not be worth me since, it has many procedures that use up to 10 different tables with inner join and the paradigm is a mi...
asked by 18.05.2018 / 13:00
1
answer

List results in laravel 5.4

Could you help me with this case? I saw that this is done but I get the error that I attached so I do not know what I'm doing wrong /: public function index() { // Inicializa @rownum DB::statement(DB::raw('SET @rownum = 0')); /...
asked by 22.05.2018 / 04:13
1
answer

Transpose columns in SQL with PIVOT?

Someone can easily explain me an example with PIVOT to transpose columns by rows in sql. I have several data represented as follows: FECHA ERROR1 ERROR2 2017-01-01 12 23 And I would like to transpose t...
asked by 17.08.2017 / 09:34
1
answer

Detect UPDATE with trigger

My table of entradas you have a field precio , the price is assigned from my other table entrada_detalles automatic by trigger with INSERT my problem is that if in table _detalles the price is modified it does n...
asked by 05.05.2018 / 07:38