Posts by WEBIER • 11 points
5 posts
-
0
votes1
answer65
viewsQ: Change the number of decimals in the table structure (SQL SERVER)
Good Evening Everyone, I have 3 fields in a table that use the "Data type" defined as "decimal(15, 2)" and I need to change (via code) to "decimal(15, 3)". That is, change from 2 decimal places to…
-
0
votes0
answers38
viewsQ: CHECKBOX ON LISTVIEW DOESN’T MARK ALL CHECKS
Good afternoon Personal, I have the following structure: Table: User Codigo: 1 Login: João Codigo: 2 Login: Maria Table: User_permissions Codigo: 1 Permissao: 'ESTORNAR' Codigo: 2 Permissao:…
-
0
votes2
answers34
viewsA: Sub-consumption With Different Aggregate Results
My friend, you made a mistake in your code... I believe it’s because of the lack of the first subselect (inputs) Inner Join... I modified it and it was like this: SELECT CODIGO, DESCRICAO, (SELECT…
-
-1
votes2
answers34
viewsQ: Sub-consumption With Different Aggregate Results
Good afternoon, everyone, I have two queries that work perfectly separate, but need to display in a grid information of the two queries. I need to take all the inputs of a product and put in a…
-
-2
votes0
answers32
viewsQ: how to use "SET ARITHABORT ON" in vb6
Good afternoon Personal, I needed to use some commands to concatenate some records in a query... So far so good, I did it that way and it worked: SET ARITHABORT ON; SELECT COALESCE((SELECT…