変数excecに文字列を入れているのですが、select caseすると,値はとれているのですが
そのあとに続けて最初のSELECT分から2回分、3回分となってしまいます。
SERECT・・・・・・SELECT・・・・・SELECT・・・
select case がいけないのでしょうか?
If文でやっていった方がよいのでしょうか?
VBA
1Sub SQL抽出() 2Dim n As String 3Dim excec As String 4 5 Set wb = ThisWorkbook 6 Set sh = wb.Worksheets("条件") 7 Set sql = wb.Worksheets("SQL") 8 9 r = sh.Range("C30").End(xlToRight).Column 10 11 excec = "" 12 excec = excec & "SELECT" 13 excec = excec & "count(distinct km_customer.cust_cd) " 14 excec = excec & "FROM " 15 excec = excec & "dba.km_customer INNER JOIN dba.km_member ON (km_customer.kigyo_cd=km_member.kigyo_cd and km_customer.cust_cd=km_member.cust_cd) " 16 excec = excec & "WHERE " 17 excec = excec & "km_customer.cust_cd " 18 19 For i = 3 To r 20 excec = excec & sh.Cells(32, i).Value 21 Debug.Print excec 22 n = sh.Cells(30, i).Value 23 Select Case n 24 Case "1" 25 excec = excec & " (select member_cd from " & "#login" & ")" 26 Case "2" 27 excec = excec & " (select member_cd from " & "#tabtouch" & ")" 28 Case "3" 29 excec = excec & " (select member_cd from " & "#age" & ")" 30 Case "4" 31 excec = excec & " (select member_cd from " & "#cate" & ")" 32 Case "5" 33 excec = excec & " (select member_cd from " & "#cate1" & ")" 34 Case "6" 35 excec = excec & " (select member_cd from " & "#sku" & ")" 36 Case "7" 37 excec = excec & " (select member_cd from " & "#sku1" & ")" 38 End Select 39 40 excec = excec & excec & sh.Cells(31, i).Value 41 Debug.Print excec 42 Next 43 44 sql.Range("B9").Value = excec 45 46 47End Sub
回答2件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2019/05/16 09:21