Из QA запускаю —
SET QUOTED_IDENTIFIER OFF
INSERT INTO Z_INTXT(TxtID, Abstract, Type) values(6,"HEPATITE CHOLESTATIQUE","C5*")
все работает.
Из VB6 с использованием ADO пишу —
...
str1 = "6"
str2 = "HEPATITE CHOLESTATIQUE"
str3 = "C5*"
Call cnnPBD.Execute("SET QUOTED_IDENTIFIER OFF")
InsSQL = "INSERT INTO Z_INTXT(TxtID, Abstract, Type) values(" & _
str1 & ",""" & str2 & """,""" & str3 & """)"
Call cnnPBD.Execute(InsSQL)
Ругаются —
The name 'HEPATITE CHOLESTATIQUE' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Почему ?