Posts by Lindomar Lemos • 178 points
15 posts
-
1
votes3
answers8939
viewsA: What is the correct way to declare a string in C?
I played a little struct to see if I could do a string implementation. I did, but I don’t think it works to write to a text file. I haven’t run the test yet. #include <stdio.h> #include…
-
2
votes4
answers10625
viewsA: Constructing SQL tables - use or not fields with Not Null?
Hello. I always have this problem of the default value in the field. First always left with Default Null, If the user filled or not the table would accept. When I started the relationship with other…
-
0
votes1
answer61
viewsA: C# - Do not show form being mounted for the user
I figured out what’s taking so long. I had placed the bank load and the other modifiers in the block "Initializecomponent();" which is the form builder. Then I opened the event form_Load(Object…
-
0
votes3
answers3666
viewsA: Connect Mysql C#
I use the following form to make the connection. class Conexao{ private const string _strCon = @"server=meuProvedor.com.br;" + "user id=Meu_Login;" + "password=Minha_Senha;" + "database=Meu_banco;"…
-
0
votes1
answer896
viewsQ: Access function equivalent to COALESCE
Hello. I’m trying to build an INSERT with auto numbering in Access, but I’m not getting it. In SQL Server, Mysql and Postgres I use the COALESCE function, but I can’t find this function in Access.…
-
2
votes2
answers309
viewsA: MYSQL - Using SUM with Join
SELECT O.ID_OP, SUM(O.QTD) AS QUANT, SUM(O.QTD * P.PESO) FROM OP_ITENS O LEFT JOIN PRODUTOS P ON O.ID_PROD = P.ID GROUP BY O.ID_OP; I grouped the ID_OP of the table OP_ITENS and added what had…
mysqlanswered Lindomar Lemos 178 -
0
votes0
answers62
viewsQ: SQL Server - Create View on a server with tables from another server
Hello. We had an SQL Server with three banks, one of the application I develop, another two of two different systems, the Company’s ERP system and the Online Ordering system. This system of Online…
-
2
votes1
answer2301
viewsQ: SQL Sends NULL value to a Datetime column
I have a form in VB.NET where the user informs the delivery dates and delivery forecast of the order and other information. Since he does not yet have, for example, the delivery date because he has…
-
1
votes1
answer2787
viewsQ: C# Datagridview align header in center
I am suffering to be able to align the header of Datagridview. I want the text to be centered in the center. Here’s the code: dg.EnableHeadersVisualStyles = false; // Desabilita formatação padrão…
-
2
votes1
answer2448
viewsQ: Mysql display the sum field with null value
I’ve researched but I can’t find what I need. I have a chart where I have a record of debt and credit releases. These values are in the 'value' field. But I want to display this field in two…
-
1
votes3
answers3895
viewsA: Double click on a Datagridview line transports the data to a form
I consider the datagrid and the editing buttons and methods in the same form. So when an Insert, Update or Delete occurs, call the Select method to reload the datagrid.
-
0
votes3
answers4012
viewsA: Confirmation of closing the form
My code is like this in the main form: private void Form1_FormClosing(object sender, FormClosingEventArgs e){ var result = MessageBox.Show("Deseja realmente sair?", "Rei dos Pisos",…
-
1
votes1
answer61
viewsQ: C# - Do not show form being mounted for the user
Hello. In excel VBA has a very cool feature. Application.Screenupdating = False Application.Screenupdating = True This prevents showing the screen being mounted to the user and show only after all…
-
1
votes1
answer67
viewsQ: Error converting with Duocode using Winforms
I developed a C# application using Windows Forms, but wanted to convert to Javascript using Duocode. But it is giving the following errors: tryduocode.cs(7,14,7,21): error CS0234: The type or…
-
2
votes1
answer408
viewsQ: Query vector from one table to update another in C
Hello. I’m new here and I’m not even sure I was objective in the title. But come on. I’m almost done with my final C Algorithms project, and I’m unable to update one item from one table with…