Posts by Francisco Salome • 79 points
6 posts
-
2
votes0
answers42
viewsQ: scroll-snap in css is not working properly
I am creating an html page and am having the following problem: I had to use the method scroll-snap css to 'lock' a div at each mouse scroll. This 'snap' is working with a however, when 'roll' the…
-
1
votes1
answer699
viewsA: mysql error: 1054. Unknown column'mover_almox.cod_promob 'in 'Where clause' even if I am not using this column in the parameters
Joel reminded me that there was one more query being run along with the code above, which is a Trigger Befor Update: UPDATE cadastro_mp SET estoque_atual = old.movimentacao_almox.quantidade +…
-
1
votes1
answer699
viewsQ: mysql error: 1054. Unknown column'mover_almox.cod_promob 'in 'Where clause' even if I am not using this column in the parameters
I am trying to make an Insert in my database with the following command: UPDATE movimentacao_almox SET quantidade = 100, qtd_pendente = 2 WHERE id = 1113; but I get this mistake: Error Code: 1054.…
-
1
votes1
answer94
viewsQ: SELECT command in MYSQL is duplicating a result (which is not duplicated in the database)
I’m doing a simple select to return a table in Excel, but when I run the command, some rows are being duplicated in the result. Follow the code below: SELECT distinct movimentacao.DATA,…
mysqlasked Francisco Salome 79 -
0
votes2
answers82
viewsA: Doubts in the combobox
Try using the method. Additem With Cbo_Coordenador .AddItem .List(.ListCount - 1) = "nome do coordenador1" .AddItem .List(.ListCount - 1) = "nome do coordenador2" End With This would be a very…
-
2
votes0
answers282
viewsQ: Insert an image in the Excel spreadsheet with VBA but without the link to the original image
I am creating a table generator in Excel and need to insert several images that are in a certain folder. I make this insertion by the following code: altura = 3 On Error Resume Next For L = 1 To…