Posts by Fabiano Pontes • 150 points
6 posts
-
1
votes3
answers14398
viewsA: How do I create a folder inside my Github repository?
Just create the folder inside the local repository and put some file in it. Git will automatically recognize it and when you run PUSH that folder as well as the files and subfolders will be…
-
2
votes2
answers48
viewsQ: SQL showing records if they only meet different conditions than usual
I have a slightly different situation, tried different conditions but none brought the desired result. My need is this: I have a base containing authors of books and their respective works. I need…
-
1
votes1
answer211
viewsA: Two conditions in Where do not bring a result
Try this SQL: SELECT * FROM PRODUTOS AS PR1 WHERE ENDERECO_1='A' AND (SELECT COUNT(*) FROM PRODUTOS AS PR2 WHERE PR1.CODIGO=PR2.CODIGO AND ENDERECO_1<>'A')=0 Anything, just call me.…
-
2
votes3
answers127
viewsA: Code does not work as expected
The only mistake I saw in the code was to treat the weight input as String. Demonstrated on the line append(int(input('Enter the weight: '))) cadastro = [] dados = list() while True:…
-
1
votes1
answer58
viewsA: Firebird: What to do when a framework uses a reserved word?
the ideal is not to use reserved words, but sometimes there are special situations that we need to use such words. In these cases you should name the field(column name) between quotation marks…
firebirdanswered Fabiano Pontes 150 -
2
votes1
answer79
viewsA: INSERT with SELECT in mysql
I don’t know what your database is, but try this SQL: UPDATE RELATORIO_PSI SET CONVENIO=(SELECT CONVENIO FROM PACIENTES WHERE RELATORIO_PSI.PACIENTE=PACIENTES.NOME) Anything warns me. Hug…
sqlanswered Fabiano Pontes 150