Posts by Igor Grava • 1 point
2 posts
-
0
votes2
answers718
viewsA: SELECT that brings products active in one company and that are not active in all others
Good night Try something like that: IB OBJECT_ID('TEMPDB..#TEMP_01') IS NOT NULL DROP TABLE #TEMP_01 SELECT A.PRODUTO, SUM(CASE WHEN A.SITUACAO = 'A' THEN 1 ELSE 0 END ) AS OCORRENCIA_ATIVA INTO…
-
0
votes1
answer180
viewsA: Check if the listbox index exists?
Good night. Try the following code: If ListBox1.Items.Count > 0 Then If ListBox1.SelectedIndex = -1 Then ListBox1.SelectedIndex = 0 Else If ListBox1.SelectedIndex < ListBox1.Items.Count - 1…
vb.netanswered Igor Grava 1