Posts by Emerson JS • 1,574 points
57 posts
-
0
votes3
answers118
viewsA: Code repetition in the same method
Friend, centralize the repeated code in a new method, and call this method 2 times passing the parameters that change the behavior of the program. private void CriaPastaFarmInterna() {…
c#answered Emerson JS 1,574 -
2
votes1
answer80
viewsA: Query in SQL Server
Friend, probably the supplier’s data is in another table, correct? You can do this by bringing the related data (in this case the vendor name) from that other table. Let’s imagine that the name of…
-
1
votes1
answer1093
viewsA: Allocate search box in standard Bootstrap Navbar
Good morning friend, I do not know if I understood very well your problem. You want to use the buttons, including with the option of Collapse on the left and the search box on the right side of the…
-
1
votes2
answers335
viewsA: Problem retrieving inserted id
For cases where the automatically generated id return is required, the SQL Server has the clause OUTPUT. In most cases its use is more recommended compared to SCOPE_IDENTITY(). See example below.…
-
1
votes2
answers2102
viewsA: Compare values of the same field in a table
Buddy, you need to count the records by grouping them by person and value. Hence a clause applies HAVING to filter only counting results equal to 6. SELECT cod_pessoa FROM pagamentos GROUP BY…
sql-serveranswered Emerson JS 1,574 -
0
votes2
answers6151
viewsA: Which Mysql command kills the process if a query takes more than 20s to execute?
You can set up a timeout. This can be done on the server, on the connection itself, or only for the operation you want to perform. Set up a timeout 30 seconds, and if there is no response from the…
-
0
votes1
answer791
viewsA: Take data from 3 Ragments
The communication between Fragments and the Activity which makes use of them can be made through Interfaces. Each Fragment of your screen should declare a interface with one or more communication…