Log in

OCLOperators Sqlpassthrough

From MDrivenWiki
Revision as of 12:25, 7 December 2022 by Stephanie (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


Note: There is also the operator OCLOperators PSEval that uses OCL instead of SQL.

Example of how the OCL look like to call a stored procedure

Anvandare.sqlpassthrough('sp_Upd_Losen ' + self.AnvId.asString + ', \'' + self.Anvandarnamn + '\', @aNyttLosenord', Int32) 


  • @aNyttLosenord here is automatically available because it's a variable available when the function is called
  • You need to quote strings to be passed (if they aren't variables), like self.Anvandarnamn above. The \' is an escaped quote in OCL (Escape codes)
  • Int32 at the end is the SQL server return code
  • Your expression starts with a class not an object

A use case and examples of using sqlPassThrough can be found here "PSExpression , or how to do things in the DB from MDriven"

Also look here OCLOperators sqlpassthroughobjects