Posts by Anderson Souza • 163 points
15 posts
-
0
votes1
answer82
viewsA: Create a Windows Service that calls an MVC
Your controller Awbcontroller has a builder: public AwbController(IAwbApplication awbApplication, IMovimentoApplication movimentoApplication) { _awbApplication = awbApplication;…
-
1
votes1
answer138
viewsA: How to remove the style when the checkbox is unchecked in Angularjs?
Try this: var app = angular.module("testApp", []); app.controller('testCtrl', function($scope){ $scope.inventory = {productName:false}; }) .checked{ background-color:grey; } .unchecked{…
-
0
votes2
answers82
viewsA: SQLSERVER compare two groups of results
I confess that still this nebulous what you want, but maybe it helps: select T4.NMEMPRESA, T1.NMESTOQUE from ESTOQUE T1 inner join PRODUTO T2 on T1.IDESTOQUE = T2.IDESTOQUE inner join…
-
0
votes2
answers668
viewsA: NG-REPEAT inside NG-REPEAT - ANGULARJS
try this <tr ng-repeat="tutorial in tutorials| filterData: 'sections'"> <td>{{tutorial.name}}</td> </tr> or use tbody <table> <tbody ng-repeat="section in…
-
0
votes1
answer24
viewsA: How to create a table in Hana Workbench by column?
CREATE COLUMN TABLE "NOMEDATABELA" ("ID" INTEGER CS_INT GENERATED BY DEFAULT AS IDENTITY NOT NULL , "ID" INTEGER CS_INT, "NOME" NVARCHAR(50), "IDADE" INTEGER CS_INT, PRIMARY KEY…
sapanswered Anderson Souza 163 -
1
votes4
answers70
viewsA: How to return the sum of the business value column, month by month, based on the starting data_column?
Complementing the reply of Henrique: SELECT SUM(valor_negocio) AS SOMA, MONTH(data_inicio) AS MES FROM negocio GROUP BY MONTH(data_inicio) In addition, if the selected data is greater than one year,…
-
2
votes2
answers35
viewsA: Select multiple tables by sorting by date
Try to use this; SELECT T0.NOME, T1.ENTRADA AS JORNADA_ENTRADA, T2.ENTRADA AS INTERVALO_ENTRADA, T2.SAIDA AS INTERVALO_SAIDA, T1.SAIDA AS JORNADA_SAIDA FROM COLABORADOR AS T0 INNER JOIN JORNADA AS…
-
0
votes2
answers395
viewsA: Treating JSON in C#
The Nuget Newtonsoft.JSON is a good solution for this type of situations. You can create a class and deserializar the return: Create a small example: https://dotnetfiddle.net/ZYGhBn…
-
3
votes2
answers86
viewsQ: ORM that can connect with 2 BD types (SQL or HANA)
Any suggestion of a ORM or Micro ORM that can connect/manipulate 2 different database types, not Imultaneos? The scenario: I already have an application that uses SQL, I need to adapt it to accept…
-
1
votes1
answer86
viewsA: Make input invisible in SAPUI5
A little late, but to whom it is useful. You can use the setVisible of sap.ui.core.control https://sapui5.hana.ondemand.com/1.36.13/docs/api/symbols/sap.ui.core.Control.html#setVisible In xml would…
sapanswered Anderson Souza 163 -
1
votes2
answers939
viewsA: I can’t find a resolution for that mistake
Check if you are importing the namespaces. The classes User and Acessoadd both are in a different namespaces than the Pecscon. If, for example, they are in a namespces called Users and Accesses…
-
0
votes1
answer37
viewsA: CLR . NET - ERROR -> 9521 exceeds the maximum accepted message size of 4,000
I identified that the error happened this is a limitation of the Sqlcontext.Pipe.Send("Sring") This method is responsible for sending msg to the SQL output. Nothing that would harm sending msg to…
-
0
votes1
answer37
viewsQ: CLR . NET - ERROR -> 9521 exceeds the maximum accepted message size of 4,000
My code makes a webapi post from a trigger in an SP that monitors my database. This POST works well for msgs of up to 4000 characters but above that the SP gives this error: "ERROR -> 9521…
-
0
votes7
answers54187
viewsA: Remove letters and special characters in a select
Query: DECLARE @temp TABLE ( string NVARCHAR(50) ) INSERT INTO @temp (string) VALUES ('003Preliminary Examination Plan'), ('Coordination005'), ('Balance1000sheet') SELECT SUBSTRING(string,…
-
1
votes2
answers1487
viewsA: Log4net.dll file not found
I believe you have already found the solution, but to register a possible solution. In many personal cases this occurred by version incompatibility. For Visual Studio 2015: Right click on the…
asp.netanswered Anderson Souza 163