Posts by Gabriel Santana • 372 points
23 posts
-
-2
votes1
answer16
viewsA: Usestate changes to Undefined at the time of saving the photo
I found the answer. For those who need follow the link below: https://stackoverflow.com/questions/65505954/image-picker-save-uri-with-hook…
-
-1
votes1
answer16
viewsQ: Usestate changes to Undefined at the time of saving the photo
I need to save the path of the photo taken through the camera.takePictureAsync. I created the variable through the Hook concept as defined below: const [path,setPath] = useState(''); When the…
-
0
votes1
answer15
viewsA: Differentiate Markers from React-Native-maps that have the same coordinates
I ended up giving a solution to adjust the Marker. I moved the superimposed Marker 0.001 of latitude and longitude.
-
-1
votes1
answer15
viewsQ: Differentiate Markers from React-Native-maps that have the same coordinates
I am mounting a map that will draw multiple markers( Marker). However, it is possible that some markers have the same coordinates. Testing the application, I noticed that markers that have the same…
-
0
votes1
answer37
viewsA: How to import java class from another app’s src folder?
From what I understand you are wanting to create a library - a standalone module to be reused by various applications. In this case you will need to create a separate project and reference the…
-
-1
votes1
answer40
viewsA: SQL queries with multiple tables
You can use the following query structure: select * from Carteira inner join Movimento on Carteira.id = Movimento.carteira_id inner join Ativo on Ativo.id = Movimento.ativo_id NOTE: You have to be…
-
5
votes2
answers103
viewsA: Memory organization when there is inheritance
In this case you have a conceptual error. The Employee class is a specialization of the Person class. This means that the Employee class can and should normally have attributes and methods that are…
-
0
votes1
answer46
viewsA: Auto increment skipping values
You could create the following method: public bool VerificarLoginExistente(string login) { comando.CommandText = "select * from funcionario where email = @login";…
-
4
votes2
answers48
viewsA: How to create a View with 2 tables with different columns in SQL?
You could create these columns with the artificial value NULL. EX : CREATE OR REPLACE FORCE VIEW "Resumo_vendas" ( "TIPO_REGISTRO" ,"VLR_DESCONTOS" ,"VLR_ACRESCIMOS" ,"VLR_PIS" ,"VLR_COFINS"…
-
1
votes3
answers70
viewsA: Because I would do Downcasting and Upcasting on C#
Let’s see if I can help you. Setting: Imagine that you are developing a game. In this game you present on screen some types of animals (Lion, Zebra, Man, Frog, Kangaroo, etc). All these animals…
c#answered Gabriel Santana 372 -
0
votes1
answer25
viewsA: operation with date and deadlines SQL_SERVER
In sql you could use the DATEADD function. It has the following parameters: DATEADD (part of date, number to add , date ) In your case DATEADD(Month (Your deadlines are defined in months);deadline;)…
-
0
votes1
answer44
viewsA: Doubt about the top of a stack in the Java language
Being you implementing the concept of stack in a vector, the top of the stack will be index 3 if you are always inserted from the lowest index to the highest. Remember that the battery concept is…
javaanswered Gabriel Santana 372 -
-2
votes1
answer31
viewsA: My first script and I can’t fix the error
CREATE TABLE Aluno ( Id_Aluno VARCHAR(100) NOT NULL, Rgm NUMBER(8) NOT NULL, Cpf NUMBER(11) PRIMARY KEY, Nm_Nome VARCHAR(100) NOT NULL, Nm_Mae VARCHAR(100)NOT NULL,…
sqlanswered Gabriel Santana 372 -
0
votes2
answers42
viewsA: combobox C#, Selectedtext vs Selecteditem.Tostring()
The Selectedtext property returns or changes the selected text in the combobox. Its Return type is a string. The Selecteditem property returns or changes the Combobox Item. Its return type is an…
-
0
votes1
answer41
viewsA: Why fractionate an Insert improves its performance?
This can be very relative. It can depend on the configuration and structure of the bank itself. In Sql Server this can usually be related to the fact that the bank needs to reserve resources for the…
-
1
votes1
answer120
viewsA: SUBSELECT WITH COUNT(*) SQL
The error of your query is related to the fact that the subquery is returning more than one column. For, the main query filter is just waiting for a set of cpfs. Don’t make the mistake you should do…
-
1
votes1
answer52
viewsA: Runtime recursive function
In this case it would be more interesting for you to make the start and end measurements before and after the recursive method call. Create a method to perform this measurement. Ex: public void…
-
0
votes2
answers47
viewsA: Select separate rows in SQL by adding deletion with different keys
See if with the NOT EXISTS clause applied as the query below resolves. SELECT DISTINCT * FROM wp_posts p INNER JOIN wp_postmeta m ON p.ID = m.post_id WHERE (p.post_status = "wc-processing" AND…
sqlanswered Gabriel Santana 372 -
1
votes1
answer58
viewsA: SQL does not calculate with NULL values
Try using the ISNULL function to see if it solves according to the example below: SELECT U.NOME, CAST(SUM(R.CAMPOCALC1) as NUMERIC (15,2)) AS CREDITO_FLEX, CAST(SUM(CASE WHEN ISNULL(R.CAMPOCALC2)…
-
1
votes1
answer29
viewsA: SQL SERVER delete record after UPDATE
You can try this using Triggers. See if the lab below helps you: 1 - Create Two Tables (Table1 and Table2) CREATE TABLE dbo.Table1 ( id INT, descricao NVARCHAR(40) ) CREATE TABLE dbo.Table2 ( id…
-
1
votes1
answer997
viewsA: React-Activate Generated Apk not working
I had that problem once. I deleted the files from the C: Seuapp android app build outputs apk release - folder (the output.json and .apk file that were inside that folder). Then I executed the…
react-nativeanswered Gabriel Santana 372 -
0
votes1
answer32
viewsA: How do I convert a date into varchar?
Verify that the created temporary table generated the DATE type for the Payment Date. It may be that the type is different from DATE and you are dealing with the wrong type. Ex: In the code below I…
-
3
votes3
answers90
viewsA: (C#) How can I replace a specific character "x" with "y" in a String?
Try using the code below. String s = "@@bb@@@"; s = s.Replace("@", "A"); The Replace method of the String class will replace all occurrences of @ with A. I recommend you study the documentation…