For using of SQL expressions in a recordset of VB6 we use variable string
for example
Dim strsql AS String
strsql="SELECT code FROM material WHERE name=' " & st & " ' "
How using of double qoutation and qoutation is important ( ' ) and ( " )
now if we want to use one string into another string we use qoutation ( ' )
st is a string variable if we want to use strings in st and these strings contain qoutation
it cause one error
for example :
Denhard's solution------------>st
Rob's------------>st
excuse me for my english it isn't good
thank everybody reply me
Start Free Trial
