Posts by Gustavo Pedro • 201 points
16 posts
-
1
votes0
answers92
viewsQ: Trigger to ban scale insertion that is already working on that SQL Server date
Thank you for your time! 1° I’ll put the data and then I’ll point out my doubt, I’ve tried a thousand times and I can’t get the logic that works. I have the following table Scale Table CREATE TABLE…
-
0
votes1
answer32
viewsQ: Save application shutdown mode
I have the following scenario: 1 application that runs on 10 machines, where when the application is running it is in on-line and when it’s not, that machine is like off-line, that communicates with…
c#asked Gustavo Pedro 201 -
1
votes1
answer139
viewsQ: Recover Select from Any Trigger
How can I get one back select of a trigger? Example: CREATE TABLE PESSOA2 ( ID INTEGER IDENTITY NOT NULL, NOME VARCHAR(250) ) CREATE TRIGGER SELECIONAR_NOME2 ON DBO.PESSOA2 AFTER UPDATE AS BEGIN…
-
1
votes0
answers100
viewsQ: Update Datagridview in c# via Trigger UPDATE SQL
Hello, I have the following question. I’m running a c# application with SQL Server database. I have a Datagridview where he is carried via Datatable, the information loaded is from people: Name,…
-
0
votes2
answers304
viewsA: Triggers INSTEAD OF Update, How to filter by date
TRIGGER INSTEAD OF INSERT CREATE TRIGGER IMPEDIR_ESCALA_MESMA_DATA_TIPO_INSERT ON ESCALA INSTEAD OF INSERT AS BEGIN --Termina se não há registos para processar IF NOT EXISTS (SELECT * FROM INSERTED)…
-
2
votes2
answers304
viewsQ: Triggers INSTEAD OF Update, How to filter by date
Hello, First of all thank you for all your time in the community. Come on! I will throw the information and then try, in the best possible way to explain the problem. I have 3 tables: Person List…
-
1
votes0
answers57
viewsQ: Open Form Via Contexmenustrip, random value click event
I have the following problem: I have 2 form FrmCadastroPessoa and FrmCadEscala. In FrmCadastroPessoa have the DataGridView shown, when I right click on a Cell, lists the scales the person is…
-
1
votes1
answer26
viewsQ: Selecting specific SQL Server values
First thank you for your time! I don’t know much about SQL, I have a question about how to perform a select. I have some tables, follow these as an example: How do I give a select to know the people…
-
1
votes2
answers78
viewsQ: Remove selection from a Strip Menu
I got the following Menu Strip: I would like when I move the mouse over it not to have the color blue. It’s just to be informative this and not to use as buttons. Using enable the Menu Strip turns…
-
0
votes1
answer100
viewsQ: Select Row in **Datagridview** right click
From now on I thank you for your time :D I have a dataGridView filled by a Datatable I want to select (fullRowSelect) it only when right-clicking and not left-clicking. Someone helps?…
c#asked Gustavo Pedro 201 -
1
votes1
answer505
viewsQ: Disable selection for Datagridview c# Windows Forms line
Hello, thanks for your attention I want to know how to disable the possibility of selecting a line from a Datagridview Meudatagridview.Rows[Line disabled]. enable = false; I’ve tried the Frozen:…
c#asked Gustavo Pedro 201 -
0
votes1
answer111
viewsQ: Pick Line Index clicked with the right button, remove the option to select in datagridview
First of all thank you for your time. I have a question: I have a Datagridview dgvPessoa filled with a Datatable. Example: I want you to select when right-click and not left-click, and pick the…
c#asked Gustavo Pedro 201 -
-1
votes1
answer32
viewsQ: Scan 4 selects and display message
Speak up, people, blz? I would like to know how to make the following logic in SQL: if( 1 = select * from tblA or 1 = select * from tblB or 1 = select * from tblC or 1 = select * from tblD or )…
-
1
votes2
answers127
viewsQ: Prevent Insert or Update If date is in a Registered range
I am with the following doubt: I have the table: Escala Data_Atuacao_Inicial, Data_Atuacao_Final, tipo The guy can be 1 or 2 I want to create a Rigger to stop the Insert or update of this table, if…
-
4
votes3
answers98
viewsQ: Sort select displaying something at the end after sorting
I have a table called Tabela1 and another call Tabela2: Tabela 1 Tabela2 Indice, pessoa_id sts, pessoa_id The index goes from 0 to 10, and sts can be ON-LINE, OFF-LINE OR ON-LINE-PAUSADO. I wish…
-
1
votes1
answer143
viewsQ: Open Form2 and Close Form1, making Form2 the main (without making it invisible)
Hello, I have the following problem: I got the forms FrmLogin and FrmSistema. When the user logs in to FrmLogin I open the FrmSitema, lathe the FrmSitema the FormPrincipal, and close the FrmLogin.…