blinx
10-13-2004, 08:36 PM
Hey, I have some problem here...
I test my string but it perform the error way
--------------------
Dim fstring As String
fstring = "exec sp_bfm_c"
MsgBox sqlstring & " " & "where cabang = '" & Combo2.Text & "' and week = '" & Combo4.Text & "' and year= '" & Combo5.Text & "' "
I need string like this : exec sp_test_c '10','20','2004'
but after I test it using msgbox it come lie this : exec sp_test_c '10 ','20','2004'
so the error : '10 ' <-- There is 1 space between 0 and ' and it create error for my stored procedure
How to solve this ?
Thx
I test my string but it perform the error way
--------------------
Dim fstring As String
fstring = "exec sp_bfm_c"
MsgBox sqlstring & " " & "where cabang = '" & Combo2.Text & "' and week = '" & Combo4.Text & "' and year= '" & Combo5.Text & "' "
I need string like this : exec sp_test_c '10','20','2004'
but after I test it using msgbox it come lie this : exec sp_test_c '10 ','20','2004'
so the error : '10 ' <-- There is 1 space between 0 and ' and it create error for my stored procedure
How to solve this ?
Thx