Posts by Rick Wolff • 569 points
16 posts
-
0
votes1
answer206
viewsA: Oracle TO_DATE is converting wrong dates from day 07/01/2020
My client’s server had a clock set for daylight saving time and was left with this error because in 2020 we were supposed to have daylight saving time in Brazil. I imagine it happened to be an old…
oracleanswered Rick Wolff 569 -
3
votes1
answer206
viewsQ: Oracle TO_DATE is converting wrong dates from day 07/01/2020
The TO_DATE function of the Oracle database is doing the following conversion wrong: The two lines are exactly the same. It makes no sense (for me), the Oracle convert right the date of Tuesday and…
oracleasked Rick Wolff 569 -
2
votes1
answer1538
viewsQ: The . NET Framework 4.7.1 or a later update has already been installed on the computer
While trying to install the newer version of . net, an error appeared informing: Installation will not occur. See the reasons below. Details The . NET Framework 4.7.1 or a later update has already…
-
2
votes1
answer1538
viewsA: The . NET Framework 4.7.1 or a later update has already been installed on the computer
What happened is that I was trying to install the Runtime version of the . net framework, used by windows to run the programs. And the correct version is the development version (Developer pack). I…
-
2
votes3
answers76
viewsA: Error using HAVING in date/time query
Depending on the database you are using, you cannot use HAVING a column being created in the SELECT An alternative would be: SELECT ROW_NUMBER() OVER(ORDER BY V.DATA ASC) AS ID, V.CHAPA AS CHAPA,…
-
2
votes1
answer53
viewsA: Search for objects in Runtime
The Timer has an event Elapsed (Timer.Elapsed) where you can check (with a global variable) if this timer still needs to be run. If you don’t need it, you disable it. In the case of…
c#answered Rick Wolff 569 -
5
votes3
answers10321
viewsA: select from date in postgresql database
Utilize >= to bring only more recent dates: SELECT * FROM tabela Where data_entrevista >= '2016-10-19 00:00:00'
-
2
votes2
answers785
viewsA: How to show the result of a query based on the result of another?
You can use a SELECT DISTINCT with the UNION between the two consultations SELECT DISTINCT * FROM ( SELECT * FROM CONSULTA_A UNION SELECT * FROM CONSULTA_B ) CONSULTAS The UNION will merge the…
-
6
votes1
answer489
viewsA: Compare COUNT from two tables
You’d have to repeat all the code of the two Select count... within the THEN and of ELSE. Or... You can make a subselect: SELECT CASE WHEN FAMILIAR > PERSONAL THEN FAMILIAR ELSE PERSONAL END AS…
-
0
votes2
answers66
viewsA: SQL filter (Result that should not appear)
I believe this SELECT can help you solve: SELECT Ah.horariosfixos FROM agendamento_horarios Ah LEFT OUTER JOIN agendamento Ag ON Ag.horaInicio <= Ah.horariosfixos AND Ah.horariosfixos <…
-
1
votes1
answer1049
viewsA: Datadirectory C#
The constructor of the Sqlconnection class takes the entire Connectionstring as its parameter. Not only the location of the database. You have already tried concatenating the file path into the…
-
5
votes3
answers257
viewsA: Show property value instead of class name in Datagridview
Initially I see 2 options: Include a new property IdCategoria in your DTO: public class Despesa { public int id_despesa { get; set; } public Categoria categoria { get; set; } public string descricao…
-
1
votes1
answer48
viewsA: Select turning different records into single
You might get this by using the function PIVOT oracle: https://www.techonthenet.com/oracle/pivot.php SELECT * FROM ( SELECT carro, ano, preco FROM sua_tabela ) PIVOT ( sum(preco) FOR ano IN (2016,…
-
1
votes1
answer44
viewsA: Merge controllers
In the first controller setting you can inject the second controller: notifyApp.controller('primeiroCtrl', ['$scope', 'notifyCtrl', function($scope, notifyCtrl) { (did not come the first controller…
-
2
votes1
answer1275
viewsA: Allow null value in relationship field
By the structure of your table sales_order, the column fk_coupons is part of the primary key. You cannot have value-less primary key (null). If you really need it and you can take it fk_coupons of…
-
2
votes2
answers1532
viewsA: Send request get and receive data
In addition to the @Gypsy response, you should change the Method to "GET". req.Method = "GET"; WebResponse response = req.GetResponse();
c#answered Rick Wolff 569