|
Failed to parse SQL
Posted: 28 Jul 10 6:51 AM
|
I've tried
set objCon = Application.GetNewConnection
Contact=Application.BasicFunctions.CurrentContactID
objCon.Execute("insert into abu_notifications(contactid,kind,nday,period,lang) values('C6UJ9A000DV6','1',to_date('20100727','yyyymmdd'),'1','ua')")
and I have error "Failed to parse SQL"
If I tried to execute this SQL string direct on server via toad everything is fine.
In SLXProfiler I found two error message
Failed to parse SQL. (SQL: "{ call insert into abu_notifications(contactid,kind,nday,period,lang) values('C6UJ9A000DV6','1',to_date('20100727','yyyymmdd'),'1','sdfsf') }")
and
Failed to parse SQL. (SQL: "select * from insert into abu_notifications(contactid,kind,nday,period,lang) values('C6UJ9A000DV6','1',to_date('20100727','yyyymmdd'),'1','sdfsf')")
And I can't understand why in 1st script SLX added "call" and what is purpose of second script |
|
|