Note: There is also the operator, OCLOperators PSEval, that uses OCL instead of SQL.
Example of how the OCL looks 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"
The return value is a Tuple.
Also, look here: OCLOperators sqlpassthroughobjects, PSEval, PSEvalValue, PSEvalTuples