Posts by Paulo Monteiro • 59 points
4 posts
-
0
votes2
answers43
viewsA: How to calculate the cumulative sum/subtraction of previous records in SQL?
I was able to solve using the following: SELECT sld.data, sld.tipo, CONCAT('R$ ', FORMAT(sld.valor,2,'de_DE')) as "valor", CASE WHEN sld.tipo = 'S' THEN CONCAT('R$ ',…
-
0
votes2
answers43
viewsQ: How to calculate the cumulative sum/subtraction of previous records in SQL?
I’m trying, unsuccessfully, to create a column SALDO in order to keep track of the Cash Flow balance. I imagined doing this in SQL itself, generating a column that would calculate the balance. For…
-
1
votes1
answer151
viewsQ: How to define the HREF property of HTML dynamically, with Alpine.js?
I have a Datatable table being powered by Alpinejs: <template x-for="user in users" :key="user.Id"> On x-for, I have the user.id value that I can list in a SPAN field, with the x-text…
javascriptasked Paulo Monteiro 59 -
0
votes1
answer182
viewsQ: Problem with fetch function using onClick event
I am developing a logic that until then works perfectly. Access an API by fetch, receive a token and run an SQL call to another API, using the token received, then treat the return to be displayed…