Can anyone spot something wrong with the way this sql is written?
Error says: Conversion failed when converting nvarchar value ' ' ' to data type int
Where's that value? I can't see ' ' '
vb6 Code:
connTrans.Execute ("EXECUTE " & executeCommand & " '" & txtBusinessPartnerCode.Text & "', ' '' ', '" & _ txtBusinessPartnerName.Text & "', '" & businessPartnerTypeSelection & "', '" & _ txtBusinessPartnerJMBG.Text & "', '" & _ txtBusinessPartnerBLK.Text & "', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', ' '' ', '" & userName & "'")




Reply With Quote