Parsed/OCLOperators sqlpassthroughobjects
This page was created by PageReplicator on 2025-09-01. Last edited by PageReplicator on 2025-09-01.
Examples of how to use the sqlpassthroughobjects[<a href="/index.php?title=Documentation:OCLOperators_sqlpassthroughobjects&veaction=edit§ion=1" class="mw-editsection-visualeditor" title="Edit section: Examples of how to use the sqlpassthroughobjects" data-bs-title="Documentation:OCLOperators_sqlpassthroughobjects">edit</a> | <a href="/index.php?title=Documentation:OCLOperators_sqlpassthroughobjects&action=edit§ion=1" title="Edit section: Examples of how to use the sqlpassthroughobjects" data-bs-title="Documentation:OCLOperators_sqlpassthroughobjects">edit source</a>]
The two examples below can be used in a derived association.
If you already have the primary key available, you can do this:[<a href="/index.php?title=Documentation:OCLOperators_sqlpassthroughobjects&veaction=edit§ion=2" class="mw-editsection-visualeditor" title="Edit section: If you already have the primary key available, you can do this:" data-bs-title="Documentation:OCLOperators_sqlpassthroughobjects">edit</a> | <a href="/index.php?title=Documentation:OCLOperators_sqlpassthroughobjects&action=edit§ion=2" title="Edit section: If you already have the primary key available, you can do this:" data-bs-title="Documentation:OCLOperators_sqlpassthroughobjects">edit source</a>]
Kundfaktura.sqlpassthroughobjects('select ' + self.FakturaReferensnummer.toString )->first
If you are looking for a specific object using some field:[<a href="/index.php?title=Documentation:OCLOperators_sqlpassthroughobjects&veaction=edit§ion=3" class="mw-editsection-visualeditor" title="Edit section: If you are looking for a specific object using some field:" data-bs-title="Documentation:OCLOperators_sqlpassthroughobjects">edit</a> | <a href="/index.php?title=Documentation:OCLOperators_sqlpassthroughobjects&action=edit§ion=3" title="Edit section: If you are looking for a specific object using some field:" data-bs-title="Documentation:OCLOperators_sqlpassthroughobjects">edit source</a>]
Kundfaktura.sqlpassthroughobjects('select FAKTURA_ID from tbl_FAKTUROR where FAKTURA_ID = ' + self.FakturaReferensnummer.toString )->first
Notes:[<a href="/index.php?title=Documentation:OCLOperators_sqlpassthroughobjects&veaction=edit§ion=4" class="mw-editsection-visualeditor" title="Edit section: Notes:" data-bs-title="Documentation:OCLOperators_sqlpassthroughobjects">edit</a> | <a href="/index.php?title=Documentation:OCLOperators_sqlpassthroughobjects&action=edit§ion=4" title="Edit section: Notes:" data-bs-title="Documentation:OCLOperators_sqlpassthroughobjects">edit source</a>]
- 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 (<a href="/Documentation:Escape_codes" title="Documentation:Escape codes" data-bs-title="Documentation:Escape_codes">Escape codes</a>).