Posts by Vitor Gabriel Alves da Silva • 26 points
2 posts
-
1
votes1
answer48
viewsA: Select in Json data
With this select you get everything that is inside subscriber: SELECT #suaColunaJson -> 'assinante' as assinante. FROM assinante With this other, you take everything that’s in code, inside the…
-
0
votes2
answers868
viewsA: Error: Incorrect decimal value: ' for column 'Value' at Row 1
As the user Maniero said, you must convert its string value '100.5' for example, to a floating value to record in the bank. It is recording 0.00 because probably its conversion function is returning…