Posts by R.Santos • 2,251 points
201 posts
-
0
votes3
answers43
viewsQ: Prohibit lines from being exactly the same in the database
I have a system that integrates data from three different banks, more specifically the registration of the companies of these three banks, I created a table where are stored the integrations that…
-
0
votes1
answer585
viewsQ: Make a denial in an IF codition
I have the following condition IF: (ClientesBDM.getNomeEmpresa().toString().equals(ClientesBD.get(1).toString())) How can I verify if the variables are different, ie deny this condition in the same…
-
0
votes1
answer39
viewsA: Javascript comparison this jumping straight
I figured out what I needed from that question, it is not that my variable was blank or null and yes it is that it had not been defined yet…
javascriptanswered R.Santos 2,251 -
0
votes1
answer39
viewsQ: Javascript comparison this jumping straight
I’m making a registration page with 5 dropdowns on each line, but the user will not be required to complete all dropdowns to complete the registration, for example, if the user fills the entire…
javascriptasked R.Santos 2,251 -
0
votes0
answers412
viewsQ: How to create an Arraylist in javascript or JSON and fill it
I am developing a shopping page, where there are dropdowns that displays the options of products that the customer can buy, need that when the user click on add the content of this line is added in…
-
1
votes1
answer248
viewsQ: How to access data from a subArray with Javascript
I need to access the data of a subarray via javascript, I can currently access the content of the entire array: What I need to take on the case is codigoImpressora that is inside the subarray…
-
1
votes2
answers152
viewsQ: Add column in a table already used by a program, could it harm the functioning of it?
I have a Postgresql database that is used for an application developed in Delphi, but now I will have to use this same bank for a new application that will be developed in Java, need some columns…
-
0
votes0
answers253
viewsQ: It is possible to store a list in JSON file
I am displaying data that is brought from the database in some Dropdowns, as if it were a kind of website shopping cart page E-commerce, at the moment my page is like this: But I need to store this…
-
3
votes1
answer140
viewsQ: Using Hash, without adding a Salt string to the password, can make the password vulnerable?
A little while ago I needed to figure out which hash had been used to save passwords in the bank so that they were not directly saved according to what the user launches at the time of their…
-
0
votes1
answer498
viewsA: Choose an "x" file inside a java directory
public static void getImgs(String path){ File file = new File(path); // Diretório dos arquivos File[] arquivos = file.listFiles(); for (File arquivo : arquivos) { System.out.println(arquivo); //…
-
0
votes4
answers6374
views -
1
votes2
answers1472
viewsA: Trigger that updates record in a table
My Funtion() in the end it was like this: CREATE OR REPLACE FUNCTION public.atualiza_transportadora() RETURNS trigger AS $$ begin IF NEW.nome <> OLD.nome \\ Aqui eu verifico se houve a…
-
2
votes2
answers1472
viewsQ: Trigger that updates record in a table
I need to update an X table whenever there is a change in table Y. I have found numerous examples of how to save the changed records in table Y, both when deleting a record from table X and when it…
-
1
votes1
answer107
viewsQ: Encrypt password in groovy
I am developing an application that will have a login screen that will be based on data (user, password) already saved in a database Mysql, and so I thought I would apply the same Hash which was…
-
0
votes1
answer3105
viewsA: How to assign the value of an Excel column in an SQL command
I was able to release the Parameter in Properties of the connection changing my SQL command to this: SELECT customer_id FROM `otrs`.`ticket` where (tn = ?) So when trying to execute the command a…
-
0
votes1
answer3105
viewsQ: How to assign the value of an Excel column in an SQL command
I was able to connect to my Mysql Database via ODBC, and display the information I need via SQL command, but I would like the contents of a particular cell of my spreadsheet to be in this SQL query,…
-
0
votes1
answer165
viewsQ: Display return of an SQL query in Excel
My question is divided into two parts. The first, it is possible to perform SQL command by Excel, because I need to display certain information from my Mysql database in an Excel table. Observing: I…
-
2
votes1
answer858
viewsQ: Error trying to connect via ODBC to Mysql
I’m trying to make a connection via ODBC with the Mysql Database to access data in Excel, but after performing all necessary settings the following error window is shown to me: So I set up the…
-
1
votes1
answer3300
viewsA: How to search any part of the string with mysql
Since what you want doesn’t start with Ste no use you performing a select like this ste% because it will return to you everything that begins with Ste followed by anything. So I can take everything…
-
0
votes2
answers527
viewsQ: Format date when performing Update in the registry - Postgresql
I am saving in my database the date that certain record is changed, however the format that it is saved is (YYYY-MM-DD), the SQL command used so far is as follows:: update public.transportadora set…
-
0
votes1
answer113
viewsA: Connect external bank to UI Designer in Bonitasoft Community
After much research and help from a user with more experience and knowledge of the tool, I was able to display the information that is in my external database in my UI Designer. Initially I had to…
-
0
votes2
answers413
viewsA: Display 5 latest postgresql results
You can create a command SQL that meets your need: SELECT id, project_id, name, subject from "issues" where project_id = 94 and project_id = 95 order by id desc limit 5 Where where project_id = 94…
postgresqlanswered R.Santos 2,251 -
0
votes2
answers206
viewsA: Select from an array inside another array
I was able to access the data from the subArrays as follows: List item = new ArrayList(); // Array que irá receber os registros de cada subArray def x = 0; def i = listaTransportadoras.size();…
-
0
votes1
answer205
viewsQ: More efficient way to compare two variables type List
I have two variables of the type List that need to be compared to each other to verify possible duplicates. Example of Variable Contents Variable 01: [01, Test, Active] Variable 02: [01, Test,…
-
1
votes1
answer74
viewsQ: What makes a source code an easy to maintain code?
During the technical course I took, I often heard my programming teachers (C# and JAVA) speak about the importance of developing easy-to-maintain code, but what in itself determines that a source…
-
0
votes1
answer53
viewsA: About String Handling
I had the same problem recently, I generated a script with the information inserted in my old Firebird database to add in Postgresql, but the date information came without the quotes, the solution…
-
4
votes1
answer684
viewsQ: What would be Iteration?
In a question I asked, I questioned what it was and what would be the function of ListIterator, then came the term iteration, what would that be? Link to question…
-
0
votes0
answers97
viewsQ: What is Listiterator and what is it for?
What would be the function of ListIterator? I have a variable of type List, that receives the information from my Postgresql Database, I need to access the information of this type variable List but…
-
4
votes2
answers12845
viewsQ: How to get the names of all Postgresql database tables?
How to get the names of all Postgresql database tables? How to get the attributes(code, name, etc...) of a given table in the Postgresql database?
-
0
votes2
answers206
viewsQ: Select from an array inside another array
I own a ArrayList which has other ArrayList within it, I got through the following scrip on Groovy: def i0 = listaTransportadoras.get([0]); def i1 = listaTransportadoras.get(1);…
-
0
votes1
answer58
viewsA: Select all records from a table with Groovy
Solved the problem, I needed to first find out the number of columns that mine ResultSet and then perform a While until the number of columns ended thus began to display all the records correctly,…
-
0
votes1
answer58
viewsQ: Select all records from a table with Groovy
I need to get all the records from a table from a script in Groovy, but with the script that I created it is taking only one record of each column and out of order too. Mine script this way: List…
-
0
votes1
answer4240
viewsA: Insert Oracle column after an existing column
To add the column dating on the table user ALTER TABLE usuario ADD (datacriacao date) However it is not indicated to change the sequence of the columns as you want, here the reason is explained…
-
3
votes3
answers494
viewsA: Extract information from a.txt file
Use regular expressions to perform the required file extraction .txt, to get what you need I used the following expression: :\d. d{3} Test here…
-
3
votes1
answer113
viewsQ: Connect external bank to UI Designer in Bonitasoft Community
I’m using the tool Bonitasoft to develop a project BPM, I have a database Postgresql that through a connection JDBC I was able to enter and change records by Bonitasoft, but I can’t select the…
-
1
votes1
answer1564
viewsA: Update Postgresql by Pgadmin without SQL command, but by Interface
After the help of @rray user I was able to solve the problem, the error was in my tables that did not have primary key and for this reason it was not possible to change the records directly by the…
-
0
votes2
answers2287
viewsA: Rename table in Firebird
Victor, Taking a look at your question, and after a search, really by the traditional command of ALTER TABLE cannot rename a table, but I found something that can help you, take a look at this SQL…
-
1
votes1
answer1564
viewsQ: Update Postgresql by Pgadmin without SQL command, but by Interface
I need to change certain data from my database PostgreSQL for PgAdmin but I’d like it to be straight through the PgAdmin and not through SQL commands, this is possible. For example when I want to…
-
1
votes1
answer40
viewsQ: Error changing old database data
With the help of this reply I was able to edit the data I enter in the database, but the old data that is already registered, when I try to change the registration, the program continues to close…
-
0
votes2
answers78
viewsQ: Failed to make a database change
When I’m gonna make a Update on the table Impressora my program is closing itself, while debugging the program the following error has been accused: My Update is this way: begin if…
-
1
votes1
answer111
viewsQ: Error saving data from a Radiogroup
I’m having a problem saving the information I select in one RadioGroup in the database, after making the change that was suggested in this question the error of trying to add something in the column…
-
0
votes1
answer63
viewsQ: Failure to enter data in the database by Radiogroup
I’m trying to save information in the bank through a Radiogroup, but instead of saving it in the column Status I hold the floor active he tries to find the column active. my form is like this: And…
-
1
votes5
answers1664
viewsA: I want to put the number of characters and put whether it even or odd
namespace Impar_ou_parr { class Program { static void Main(string[] args) { string NumLetras; Console.WriteLine("Digite uma Palavra: "); NumLetras = Console.ReadLine(); int…
-
1
votes2
answers4035
viewsQ: Generate Postgresql Server backup with password via command line
I need to perform an automatic Backup of a Postgresql server, I have a command that makes this backup but it always asks me the password and I could not find a command where I can already determine…
-
0
votes1
answer221
viewsQ: Error passing script from Firebird database to Postgresql
I’m trying to pass a script for creating and inserting data from a Firebird database to Postgresql, but in some tables there is a syntax error, I am using the SQL Manager Interbase & Firebird…
-
0
votes1
answer469
viewsQ: Assign value to a Boolean variable according to selected Radio Button
I’m trying to implement my application, where the table empresa won a new column called status, which would be completed in accordance with Radio Button this would serve so that when generating the…
-
1
votes2
answers81
viewsQ: Is it possible to make Postgresql database data visible or not, without erasing it?
I have an application where in addition to registering and consulting clients, it allows to issue reports with customer information, the problem is that many of these customers already registered do…
-
0
votes1
answer1510
viewsA: Create Server in pgAdmin 4 with external IP
I found that the error was not actually in my machine but in the Server where the Postgresql was installed, there file settings pg_hba.conf wrong configuration of hosts that allowed access to the…
-
0
votes1
answer1510
viewsQ: Create Server in pgAdmin 4 with external IP
I am trying to create a server with external IP in my pgAdmin 4, but the following error occurs when I try to save it: Accessing the file pg_hba.conf I found that the same is so currently: TYPE…
-
5
votes1
answer9873
viewsA: How to backup a Postgresql database via pgAdmin 4
Although it is not exactly the answer that solves my question, but this Database Backup method worked for me. Briefly, by means of pgAdmin 4, as much as I tried the Backup always gave error, so I…