findReference() SFieldReference examples

"John Abraham [email protected] [SimpleORM]" <[email protected]> Fri, 28 Aug 2015 17:06:56 -0600
Newsgroups gmane.comp.java.orm.simpleorm
Message-ID <[email protected]>
--Apple-Mail=_FFE0BA70-0DCE-4721-B4AA-95D9E0FFB555
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

Does anyone have any example code defining  SFieldReference and using findR=
eference() they can send me?

For some reason I'm having a hard time figuring it out.  I already have SFi=
eldScalars for my fields, I think I'm supposed to use SFieldReference inste=
ad of SFieldScalars? Or as well? And what's the syntax if the field names d=
on't match, e.g. if I have a field called id_employee in the time_record ta=
ble that refers to a field called id in the employee table?

Looks like this is a "recent" addition from Franck, it seems I haven't used=
 it directly before. I'm querying the database directly for a lot of foreig=
n keys, instead of using the more efficient cascading search (through the d=
ataset and then the session) that's coded in SRecordInstance.findReference(=
).  Also, I'm a bit rusty on SimpleORM.

--
John Abraham
[email protected]
403-232-1060


--Apple-Mail=_FFE0BA70-0DCE-4721-B4AA-95D9E0FFB555
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: 7bit





<head>

<style type="text/css">
<!--

/* start of attachment style */
       .ygrp-photo-title{
         clear: both;
         font-size: smaller;
         height: 15px;
         overflow: hidden;
         text-align: center;
         width: 75px;
       }
       div.ygrp-photo{
         background-position: center;
         background-repeat: no-repeat;
         background-color: white;
         border: 1px solid black;
         height: 62px;
         width: 62px;
       }

       div.photo-title 
         a,
         div.photo-title a:active,
         div.photo-title a:hover,
         div.photo-title a:visited {
           text-decoration: none; 
       }

       div.attach-table div.attach-row {
         clear: both;
       }

       div.attach-table div.attach-row div {
         float: left;
         /* margin: 2px;*/
       }

       p {
         clear: both;
         padding: 15px 0 3px 0;
	 overflow: hidden;
       }

       div.ygrp-file {
         width: 30px;
         valign: middle;
       }
       div.attach-table div.attach-row div div a {
         text-decoration: none;
       }

       div.attach-table div.attach-row div div span {
         font-weight: normal;
       }

       div.ygrp-file-title {
         font-weight: bold;
       }
 /* end of attachment style */
        -->
        </style>
        </head>
<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">




Does anyone have any example code defining &nbsp;SFieldReference and using findReference() they can send me?<div><br></div><div>For some reason I'm having a hard time figuring it out. &nbsp;I already have SFieldScalars for my fields, I think I'm supposed to use SFieldReference instead of SFieldScalars? Or as well? And what's the syntax if the field names don't match, e.g. if I have a field called id_employee in the time_record table that refers to a field called id in the employee table?</div><div><br></div><div>Looks like this is a "recent" addition from Franck, it seems I haven't used it directly before. I'm querying the database directly for a lot of foreign keys, instead of using the more efficient cascading search (through the dataset and then the session) that's coded in SRecordInsta
 nce.findReference(). &nbsp;Also, I'm a bit rusty on SimpleORM.</div><div><br></div><div><div apple-content-edited="true">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;  "><div>--</div><div>John Abraham</div><div><a href="mailto:[email protected]">[email protected]</a></div><div>403-232-1060</div></span>

</div>
<br></div>



<!-- |**|begin egp html banner|**| -->

<br>


<br>

<!-- |**|end egp html banner|**| -->


<div width="1" style="color: white; clear: both;"/>__._,_.___</div>

      
  

    
    <div id="fromDMARC" style="clear:both; margin-top: 10px;">
         <hr style="height:2px ; border-width:0; color:#E3E3E3; background-color:#E3E3E3;">
         Posted by: John Abraham &lt;[email protected]&gt;         <hr style="height:2px ; border-width:0; color:#E3E3E3; background-color:#E3E3E3;">
    </div>
<!-- Start Recommendations -->
<!-- End Recommendations -->



<!-- |**|begin egp html banner|**| -->

  <img src="http://geo.yahoo.com/serv?s=97476590/grpId=7360226/grpspId=1705006905/msgId=2115/stime=1440803223" width="1" height="1"> <br>

<!-- |**|end egp html banner|**| -->

    
<!-- |**|begin egp html banner|**| -->

<br>



   
     
 
        <!-- |**|begin egp html banner|**| -->
        <div id="ygrp-vital" style="background-color: #f2f2f2; font-family: Verdana; font-size: 10px; margin-bottom: 10px; padding: 10px;">

        <span id="vithd" style="font-weight: bold; color: #333; text-transform: uppercase; "><a href="https://groups.yahoo.com/neo/groups/SimpleORM/info;_ylc=X3oDMTJlNDFiM2d0BF9TAzk3MzU5NzE0BGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTQ0MDgwMzIyMw--" style="text-decoration: none;">Visit Your Group</a></span>

     <ul style="list-style-type: none; margin: 0; padding: 0; display: inline;">
                                                    </ul>
  </div>


<div id="ft" style="font-family: Arial; font-size: 11px; margin-top: 5px; padding: 0 2px 0 0; clear: both;">
  <a href="https://groups.yahoo.com/neo;_ylc=X3oDMTJkZzlmMm9qBF9TAzk3NDc2NTkwBGdycElkAzczNjAyMjYEZ3Jwc3BJZAMxNzA1MDA2OTA1BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxNDQwODAzMjIz" style="float: left;"><img src="http://l.yimg.com/ru/static/images/yg/img/email/new_logo/logo-groups-137x15.png" height="15" width="137" alt="Yahoo! Groups" style="border: 0;"/></a>
  <div style="color: #747575; float: right;"> &bull; <a href="https://info.yahoo.com/privacy/us/yahoo/groups/details.html" style="text-decoration: none;">Privacy</a> &bull; <a href="mailto:[email protected]?subject=Unsubscribe" style="text-decoration: none;">Unsubscribe</a> &bull; <a href="https://info.yahoo.com/legal/us/yahoo/utos/terms/" style="text-decoration: none;">Terms of Use</a> </div>
</div>

<!-- |**|end egp html banner|**| -->

  </div> <!-- ygrp-msg -->

   


  <br>

<!-- |**|end egp html banner|**| -->


<div style="color: white; clear: both;"/>__,_._,___</div>
</body></html>
--Apple-Mail=_FFE0BA70-0DCE-4721-B4AA-95D9E0FFB555--