1234567891011'콤보박스에 해당하는 값 받아오기/ 해당콤보박스, 원하는 Sub FindComboIndex(ComboName As ComboBox, Value As String) For i = 0 To ComboName.ListCount - 1 Step 1 If Value = ComboName.List(i) Then ComboName.ListIndex = i Exit Sub End If Next End SubColored by Color Scriptercs
1234'_ 로 마스크 된 텍스트박스 검증을 위해서는'_ 를 지우고남은 length 를 계산해준다IF NOT Len(Replace(MaskTextBox.Text) , "_" , "")) = 14 THEN Colored by Color Scriptercs
1234567 SELECT *FROM INSAMSTwhere (@gubun = 'Y' AND (ToiDate != '____/__/__' and ToiDate = @ToiDate OR ToiDate = '____/__/__')) Colored by Color Scriptercs 1234567891011121314and ( (@GuBun = 'Y' AND (Insa.ToiDate >= @ToiDate or Insa.ToiDate = '____/__/__')) or (@GuBun = 'N' and Insa.ToiDate != '____/__/__' and Insa.ToiDate
동적 쿼리 예제 12345678910111213141516DECLARE @sql VARCHAR(MAX) SET @sql = "SELECT * FROM dbo.InsaMst where"; IF @Gubun = 'Y' sql += ToiDate != '____/__/__' and ToiDate = @ToiDate or ToiDate = '____/__/__') ELSE sql += ToiDate = ToiDate exec(@sql) Colored by Color Scriptercs
where 절에서 and 연산 사이에 같은값 or로 묶을려면 그냥 ( ) 괄호로 묶어줘야 예외가 생기지 않는다!1(Insa.ToiDate >= @ToiDate or Insa.ToiDate = '____/__/__')cs
123-- ISNULL ( "null check 값" , "null이면 보여줄 값" ) ISNULL(max(InsaCode)+1,CONVERT(CHAR(4),CURRENT_TIMESTAMP,12) + @CompCode + '001') Colored by Color Scriptercs
