Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Till is on the right track there, but did not give the correct syntax. The broker is used to load collections from the current Data Accessor, not for creating new ones. So the code would then be:</p> <pre><code>public IEnumerable&lt;Customer&gt; FindCustomers(string partialCustomerName) { if (string.IsNullOrEmpty(partialCustomerName)) throw new ArgumentException("partialCustomerName must be at least one character long"); var criteria = Criteria.Create&lt;Customer, string&gt;(cust =&gt; cust.CustomerName, Criteria.ComparisonOp.Like, partialCustomerName + "%"); int totalRecords; var col = new BusinessObjectCollection&lt;Customer&gt;(); col.LoadWithLimit(criteria, "CustomerName", 0, 20, ref totalRecords); return col; } </code></pre> <p>That should do it! Please award the answer to Till, not me. He did the most research. I just corrected the syntax :)</p> <p>EDIT: After comments below about the ugly API, I will include suggested changes to the method to make it look cleaner (Thanks for your suggestion @GloryDev):</p> <pre><code>public IEnumerable&lt;Customer&gt; FindCustomers(string partialCustomerName) { if (string.IsNullOrEmpty(partialCustomerName)) throw new ArgumentException("partialCustomerName must be at least one character long"); var col = new BusinessObjectCollection&lt;Customer&gt;(); col.LoadWithLimit("CustomerName Like " + partialCustomerName + "%", "CustomerName", 20); return col; } </code></pre> <p>The Second parameter is the field to order by, which is necessary for a fetch with limits to make any sense. Hope this helps.</p>
    singulars
    1. This table or related slice is empty.
    1. POIn Habanero how would I restrict the number of objects returned from a database
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMark Whitfeld
    1. USMark Whitfeld
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIn Habanero how would I restrict the number of objects returned from a database
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COExcellent just what I was looking for.
      singulars
      1. PO
      1. USAndrew
    2. COyikes what an ugly api
      singulars
      1. PO
      1. USChris Marisic
    3. COYes I prefer the one in my Answer below. This Create.Criteria stuff using lambdas is very new and is as I understand it this is what is being used behind the scenes in the Linq to Habanero. I am not sure if this is intended to be the API.
      singulars
      1. PO
      1. USGloryDev
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload