OCLOperators sqlpassthroughobjects

Examples of how to use the sqlpassthroughobjects

The two examples below can be used in a derived association.

If you already have the primary key available, you can do this:
Kundfaktura.sqlpassthroughobjects('select ' + self.FakturaReferensnummer.toString )->first
If you are looking for a specific object using some field:
Kundfaktura.sqlpassthroughobjects('select FAKTURA_ID from tbl_FAKTUROR where FAKTURA_ID = ' + self.FakturaReferensnummer.toString )->first
Notes:
  • You can use @variable in your SQL because it is an automatically available variable 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).
This page was edited 8 days ago on 01/23/2025. What links here