User bio
404 bio not found
Member since Jun 25, 2020
Posts:
Replies:
Certifications & Credly badges:
DMITRIY has no Certifications & Credly badges yet.
Global Masters badges:
DMITRIY has no Global Masters badges yet.
Followers:
DMITRIY has no followers yet.
Following:
DMITRIY has not followed anybody yet.
@Eduard Lebedyuk Thanks for the answer, but it not what I wanted, but you give me an idea; there is an $SYSTEM.SQL.EXECUTE function, so I add ClassMethod
ClassMethod EXECUTEBLOCK(aScript As %Library.String(MAXLEN="")) As %Library.String [ SqlName = EXECUTEBLOCK, SqlProc ] { //for case String value sended from the SQL context like "value" //e.g. SQLUser.EXECUTEBLOCK( 'INSERT INTO A(b,c,d)VALUES("d","e","f");INSERT INTO A(b,c,d)VALUES("g","h","h");') SET replacedScript= $Replace(aScript,$CHAR(34),$CHAR(39)) TRY{ SET retval = $SYSTEM.SQL.Execute(replacedScript,2,"MSSQL") RETURN retval.%Message } CATCH err { RETURN err.Name } }
, which I later called as a regular stored procedure, by
So it will be three DELETE statements at once.
Anyway, thanks for the idea.