Hi all,
I have this problem with ODBC:
I create a test table like this:
CREATE TESTTABLE (CODICE CHAR(5), VALORE INTEGER DEFAULT 0)
When I run this statement from Visual FoxPro, it runs ok
cSql="INSERT INTO testtable (codice) VALUES ('12345')
sqlexec(nConnHandle, cSql)
result is
codice valore
------- -------
12345 0
When I run this, it runs ok
cSql="INSERT INTO testtable (codice, valore) VALUES ('12345', NULL)
sqlexec(nConnHandle, cSql)
result is
codice valore
------- -------
12345 ?
But if I assign a variable
cCodice='12345'
nValore=NULL
cSql="INSERT INTO testtable (codice, valore) VALUES (?cCodice, ?nValore)
sqlexec(nConnHandle, cSql)
it returns this error:
Connectivity error: [SAP AG][SQLOD32.DLL] Integrity constraint violation.
Why?
Thanks in advance
Andrea Chiad� Piat
Bit Informatica s.r.l.
Progettazione e Sviluppo
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
