Posts by Aron Linhares • 361 points
9 posts
-
3
votes1
answer350
viewsA: Change Sequence value with subselect
You can use a pl to do this. By storing the value of select within a variable using the into and then running the alter with the immediate execution. declare maxId number; begin SELECT MAX(ID)+1…
-
0
votes2
answers257
viewsA: Assign Value to a Non-method Array
From what I understand you are trying to print all permutations of an array. If so, has the Heap’s Algorithms that does this. Has a material from Robert Sandwick very cool talking about the…
javaanswered Aron Linhares 361 -
2
votes1
answer1181
viewsA: How to close a file in Java?
Then you have to close the Scanner for the "File" to be released, so it is likely that you will be able to delete your file. FileFilter filter = new FileFilter() { public boolean accept(File file) {…
-
7
votes4
answers6983
viewsA: Delete thousands of records from a table
Instead of you running delete to delete all records, you can create a PL and gradually delete and commit every x records, this will prevent you from "locking" other users. declare cursor c is select…
-
2
votes2
answers101
viewsA: check function always returning true
Try changing the command String.valueOf(et15.getText())!=retornadado("bt15") for false == retornadado("bt15").equals(String.valueOf(et15.getText() maybe this will solve. But I think you should think…
-
1
votes2
answers329
viewsA: How to know when two Threads ended up in Swing?
So, I don’t know if this is the best solution because I don’t move a lot with swing. But you need to wait for both "thread" to finish to warn the dialog. while( true ){ if( worker.isDone()…
-
3
votes2
answers394
viewsA: Updating field datetime sqlsrv
@Gustavosevero, follow the example of the code, as link $dataHoje = new DateTime(); $dataHoje = $dataHoje ->format('d/m/Y'); echo $dataHoje ;…
-
1
votes1
answer4024
viewsA: Merge sql results into one line
So I think to solve your problem you can use an aggregation function like GROUP_CONCAT mysql. select p.id_produto , p.descricao , c.id_codigo , group_concat(m.descricao order by p.id_produto, ', ')…
mysqlanswered Aron Linhares 361 -
1
votes4
answers599
viewsA: Program Locking in While
Guess your problem is because the "powershell.exe" is waiting for command in Runtime. And because of that the while "hangs" on execution. Because Process is waiting for new data to be read. I found…