docs/output/Ext.sql.SQLiteStore.html

   1         <div class="body-wrap">
   2         <div class="top-tools">
   3             <a class="inner-link" href="#Ext.sql.SQLiteStore-props"><img src="../resources/images/default/s.gif" class="item-icon icon-prop">Properties</a>
   4             <a class="inner-link" href="#Ext.sql.SQLiteStore-methods"><img src="../resources/images/default/s.gif" class="item-icon icon-method">Methods</a>
   5             <a class="inner-link" href="#Ext.sql.SQLiteStore-events"><img src="../resources/images/default/s.gif" class="item-icon icon-event">Events</a>
   6                             <a class="inner-link" href="#Ext.sql.SQLiteStore-configs"><img src="../resources/images/default/s.gif" class="item-icon icon-config">Config Options</a>
   7                         <a class="bookmark" href="../docs/?class=Ext.sql.SQLiteStore"><img src="../resources/images/default/s.gif" class="item-icon icon-fav">Direct Link</a>
   8         </div>
   9                 <div class="inheritance res-block">
  10 <pre class="res-block-inner"><a ext:cls="Ext.util.Observable" ext:member="" href="output/Ext.util.Observable.html">Observable</a>
  11   <img src="resources/elbow-end.gif"/><a ext:cls="Ext.data.Store" ext:member="" href="output/Ext.data.Store.html">Store</a>
  12     <img src="resources/elbow-end.gif"/>SQLiteStore</pre></div>
  13                 <h1>Class Ext.sql.SQLiteStore</h1>
  14         <table cellspacing="0">
  15             <tr><td class="label">Package:</td><td class="hd-info">Ext.sql</td></tr>
  16             <tr><td class="label">Defined In:</td><td class="hd-info"><a href="../src/SQLiteStore.js" target="_blank">SQLiteStore.js</a></td></tr>
  17             <tr><td class="label">Class:</td><td class="hd-info">SQLiteStore</td></tr>
  18                                     <tr><td class="label">Extends:</td><td class="hd-info"><a ext:cls="Ext.data.Store" ext:member="" href="output/Ext.data.Store.html">Store</a></td></tr>
  19                     </table>
  20         <div class="description">
  21             *
  22 Convenience class which assists in setting up SQLiteStore's.
  23 This class will create the necessary table if it does not exist.
  24 This class requires that all fields stored in the database will also be kept
  25 in the Ext.data.Store.        </div>
  26
  27         <div class="hr"></div>
  28                 <a id="Ext.sql.SQLiteStore-configs"></a>
  29         <h2>Config Options</h2>
  30         <table cellspacing="0" class="member-table">
  31             <tr>
  32                 <th class="sig-header" colspan="2">Config Options</th>
  33                 <th class="msource-header">Defined By</th>
  34             </tr>
  35                 <tr class="config-row inherited">\r
  36         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
  37         <td class="sig">\r
  38         <a id="Ext.sql.SQLiteStore-autoLoad"></a>\r
  39             <b>autoLoad</b> : Boolean/Object            <div class="mdesc">\r
  40                             If passed, this store's load method is automatically called after creation with the autoLoad object                        </div>\r
  41         </td>\r
  42         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#autoLoad" href="output/Ext.data.Store.html#autoLoad">Store</a></td>\r
  43     </tr>\r
  44         <tr class="config-row inherited alt">\r
  45         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
  46         <td class="sig">\r
  47         <a id="Ext.sql.SQLiteStore-baseParams"></a>\r
  48             <b>baseParams</b> : Object            <div class="mdesc">\r
  49                             An object containing properties which are to be sent as parameters on any HTTP request                        </div>\r
  50         </td>\r
  51         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#baseParams" href="output/Ext.data.Store.html#baseParams">Store</a></td>\r
  52     </tr>\r
  53         <tr class="config-row inherited">\r
  54         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
  55         <td class="sig">\r
  56         <a id="Ext.sql.SQLiteStore-data"></a>\r
  57             <b>data</b> : Array            <div class="mdesc">\r
  58                             Inline data to be loaded when the store is initialized.                        </div>\r
  59         </td>\r
  60         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#data" href="output/Ext.data.Store.html#data">Store</a></td>\r
  61     </tr>\r
  62         <tr class="config-row alt">\r
  63         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
  64         <td class="sig">\r
  65         <a id="Ext.sql.SQLiteStore-dbFile"></a>\r
  66             <b>dbFile</b> : String            <div class="mdesc">\r
  67                             Filename to create/open                        </div>\r
  68         </td>\r
  69         <td class="msource">SQLiteStore</td>\r
  70     </tr>\r
  71         <tr class="config-row">\r
  72         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
  73         <td class="sig">\r
  74         <a id="Ext.sql.SQLiteStore-fields"></a>\r
  75             <b>fields</b> : Array            <div class="mdesc">\r
  76                             Array of fields to be used. Both name and type must be specified for every field.                        </div>\r
  77         </td>\r
  78         <td class="msource">SQLiteStore</td>\r
  79     </tr>\r
  80         <tr class="config-row alt">\r
  81         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
  82         <td class="sig">\r
  83         <a id="Ext.sql.SQLiteStore-key"></a>\r
  84             <b>key</b> : String            <div class="mdesc">\r
  85                             This is the primary key for the table and the id for the Ext.data.Record.                        </div>\r
  86         </td>\r
  87         <td class="msource">SQLiteStore</td>\r
  88     </tr>\r
  89         <tr class="config-row inherited expandable">\r
  90         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
  91         <td class="sig">\r
  92         <a id="Ext.sql.SQLiteStore-listeners"></a>\r
  93             <b>listeners</b> : Object            <div class="mdesc">\r
  94                         <div class="short">(optional) A config object containing one or more event handlers to be added to this object during initialization. Th...</div>\r
  95             <div class="long">\r
  96                 (optional) A config object containing one or more event handlers to be added to this object during initialization. This should be a valid listeners config object as specified in the <a ext:cls="Ext.util.Observable" ext:member="addListener" href="output/Ext.util.Observable.html#addListener">addListener</a> example for attaching multiple handlers at once.            </div>\r
  97                         </div>\r
  98         </td>\r
  99         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#listeners" href="output/Ext.util.Observable.html#listeners">Observable</a></td>\r
 100     </tr>\r
 101         <tr class="config-row inherited alt">\r
 102         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 103         <td class="sig">\r
 104         <a id="Ext.sql.SQLiteStore-proxy"></a>\r
 105             <b>proxy</b> : Ext.data.DataProxy            <div class="mdesc">\r
 106                             The Proxy object which provides access to a data object.                        </div>\r
 107         </td>\r
 108         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#proxy" href="output/Ext.data.Store.html#proxy">Store</a></td>\r
 109     </tr>\r
 110         <tr class="config-row inherited expandable">\r
 111         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 112         <td class="sig">\r
 113         <a id="Ext.sql.SQLiteStore-pruneModifiedRecords"></a>\r
 114             <b>pruneModifiedRecords</b> : boolean            <div class="mdesc">\r
 115                         <div class="short">True to clear all modified record information each time the store is loaded or when a record is removed. (defaults to...</div>\r
 116             <div class="long">\r
 117                 True to clear all modified record information each time the store is loaded or when a record is removed. (defaults to false).            </div>\r
 118                         </div>\r
 119         </td>\r
 120         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#pruneModifiedRecords" href="output/Ext.data.Store.html#pruneModifiedRecords">Store</a></td>\r
 121     </tr>\r
 122         <tr class="config-row inherited alt expandable">\r
 123         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 124         <td class="sig">\r
 125         <a id="Ext.sql.SQLiteStore-reader"></a>\r
 126             <b>reader</b> : Ext.data.DataReader            <div class="mdesc">\r
 127                         <div class="short">The DataReader object which processes the data object and returns an Array of Ext.data.Record objects which are cache...</div>\r
 128             <div class="long">\r
 129                 The DataReader object which processes the data object and returns an Array of Ext.data.Record objects which are cached keyed by their <em>id</em> property.            </div>\r
 130                         </div>\r
 131         </td>\r
 132         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#reader" href="output/Ext.data.Store.html#reader">Store</a></td>\r
 133     </tr>\r
 134         <tr class="config-row inherited expandable">\r
 135         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 136         <td class="sig">\r
 137         <a id="Ext.sql.SQLiteStore-remoteSort"></a>\r
 138             <b>remoteSort</b> : boolean            <div class="mdesc">\r
 139                         <div class="short">True if sorting is to be handled by requesting the Proxy to provide a refreshed version of the data object in sorted ...</div>\r
 140             <div class="long">\r
 141                 True if sorting is to be handled by requesting the Proxy to provide a refreshed version of the data object in sorted order, as opposed to sorting the Record cache in place (defaults to false). <p>If remote sorting is specified, then clicking on a column header causes the current page to be requested from the server with the addition of the following two parameters: <div class="mdetail-params"><ul> <li><b>sort</b> : String<p class="sub-desc">The name (as specified in the Record's Field definition) of the field to sort on.</p></li> <li><b>dir</b> : String<p class="sub-desc">The direction of the sort, "ASC" or "DESC" (case-sensitive).</p></li> </ul></div></p>            </div>\r
 142                         </div>\r
 143         </td>\r
 144         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#remoteSort" href="output/Ext.data.Store.html#remoteSort">Store</a></td>\r
 145     </tr>\r
 146         <tr class="config-row inherited alt expandable">\r
 147         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 148         <td class="sig">\r
 149         <a id="Ext.sql.SQLiteStore-sortInfo"></a>\r
 150             <b>sortInfo</b> : Object            <div class="mdesc">\r
 151                         <div class="short">A config object in the format: {field: "fieldName", direction: "ASC|DESC"} to specify the sort order in the request o...</div>\r
 152             <div class="long">\r
 153                 A config object in the format: {field: "fieldName", direction: "ASC|DESC"} to specify the sort order in the request of a remote Store's <a ext:cls="Ext.data.Store" ext:member="load" href="output/Ext.data.Store.html#load">load</a> operation. Note that for local sorting, the direction property is case-sensitive.            </div>\r
 154                         </div>\r
 155         </td>\r
 156         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#sortInfo" href="output/Ext.data.Store.html#sortInfo">Store</a></td>\r
 157     </tr>\r
 158         <tr class="config-row inherited">\r
 159         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 160         <td class="sig">\r
 161         <a id="Ext.sql.SQLiteStore-storeId"></a>\r
 162             <b>storeId</b> : String            <div class="mdesc">\r
 163                             If passed, the id to use to register with the StoreMgr                        </div>\r
 164         </td>\r
 165         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#storeId" href="output/Ext.data.Store.html#storeId">Store</a></td>\r
 166     </tr>\r
 167         <tr class="config-row inherited alt">\r
 168         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 169         <td class="sig">\r
 170         <a id="Ext.sql.SQLiteStore-url"></a>\r
 171             <b>url</b> : String            <div class="mdesc">\r
 172                             If passed, an HttpProxy is created for the passed URL                        </div>\r
 173         </td>\r
 174         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#url" href="output/Ext.data.Store.html#url">Store</a></td>\r
 175     </tr>\r
 176             </table>
 177                 <a id="Ext.sql.SQLiteStore-props"></a>
 178         <h2>Public Properties</h2>
 179                 <table cellspacing="0" class="member-table">
 180             <tr>
 181                 <th class="sig-header" colspan="2">Property</th>
 182                 <th class="msource-header">Defined By</th>
 183             </tr>
 184                 <tr class="property-row inherited expandable">\r
 185         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 186         <td class="sig">\r
 187         <a id="Ext.sql.SQLiteStore-baseParams"></a>\r
 188             <b>baseParams</b> : Object            <div class="mdesc">\r
 189                         <div class="short">An object containing properties which are used as parameters on any HTTP request.
 190 This property can be changed after ...</div>\r
 191             <div class="long">\r
 192                 An object containing properties which are used as parameters on any HTTP request.
 193 This property can be changed after creating the Store to send different parameters.            </div>\r
 194                         </div>\r
 195         </td>\r
 196         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#baseParams" href="output/Ext.data.Store.html#baseParams">Store</a></td>\r
 197     </tr>\r
 198         <tr class="property-row inherited alt">\r
 199         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 200         <td class="sig">\r
 201         <a id="Ext.sql.SQLiteStore-fields"></a>\r
 202             <b>fields</b> : Ext.util.MixedCollection            <div class="mdesc">\r
 203                             A MixedCollection containing the defined <a ext:cls="Ext.data.Field" href="output/Ext.data.Field.html">Field</a>s for the Records stored in this Store.  Read-only.                        </div>\r
 204         </td>\r
 205         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#fields" href="output/Ext.data.Store.html#fields">Store</a></td>\r
 206     </tr>\r
 207         <tr class="property-row inherited expandable">\r
 208         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 209         <td class="sig">\r
 210         <a id="Ext.sql.SQLiteStore-lastOptions"></a>\r
 211             <b>lastOptions</b> : Object            <div class="mdesc">\r
 212                         <div class="short">Contains the last options object used as the parameter to the load method. See load
 213 for the details of what this may ...</div>\r
 214             <div class="long">\r
 215                 Contains the last options object used as the parameter to the load method. See <a ext:cls="Ext.data.Store" ext:member="load" href="output/Ext.data.Store.html#load">load</a>
 216 for the details of what this may contain. This may be useful for accessing any params which
 217 were used to load the current Record cache.            </div>\r
 218                         </div>\r
 219         </td>\r
 220         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#lastOptions" href="output/Ext.data.Store.html#lastOptions">Store</a></td>\r
 221     </tr>\r
 222         <tr class="property-row inherited alt expandable">\r
 223         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 224         <td class="sig">\r
 225         <a id="Ext.sql.SQLiteStore-paramNames"></a>\r
 226             <b>paramNames</b> : Object            <div class="mdesc">\r
 227                         <div class="short">An object containing properties which specify the names of the paging and
 228 sorting parameters passed to remote servers...</div>\r
 229             <div class="long">\r
 230                 <p>An object containing properties which specify the names of the paging and
 231 sorting parameters passed to remote servers when loading blocks of data. By default, this
 232 object takes the following form:</p><pre><code>{
 233     start : <em>"start"</em>,    <i>// The parameter name which specifies the start row</i>
 234     limit : <em>"limit"</em>,    <i>// The parameter name which specifies number of rows to <b>return</b></i>
 235     sort : <em>"sort"</em>,      <i>// The parameter name which specifies the column to sort on</i>
 236     dir : <em>"dir"</em>         <i>// The parameter name which specifies the sort direction</i>
 237 }</code></pre>
 238 <p>The server must produce the requested data block upon receipt of these parameter names.
 239 If different parameter names are required, this property can be overriden using a configuration
 240 property.</p>
 241 <p>A <a ext:cls="Ext.PagingToolbar" href="output/Ext.PagingToolbar.html">PagingToolbar</a> bound to this grid uses this property to determine
 242 the parameter names to use in its requests.            </div>\r
 243                         </div>\r
 244         </td>\r
 245         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#paramNames" href="output/Ext.data.Store.html#paramNames">Store</a></td>\r
 246     </tr>\r
 247         <tr class="property-row inherited expandable">\r
 248         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 249         <td class="sig">\r
 250         <a id="Ext.sql.SQLiteStore-recordType"></a>\r
 251             <b>recordType</b> : Function            <div class="mdesc">\r
 252                         <div class="short">The Record constructor as supplied to (or created by) the Reader.  Read-only.
 253 If the Reader was constructed by passin...</div>\r
 254             <div class="long">\r
 255                 The <a ext:cls="Ext.data.Record" href="output/Ext.data.Record.html">Record</a> constructor as supplied to (or created by) the <a ext:cls="Ext.data.Reader" ext:member="Reader" href="output/Ext.data.Reader.html#Reader">Reader</a>.  Read-only.
 256 <p>If the Reader was constructed by passing in an Array of field definition objects, instead of an created
 257 Record constructor it will have <a ext:cls="Ext.data.Record" ext:member="create" href="output/Ext.data.Record.html#create">created a constructor</a> from that Array.</p>
 258 <p>This property may be used to create new Records of the type held in this Store.</p>            </div>\r
 259                         </div>\r
 260         </td>\r
 261         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#recordType" href="output/Ext.data.Store.html#recordType">Store</a></td>\r
 262     </tr>\r
 263             </table>
 264                 <a id="Ext.sql.SQLiteStore-methods"></a>
 265         <h2>Public Methods</h2>
 266                 <table cellspacing="0" class="member-table">
 267             <tr>
 268                 <th class="sig-header" colspan="2">Method</th>
 269                 <th class="msource-header">Defined By</th>
 270             </tr>
 271                 <tr class="method-row inherited expandable">\r
 272         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 273         <td class="sig">\r
 274         <a id="Ext.sql.SQLiteStore-add"></a>\r
 275             <b>add</b>(&nbsp;<code>Ext.data.Record[] records</code>&nbsp;) : void            <div class="mdesc">\r
 276                         <div class="short">Add Records to the Store and fires the <a ext:cls="Ext.data.Store" ext:member="add" href="output/Ext.data.Store.html#add">add</a> event.</div>\r
 277             <div class="long">\r
 278                 Add Records to the Store and fires the <a ext:cls="Ext.data.Store" ext:member="add" href="output/Ext.data.Store.html#add">add</a> event.    <div class="mdetail-params">\r
 279         <strong>Parameters:</strong>\r
 280         <ul><li><code>records</code> : Ext.data.Record[]<div class="sub-desc">An Array of Ext.data.Record objects to add to the cache.</div></li>        </ul>\r
 281         <strong>Returns:</strong>\r
 282         <ul>\r
 283             <li><code>void</code></li>\r
 284         </ul>\r
 285     </div>\r
 286                 </div>\r
 287                         </div>\r
 288         </td>\r
 289         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#add" href="output/Ext.data.Store.html#add">Store</a></td>\r
 290     </tr>\r
 291         <tr class="method-row inherited alt expandable">\r
 292         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 293         <td class="sig">\r
 294         <a id="Ext.sql.SQLiteStore-addEvents"></a>\r
 295             <b>addEvents</b>(&nbsp;<code>Object object</code>&nbsp;) : void            <div class="mdesc">\r
 296                         <div class="short">Used to define events on this Observable</div>\r
 297             <div class="long">\r
 298                 Used to define events on this Observable    <div class="mdetail-params">\r
 299         <strong>Parameters:</strong>\r
 300         <ul><li><code>object</code> : Object<div class="sub-desc">The object with the events defined</div></li>        </ul>\r
 301         <strong>Returns:</strong>\r
 302         <ul>\r
 303             <li><code>void</code></li>\r
 304         </ul>\r
 305     </div>\r
 306                 </div>\r
 307                         </div>\r
 308         </td>\r
 309         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#addEvents" href="output/Ext.util.Observable.html#addEvents">Observable</a></td>\r
 310     </tr>\r
 311         <tr class="method-row inherited expandable">\r
 312         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 313         <td class="sig">\r
 314         <a id="Ext.sql.SQLiteStore-addListener"></a>\r
 315             <b>addListener</b>(&nbsp;<code>String eventName</code>, <code>Function handler</code>, <span class="optional" title="Optional">[<code>Object scope</code>]</span>, <span class="optional" title="Optional">[<code>Object options</code>]</span>&nbsp;) : void            <div class="mdesc">\r
 316                         <div class="short">Appends an event handler to this component</div>\r
 317             <div class="long">\r
 318                 Appends an event handler to this component    <div class="mdetail-params">\r
 319         <strong>Parameters:</strong>\r
 320         <ul><li><code>eventName</code> : String<div class="sub-desc">The type of event to listen for</div></li><li><code>handler</code> : Function<div class="sub-desc">The method the event invokes</div></li><li><code>scope</code> : Object<div class="sub-desc">(optional) The scope in which to execute the handler
 321 function. The handler function's "this" context.</div></li><li><code>options</code> : Object<div class="sub-desc">(optional) An object containing handler configuration
 322 properties. This may contain any of the following properties:<ul>
 323 <li><b>scope</b> : Object<p class="sub-desc">The scope in which to execute the handler function. The handler function's "this" context.</p></li>
 324 <li><b>delay</b> : Number<p class="sub-desc">The number of milliseconds to delay the invocation of the handler after the event fires.</p></li>
 325 <li><b>single</b> : Boolean<p class="sub-desc">True to add a handler to handle just the next firing of the event, and then remove itself.</p></li>
 326 <li><b>buffer</b> : Number<p class="sub-desc">Causes the handler to be scheduled to run in an <a ext:cls="Ext.util.DelayedTask" href="output/Ext.util.DelayedTask.html">Ext.util.DelayedTask</a> delayed
 327 by the specified number of milliseconds. If the event fires again within that time, the original
 328 handler is <em>not</em> invoked, but the new handler is scheduled in its place.</p></li>
 329 </ul><br>
 330 <p>
 331 <b>Combining Options</b><br>
 332 Using the options argument, it is possible to combine different types of listeners:<br>
 333 <br>
 334 A normalized, delayed, one-time listener that auto stops the event and passes a custom argument (forumId)
 335 <pre><code>el.on(<em>'click'</em>, <b>this</b>.onClick, <b>this</b>, {
 336     single: true,
 337     delay: 100,
 338     forumId: 4
 339 });</code></pre>
 340 <p>
 341 <b>Attaching multiple handlers in 1 call</b><br>
 342 The method also allows for a single argument to be passed which is a config object containing properties
 343 which specify multiple handlers.
 344 <p>
 345 <pre><code>foo.on({
 346     <em>'click'</em> : {
 347         fn: <b>this</b>.onClick,
 348         scope: <b>this</b>,
 349         delay: 100
 350     },
 351     <em>'mouseover'</em> : {
 352         fn: <b>this</b>.onMouseOver,
 353         scope: <b>this</b>
 354     },
 355     <em>'mouseout'</em> : {
 356         fn: <b>this</b>.onMouseOut,
 357         scope: <b>this</b>
 358     }
 359 });</code></pre>
 360 <p>
 361 Or a shorthand syntax:<br>
 362 <pre><code>foo.on({
 363     <em>'click'</em> : <b>this</b>.onClick,
 364     <em>'mouseover'</em> : <b>this</b>.onMouseOver,
 365     <em>'mouseout'</em> : <b>this</b>.onMouseOut,
 366      scope: <b>this</b>
 367 });</code></pre></div></li>        </ul>\r
 368         <strong>Returns:</strong>\r
 369         <ul>\r
 370             <li><code>void</code></li>\r
 371         </ul>\r
 372     </div>\r
 373                 </div>\r
 374                         </div>\r
 375         </td>\r
 376         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#addListener" href="output/Ext.util.Observable.html#addListener">Observable</a></td>\r
 377     </tr>\r
 378         <tr class="method-row inherited alt expandable">\r
 379         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 380         <td class="sig">\r
 381         <a id="Ext.sql.SQLiteStore-addSorted"></a>\r
 382             <b>addSorted</b>(&nbsp;<code>Ext.data.Record record</code>&nbsp;) : void            <div class="mdesc">\r
 383                         <div class="short">(Local sort only) Inserts the passed Record into the Store at the index where it
 384 should go based on the current sort ...</div>\r
 385             <div class="long">\r
 386                 (Local sort only) Inserts the passed Record into the Store at the index where it
 387 should go based on the current sort information.    <div class="mdetail-params">\r
 388         <strong>Parameters:</strong>\r
 389         <ul><li><code>record</code> : Ext.data.Record<div class="sub-desc"></div></li>        </ul>\r
 390         <strong>Returns:</strong>\r
 391         <ul>\r
 392             <li><code>void</code></li>\r
 393         </ul>\r
 394     </div>\r
 395                 </div>\r
 396                         </div>\r
 397         </td>\r
 398         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#addSorted" href="output/Ext.data.Store.html#addSorted">Store</a></td>\r
 399     </tr>\r
 400         <tr class="method-row inherited expandable">\r
 401         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 402         <td class="sig">\r
 403         <a id="Ext.sql.SQLiteStore-clearFilter"></a>\r
 404             <b>clearFilter</b>(&nbsp;<code>Boolean suppressEvent</code>&nbsp;) : void            <div class="mdesc">\r
 405                         <div class="short">Revert to a view of the Record cache with no filtering applied.</div>\r
 406             <div class="long">\r
 407                 Revert to a view of the Record cache with no filtering applied.    <div class="mdetail-params">\r
 408         <strong>Parameters:</strong>\r
 409         <ul><li><code>suppressEvent</code> : Boolean<div class="sub-desc">If true the filter is cleared silently without notifying listeners</div></li>        </ul>\r
 410         <strong>Returns:</strong>\r
 411         <ul>\r
 412             <li><code>void</code></li>\r
 413         </ul>\r
 414     </div>\r
 415                 </div>\r
 416                         </div>\r
 417         </td>\r
 418         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#clearFilter" href="output/Ext.data.Store.html#clearFilter">Store</a></td>\r
 419     </tr>\r
 420         <tr class="method-row inherited alt expandable">\r
 421         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 422         <td class="sig">\r
 423         <a id="Ext.sql.SQLiteStore-collect"></a>\r
 424             <b>collect</b>(&nbsp;<code>String dataIndex</code>, <span class="optional" title="Optional">[<code>Boolean allowNull</code>]</span>, <span class="optional" title="Optional">[<code>Boolean bypassFilter</code>]</span>&nbsp;) : Array            <div class="mdesc">\r
 425                         <div class="short">Collects unique values for a particular dataIndex from this store.</div>\r
 426             <div class="long">\r
 427                 Collects unique values for a particular dataIndex from this store.    <div class="mdetail-params">\r
 428         <strong>Parameters:</strong>\r
 429         <ul><li><code>dataIndex</code> : String<div class="sub-desc">The property to collect</div></li><li><code>allowNull</code> : Boolean<div class="sub-desc">(optional) Pass true to allow null, undefined or empty string values</div></li><li><code>bypassFilter</code> : Boolean<div class="sub-desc">(optional) Pass true to collect from all records, even ones which are filtered</div></li>        </ul>\r
 430         <strong>Returns:</strong>\r
 431         <ul>\r
 432             <li><code>Array</code><div class="sub-desc">An array of the unique values</div></li>\r
 433         </ul>\r
 434     </div>\r
 435                 </div>\r
 436                         </div>\r
 437         </td>\r
 438         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#collect" href="output/Ext.data.Store.html#collect">Store</a></td>\r
 439     </tr>\r
 440         <tr class="method-row inherited expandable">\r
 441         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 442         <td class="sig">\r
 443         <a id="Ext.sql.SQLiteStore-commitChanges"></a>\r
 444             <b>commitChanges</b>() : void            <div class="mdesc">\r
 445                         <div class="short">Commit all Records with outstanding changes. To handle updates for changes, subscribe to the
 446 Store's "update" event, ...</div>\r
 447             <div class="long">\r
 448                 Commit all Records with outstanding changes. To handle updates for changes, subscribe to the
 449 Store's "update" event, and perform updating when the third parameter is Ext.data.Record.COMMIT.    <div class="mdetail-params">\r
 450         <strong>Parameters:</strong>\r
 451         <ul><li>None.</li>        </ul>\r
 452         <strong>Returns:</strong>\r
 453         <ul>\r
 454             <li><code>void</code></li>\r
 455         </ul>\r
 456     </div>\r
 457                 </div>\r
 458                         </div>\r
 459         </td>\r
 460         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#commitChanges" href="output/Ext.data.Store.html#commitChanges">Store</a></td>\r
 461     </tr>\r
 462         <tr class="method-row alt expandable">\r
 463         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 464         <td class="sig">\r
 465         <a id="Ext.sql.SQLiteStore-constructor"></a>\r
 466             <b>constructor</b>() : void            <div class="mdesc">\r
 467                         <div class="short"></div>\r
 468             <div class="long">\r
 469                     <div class="mdetail-params">\r
 470         <strong>Parameters:</strong>\r
 471         <ul><li>None.</li>        </ul>\r
 472         <strong>Returns:</strong>\r
 473         <ul>\r
 474             <li><code>void</code></li>\r
 475         </ul>\r
 476     </div>\r
 477                 </div>\r
 478                         </div>\r
 479         </td>\r
 480         <td class="msource">SQLiteStore</td>\r
 481     </tr>\r
 482         <tr class="method-row inherited expandable">\r
 483         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 484         <td class="sig">\r
 485         <a id="Ext.sql.SQLiteStore-each"></a>\r
 486             <b>each</b>(&nbsp;<code>Function fn</code>, <span class="optional" title="Optional">[<code>Object scope</code>]</span>&nbsp;) : void            <div class="mdesc">\r
 487                         <div class="short">Calls the specified function for each of the Records in the cache.</div>\r
 488             <div class="long">\r
 489                 Calls the specified function for each of the Records in the cache.    <div class="mdetail-params">\r
 490         <strong>Parameters:</strong>\r
 491         <ul><li><code>fn</code> : Function<div class="sub-desc">The function to call. The Record is passed as the first parameter.
 492 Returning <tt>false</tt> aborts and exits the iteration.</div></li><li><code>scope</code> : Object<div class="sub-desc">(optional) The scope in which to call the function (defaults to the Record).</div></li>        </ul>\r
 493         <strong>Returns:</strong>\r
 494         <ul>\r
 495             <li><code>void</code></li>\r
 496         </ul>\r
 497     </div>\r
 498                 </div>\r
 499                         </div>\r
 500         </td>\r
 501         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#each" href="output/Ext.data.Store.html#each">Store</a></td>\r
 502     </tr>\r
 503         <tr class="method-row inherited alt expandable">\r
 504         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 505         <td class="sig">\r
 506         <a id="Ext.sql.SQLiteStore-filter"></a>\r
 507             <b>filter</b>(&nbsp;<code>String field</code>, <code>String/RegExp value</code>, <span class="optional" title="Optional">[<code>Boolean anyMatch</code>]</span>, <span class="optional" title="Optional">[<code>Boolean caseSensitive</code>]</span>&nbsp;) : void            <div class="mdesc">\r
 508                         <div class="short">Filter the records by a specified property.</div>\r
 509             <div class="long">\r
 510                 Filter the records by a specified property.    <div class="mdetail-params">\r
 511         <strong>Parameters:</strong>\r
 512         <ul><li><code>field</code> : String<div class="sub-desc">A field on your records</div></li><li><code>value</code> : String/RegExp<div class="sub-desc">Either a string that the field
 513 should begin with, or a RegExp to test against the field.</div></li><li><code>anyMatch</code> : Boolean<div class="sub-desc">(optional) True to match any part not just the beginning</div></li><li><code>caseSensitive</code> : Boolean<div class="sub-desc">(optional) True for case sensitive comparison</div></li>        </ul>\r
 514         <strong>Returns:</strong>\r
 515         <ul>\r
 516             <li><code>void</code></li>\r
 517         </ul>\r
 518     </div>\r
 519                 </div>\r
 520                         </div>\r
 521         </td>\r
 522         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#filter" href="output/Ext.data.Store.html#filter">Store</a></td>\r
 523     </tr>\r
 524         <tr class="method-row inherited expandable">\r
 525         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 526         <td class="sig">\r
 527         <a id="Ext.sql.SQLiteStore-filterBy"></a>\r
 528             <b>filterBy</b>(&nbsp;<code>Function fn</code>, <span class="optional" title="Optional">[<code>Object scope</code>]</span>&nbsp;) : void            <div class="mdesc">\r
 529                         <div class="short">Filter by a function. The specified function will be called for each
 530 Record in this Store. If the function returns tr...</div>\r
 531             <div class="long">\r
 532                 Filter by a function. The specified function will be called for each
 533 Record in this Store. If the function returns <tt>true</tt> the Record is included,
 534 otherwise it is filtered out.    <div class="mdetail-params">\r
 535         <strong>Parameters:</strong>\r
 536         <ul><li><code>fn</code> : Function<div class="sub-desc">The function to be called. It will be passed the following parameters:<ul>
 537 <li><b>record</b> : Ext.data.Record<p class="sub-desc">The <a ext:cls="Ext.data.Record" href="output/Ext.data.Record.html">record</a>
 538 to test for filtering. Access field values using <a ext:cls="Ext.data.Record" ext:member="get" href="output/Ext.data.Record.html#get">Ext.data.Record.get</a>.</p></li>
 539 <li><b>id</b> : Object<p class="sub-desc">The ID of the Record passed.</p></li>
 540 </ul></div></li><li><code>scope</code> : Object<div class="sub-desc">(optional) The scope of the function (defaults to this)</div></li>        </ul>\r
 541         <strong>Returns:</strong>\r
 542         <ul>\r
 543             <li><code>void</code></li>\r
 544         </ul>\r
 545     </div>\r
 546                 </div>\r
 547                         </div>\r
 548         </td>\r
 549         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#filterBy" href="output/Ext.data.Store.html#filterBy">Store</a></td>\r
 550     </tr>\r
 551         <tr class="method-row inherited alt expandable">\r
 552         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 553         <td class="sig">\r
 554         <a id="Ext.sql.SQLiteStore-find"></a>\r
 555             <b>find</b>(&nbsp;<code>String property</code>, <code>String/RegExp value</code>, <span class="optional" title="Optional">[<code>Number startIndex</code>]</span>, <span class="optional" title="Optional">[<code>Boolean anyMatch</code>]</span>, <span class="optional" title="Optional">[<code>Boolean caseSensitive</code>]</span>&nbsp;) : Number            <div class="mdesc">\r
 556                         <div class="short">Finds the index of the first matching record in this store by a specific property/value.</div>\r
 557             <div class="long">\r
 558                 Finds the index of the first matching record in this store by a specific property/value.    <div class="mdetail-params">\r
 559         <strong>Parameters:</strong>\r
 560         <ul><li><code>property</code> : String<div class="sub-desc">A property on your objects</div></li><li><code>value</code> : String/RegExp<div class="sub-desc">Either a string that the property value
 561 should begin with, or a RegExp to test against the property.</div></li><li><code>startIndex</code> : Number<div class="sub-desc">(optional) The index to start searching at</div></li><li><code>anyMatch</code> : Boolean<div class="sub-desc">(optional) True to match any part of the string, not just the beginning</div></li><li><code>caseSensitive</code> : Boolean<div class="sub-desc">(optional) True for case sensitive comparison</div></li>        </ul>\r
 562         <strong>Returns:</strong>\r
 563         <ul>\r
 564             <li><code>Number</code><div class="sub-desc">The matched index or -1</div></li>\r
 565         </ul>\r
 566     </div>\r
 567                 </div>\r
 568                         </div>\r
 569         </td>\r
 570         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#find" href="output/Ext.data.Store.html#find">Store</a></td>\r
 571     </tr>\r
 572         <tr class="method-row inherited expandable">\r
 573         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 574         <td class="sig">\r
 575         <a id="Ext.sql.SQLiteStore-findBy"></a>\r
 576             <b>findBy</b>(&nbsp;<code>Function fn</code>, <span class="optional" title="Optional">[<code>Object scope</code>]</span>, <span class="optional" title="Optional">[<code>Number startIndex</code>]</span>&nbsp;) : Number            <div class="mdesc">\r
 577                         <div class="short">Find the index of the first matching Record in this Store by a function.
 578 If the function returns true it is considere...</div>\r
 579             <div class="long">\r
 580                 Find the index of the first matching Record in this Store by a function.
 581 If the function returns <tt>true</tt> it is considered a match.    <div class="mdetail-params">\r
 582         <strong>Parameters:</strong>\r
 583         <ul><li><code>fn</code> : Function<div class="sub-desc">The function to be called. It will be passed the following parameters:<ul>
 584 <li><b>record</b> : Ext.data.Record<p class="sub-desc">The <a ext:cls="Ext.data.Record" href="output/Ext.data.Record.html">record</a>
 585 to test for filtering. Access field values using <a ext:cls="Ext.data.Record" ext:member="get" href="output/Ext.data.Record.html#get">Ext.data.Record.get</a>.</p></li>
 586 <li><b>id</b> : Object<p class="sub-desc">The ID of the Record passed.</p></li>
 587 </ul></div></li><li><code>scope</code> : Object<div class="sub-desc">(optional) The scope of the function (defaults to this)</div></li><li><code>startIndex</code> : Number<div class="sub-desc">(optional) The index to start searching at</div></li>        </ul>\r
 588         <strong>Returns:</strong>\r
 589         <ul>\r
 590             <li><code>Number</code><div class="sub-desc">The matched index or -1</div></li>\r
 591         </ul>\r
 592     </div>\r
 593                 </div>\r
 594                         </div>\r
 595         </td>\r
 596         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#findBy" href="output/Ext.data.Store.html#findBy">Store</a></td>\r
 597     </tr>\r
 598         <tr class="method-row inherited alt expandable">\r
 599         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 600         <td class="sig">\r
 601         <a id="Ext.sql.SQLiteStore-fireEvent"></a>\r
 602             <b>fireEvent</b>(&nbsp;<code>String eventName</code>, <code>Object... args</code>&nbsp;) : Boolean            <div class="mdesc">\r
 603                         <div class="short">Fires the specified event with the passed parameters (minus the event name).</div>\r
 604             <div class="long">\r
 605                 Fires the specified event with the passed parameters (minus the event name).    <div class="mdetail-params">\r
 606         <strong>Parameters:</strong>\r
 607         <ul><li><code>eventName</code> : String<div class="sub-desc"></div></li><li><code>args</code> : Object...<div class="sub-desc">Variable number of parameters are passed to handlers</div></li>        </ul>\r
 608         <strong>Returns:</strong>\r
 609         <ul>\r
 610             <li><code>Boolean</code><div class="sub-desc">returns false if any of the handlers return false otherwise it returns true</div></li>\r
 611         </ul>\r
 612     </div>\r
 613                 </div>\r
 614                         </div>\r
 615         </td>\r
 616         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#fireEvent" href="output/Ext.util.Observable.html#fireEvent">Observable</a></td>\r
 617     </tr>\r
 618         <tr class="method-row inherited expandable">\r
 619         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 620         <td class="sig">\r
 621         <a id="Ext.sql.SQLiteStore-getAt"></a>\r
 622             <b>getAt</b>(&nbsp;<code>Number index</code>&nbsp;) : Ext.data.Record            <div class="mdesc">\r
 623                         <div class="short">Get the Record at the specified index.</div>\r
 624             <div class="long">\r
 625                 Get the Record at the specified index.    <div class="mdetail-params">\r
 626         <strong>Parameters:</strong>\r
 627         <ul><li><code>index</code> : Number<div class="sub-desc">The index of the Record to find.</div></li>        </ul>\r
 628         <strong>Returns:</strong>\r
 629         <ul>\r
 630             <li><code>Ext.data.Record</code><div class="sub-desc">The Record at the passed index. Returns undefined if not found.</div></li>\r
 631         </ul>\r
 632     </div>\r
 633                 </div>\r
 634                         </div>\r
 635         </td>\r
 636         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#getAt" href="output/Ext.data.Store.html#getAt">Store</a></td>\r
 637     </tr>\r
 638         <tr class="method-row inherited alt expandable">\r
 639         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 640         <td class="sig">\r
 641         <a id="Ext.sql.SQLiteStore-getById"></a>\r
 642             <b>getById</b>(&nbsp;<code>String id</code>&nbsp;) : Ext.data.Record            <div class="mdesc">\r
 643                         <div class="short">Get the Record with the specified id.</div>\r
 644             <div class="long">\r
 645                 Get the Record with the specified id.    <div class="mdetail-params">\r
 646         <strong>Parameters:</strong>\r
 647         <ul><li><code>id</code> : String<div class="sub-desc">The id of the Record to find.</div></li>        </ul>\r
 648         <strong>Returns:</strong>\r
 649         <ul>\r
 650             <li><code>Ext.data.Record</code><div class="sub-desc">The Record with the passed id. Returns undefined if not found.</div></li>\r
 651         </ul>\r
 652     </div>\r
 653                 </div>\r
 654                         </div>\r
 655         </td>\r
 656         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#getById" href="output/Ext.data.Store.html#getById">Store</a></td>\r
 657     </tr>\r
 658         <tr class="method-row inherited expandable">\r
 659         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 660         <td class="sig">\r
 661         <a id="Ext.sql.SQLiteStore-getCount"></a>\r
 662             <b>getCount</b>() : Number            <div class="mdesc">\r
 663                         <div class="short">Gets the number of cached records.
 664 If using paging, this may not be the total size of the dataset. If the data object...</div>\r
 665             <div class="long">\r
 666                 Gets the number of cached records.
 667 <p>If using paging, this may not be the total size of the dataset. If the data object
 668 used by the Reader contains the dataset size, then the <a ext:cls="Ext.data.Store" ext:member="getTotalCount" href="output/Ext.data.Store.html#getTotalCount">getTotalCount</a> function returns
 669 the dataset size.</p>    <div class="mdetail-params">\r
 670         <strong>Parameters:</strong>\r
 671         <ul><li>None.</li>        </ul>\r
 672         <strong>Returns:</strong>\r
 673         <ul>\r
 674             <li><code>Number</code><div class="sub-desc">The number of Records in the Store's cache.</div></li>\r
 675         </ul>\r
 676     </div>\r
 677                 </div>\r
 678                         </div>\r
 679         </td>\r
 680         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#getCount" href="output/Ext.data.Store.html#getCount">Store</a></td>\r
 681     </tr>\r
 682         <tr class="method-row inherited alt expandable">\r
 683         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 684         <td class="sig">\r
 685         <a id="Ext.sql.SQLiteStore-getModifiedRecords"></a>\r
 686             <b>getModifiedRecords</b>() : Ext.data.Record[]            <div class="mdesc">\r
 687                         <div class="short">Gets all records modified since the last commit.  Modified records are persisted across load operations
 688 (e.g., during...</div>\r
 689             <div class="long">\r
 690                 Gets all records modified since the last commit.  Modified records are persisted across load operations
 691 (e.g., during paging).    <div class="mdetail-params">\r
 692         <strong>Parameters:</strong>\r
 693         <ul><li>None.</li>        </ul>\r
 694         <strong>Returns:</strong>\r
 695         <ul>\r
 696             <li><code>Ext.data.Record[]</code><div class="sub-desc">An array of Records containing outstanding modifications.</div></li>\r
 697         </ul>\r
 698     </div>\r
 699                 </div>\r
 700                         </div>\r
 701         </td>\r
 702         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#getModifiedRecords" href="output/Ext.data.Store.html#getModifiedRecords">Store</a></td>\r
 703     </tr>\r
 704         <tr class="method-row inherited expandable">\r
 705         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 706         <td class="sig">\r
 707         <a id="Ext.sql.SQLiteStore-getRange"></a>\r
 708             <b>getRange</b>(&nbsp;<span class="optional" title="Optional">[<code>Number startIndex</code>]</span>, <span class="optional" title="Optional">[<code>Number endIndex</code>]</span>&nbsp;) : Ext.data.Record[]            <div class="mdesc">\r
 709                         <div class="short">Returns a range of Records between specified indices.</div>\r
 710             <div class="long">\r
 711                 Returns a range of Records between specified indices.    <div class="mdetail-params">\r
 712         <strong>Parameters:</strong>\r
 713         <ul><li><code>startIndex</code> : Number<div class="sub-desc">(optional) The starting index (defaults to 0)</div></li><li><code>endIndex</code> : Number<div class="sub-desc">(optional) The ending index (defaults to the last Record in the Store)</div></li>        </ul>\r
 714         <strong>Returns:</strong>\r
 715         <ul>\r
 716             <li><code>Ext.data.Record[]</code><div class="sub-desc">An array of Records</div></li>\r
 717         </ul>\r
 718     </div>\r
 719                 </div>\r
 720                         </div>\r
 721         </td>\r
 722         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#getRange" href="output/Ext.data.Store.html#getRange">Store</a></td>\r
 723     </tr>\r
 724         <tr class="method-row inherited alt expandable">\r
 725         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 726         <td class="sig">\r
 727         <a id="Ext.sql.SQLiteStore-getSortState"></a>\r
 728             <b>getSortState</b>() : Object            <div class="mdesc">\r
 729                         <div class="short">Returns an object describing the current sort state of this Store.</div>\r
 730             <div class="long">\r
 731                 Returns an object describing the current sort state of this Store.    <div class="mdetail-params">\r
 732         <strong>Parameters:</strong>\r
 733         <ul><li>None.</li>        </ul>\r
 734         <strong>Returns:</strong>\r
 735         <ul>\r
 736             <li><code>Object</code><div class="sub-desc">The sort state of the Store. An object with two properties:<ul> <li><b>field : String<p class="sub-desc">The name of the field by which the Records are sorted.</p></li> <li><b>direction : String<p class="sub-desc">The sort order, "ASC" or "DESC" (case-sensitive).</p></li> </ul></div></li>\r
 737         </ul>\r
 738     </div>\r
 739                 </div>\r
 740                         </div>\r
 741         </td>\r
 742         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#getSortState" href="output/Ext.data.Store.html#getSortState">Store</a></td>\r
 743     </tr>\r
 744         <tr class="method-row inherited expandable">\r
 745         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 746         <td class="sig">\r
 747         <a id="Ext.sql.SQLiteStore-getTotalCount"></a>\r
 748             <b>getTotalCount</b>() : Number            <div class="mdesc">\r
 749                         <div class="short">Gets the total number of records in the dataset as returned by the server.
 750 If using paging, for this to be accurate, ...</div>\r
 751             <div class="long">\r
 752                 Gets the total number of records in the dataset as returned by the server.
 753 <p>If using paging, for this to be accurate, the data object used by the Reader must contain
 754 the dataset size. For remote data sources, this is provided by a query on the server.</p>    <div class="mdetail-params">\r
 755         <strong>Parameters:</strong>\r
 756         <ul><li>None.</li>        </ul>\r
 757         <strong>Returns:</strong>\r
 758         <ul>\r
 759             <li><code>Number</code><div class="sub-desc">The number of Records as specified in the data object passed to the Reader by the Proxy <p><b>This value is not updated when changing the contents of the Store locally.</b></p></div></li>\r
 760         </ul>\r
 761     </div>\r
 762                 </div>\r
 763                         </div>\r
 764         </td>\r
 765         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#getTotalCount" href="output/Ext.data.Store.html#getTotalCount">Store</a></td>\r
 766     </tr>\r
 767         <tr class="method-row inherited alt expandable">\r
 768         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 769         <td class="sig">\r
 770         <a id="Ext.sql.SQLiteStore-hasListener"></a>\r
 771             <b>hasListener</b>(&nbsp;<code>String eventName</code>&nbsp;) : Boolean            <div class="mdesc">\r
 772                         <div class="short">Checks to see if this object has any listeners for a specified event</div>\r
 773             <div class="long">\r
 774                 Checks to see if this object has any listeners for a specified event    <div class="mdetail-params">\r
 775         <strong>Parameters:</strong>\r
 776         <ul><li><code>eventName</code> : String<div class="sub-desc">The name of the event to check for</div></li>        </ul>\r
 777         <strong>Returns:</strong>\r
 778         <ul>\r
 779             <li><code>Boolean</code><div class="sub-desc">True if the event is being listened for, else false</div></li>\r
 780         </ul>\r
 781     </div>\r
 782                 </div>\r
 783                         </div>\r
 784         </td>\r
 785         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#hasListener" href="output/Ext.util.Observable.html#hasListener">Observable</a></td>\r
 786     </tr>\r
 787         <tr class="method-row inherited expandable">\r
 788         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 789         <td class="sig">\r
 790         <a id="Ext.sql.SQLiteStore-indexOf"></a>\r
 791             <b>indexOf</b>(&nbsp;<code>Ext.data.Record record</code>&nbsp;) : Number            <div class="mdesc">\r
 792                         <div class="short">Get the index within the cache of the passed Record.</div>\r
 793             <div class="long">\r
 794                 Get the index within the cache of the passed Record.    <div class="mdetail-params">\r
 795         <strong>Parameters:</strong>\r
 796         <ul><li><code>record</code> : Ext.data.Record<div class="sub-desc">The Ext.data.Record object to find.</div></li>        </ul>\r
 797         <strong>Returns:</strong>\r
 798         <ul>\r
 799             <li><code>Number</code><div class="sub-desc">The index of the passed Record. Returns -1 if not found.</div></li>\r
 800         </ul>\r
 801     </div>\r
 802                 </div>\r
 803                         </div>\r
 804         </td>\r
 805         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#indexOf" href="output/Ext.data.Store.html#indexOf">Store</a></td>\r
 806     </tr>\r
 807         <tr class="method-row inherited alt expandable">\r
 808         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 809         <td class="sig">\r
 810         <a id="Ext.sql.SQLiteStore-indexOfId"></a>\r
 811             <b>indexOfId</b>(&nbsp;<code>String id</code>&nbsp;) : Number            <div class="mdesc">\r
 812                         <div class="short">Get the index within the cache of the Record with the passed id.</div>\r
 813             <div class="long">\r
 814                 Get the index within the cache of the Record with the passed id.    <div class="mdetail-params">\r
 815         <strong>Parameters:</strong>\r
 816         <ul><li><code>id</code> : String<div class="sub-desc">The id of the Record to find.</div></li>        </ul>\r
 817         <strong>Returns:</strong>\r
 818         <ul>\r
 819             <li><code>Number</code><div class="sub-desc">The index of the Record. Returns -1 if not found.</div></li>\r
 820         </ul>\r
 821     </div>\r
 822                 </div>\r
 823                         </div>\r
 824         </td>\r
 825         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#indexOfId" href="output/Ext.data.Store.html#indexOfId">Store</a></td>\r
 826     </tr>\r
 827         <tr class="method-row inherited expandable">\r
 828         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 829         <td class="sig">\r
 830         <a id="Ext.sql.SQLiteStore-insert"></a>\r
 831             <b>insert</b>(&nbsp;<code>Number index</code>, <code>Ext.data.Record[] records</code>&nbsp;) : void            <div class="mdesc">\r
 832                         <div class="short">Inserts Records into the Store at the given index and fires the <a ext:cls="Ext.data.Store" ext:member="add" href="output/Ext.data.Store.html#add">add</a> event.</div>\r
 833             <div class="long">\r
 834                 Inserts Records into the Store at the given index and fires the <a ext:cls="Ext.data.Store" ext:member="add" href="output/Ext.data.Store.html#add">add</a> event.    <div class="mdetail-params">\r
 835         <strong>Parameters:</strong>\r
 836         <ul><li><code>index</code> : Number<div class="sub-desc">The start index at which to insert the passed Records.</div></li><li><code>records</code> : Ext.data.Record[]<div class="sub-desc">An Array of Ext.data.Record objects to add to the cache.</div></li>        </ul>\r
 837         <strong>Returns:</strong>\r
 838         <ul>\r
 839             <li><code>void</code></li>\r
 840         </ul>\r
 841     </div>\r
 842                 </div>\r
 843                         </div>\r
 844         </td>\r
 845         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#insert" href="output/Ext.data.Store.html#insert">Store</a></td>\r
 846     </tr>\r
 847         <tr class="method-row inherited alt expandable">\r
 848         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 849         <td class="sig">\r
 850         <a id="Ext.sql.SQLiteStore-isFiltered"></a>\r
 851             <b>isFiltered</b>() : Boolean            <div class="mdesc">\r
 852                         <div class="short">Returns true if this store is currently filtered</div>\r
 853             <div class="long">\r
 854                 Returns true if this store is currently filtered    <div class="mdetail-params">\r
 855         <strong>Parameters:</strong>\r
 856         <ul><li>None.</li>        </ul>\r
 857         <strong>Returns:</strong>\r
 858         <ul>\r
 859             <li><code>Boolean</code></li>\r
 860         </ul>\r
 861     </div>\r
 862                 </div>\r
 863                         </div>\r
 864         </td>\r
 865         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#isFiltered" href="output/Ext.data.Store.html#isFiltered">Store</a></td>\r
 866     </tr>\r
 867         <tr class="method-row inherited expandable">\r
 868         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 869         <td class="sig">\r
 870         <a id="Ext.sql.SQLiteStore-load"></a>\r
 871             <b>load</b>(&nbsp;<code>Object options</code>&nbsp;) : Boolean            <div class="mdesc">\r
 872                         <div class="short">Loads the Record cache from the configured Proxy using the configured Reader.
 873 If using remote paging, then the first ...</div>\r
 874             <div class="long">\r
 875                 Loads the Record cache from the configured Proxy using the configured Reader.
 876 <p>If using remote paging, then the first load call must specify the <tt>start</tt>
 877 and <tt>limit</tt> properties in the options.params property to establish the initial
 878 position within the dataset, and the number of Records to cache on each read from the Proxy.</p>
 879 <p><b>It is important to note that for remote data sources, loading is asynchronous,
 880 and this call will return before the new data has been loaded. Perform any post-processing
 881 in a callback function, or in a "load" event handler.</b></p>    <div class="mdetail-params">\r
 882         <strong>Parameters:</strong>\r
 883         <ul><li><code>options</code> : Object<div class="sub-desc">An object containing properties which control loading options:<ul>
 884 <li><b>params</b> :Object<p class="sub-desc">An object containing properties to pass as HTTP parameters to a remote data source.</p></li>
 885 <li><b>callback</b> : Function<p class="sub-desc">A function to be called after the Records have been loaded. The callback is
 886 passed the following arguments:<ul>
 887 <li>r : Ext.data.Record[]</li>
 888 <li>options: Options object from the load call</li>
 889 <li>success: Boolean success indicator</li></ul></p></li>
 890 <li><b>scope</b> : Object<p class="sub-desc">Scope with which to call the callback (defaults to the Store object)</p></li>
 891 <li><b>add</b> : Boolean<p class="sub-desc">Indicator to append loaded records rather than replace the current cache.</p></li>
 892 </ul></div></li>        </ul>\r
 893         <strong>Returns:</strong>\r
 894         <ul>\r
 895             <li><code>Boolean</code><div class="sub-desc">Whether the load fired (if beforeload failed).</div></li>\r
 896         </ul>\r
 897     </div>\r
 898                 </div>\r
 899                         </div>\r
 900         </td>\r
 901         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#load" href="output/Ext.data.Store.html#load">Store</a></td>\r
 902     </tr>\r
 903         <tr class="method-row inherited alt expandable">\r
 904         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 905         <td class="sig">\r
 906         <a id="Ext.sql.SQLiteStore-loadData"></a>\r
 907             <b>loadData</b>(&nbsp;<code>Object data</code>, <span class="optional" title="Optional">[<code>Boolean add</code>]</span>&nbsp;) : void            <div class="mdesc">\r
 908                         <div class="short">Loads data from a passed data block and fires the load event. A Reader which understands the format of the data
 909 must ...</div>\r
 910             <div class="long">\r
 911                 Loads data from a passed data block and fires the <a ext:cls="Ext.data.Store" ext:member="load" href="output/Ext.data.Store.html#load">load</a> event. A Reader which understands the format of the data
 912 must have been configured in the constructor.    <div class="mdetail-params">\r
 913         <strong>Parameters:</strong>\r
 914         <ul><li><code>data</code> : Object<div class="sub-desc">The data block from which to read the Records. The format of the data expected
 915 is dependent on the type of Reader that is configured and should correspond to that Reader's readRecords parameter.</div></li><li><code>add</code> : Boolean<div class="sub-desc">(Optional) True to add the new Records rather than replace the existing cache. <b>Remember that
 916 Records in a Store are keyed by their <a ext:cls="Ext.data.Record" ext:member="id" href="output/Ext.data.Record.html#id">id</a>, so added Records with ids which are already present in
 917 the Store will <i>replace</i> existing Records. Records with new, unique ids will be added.</b></div></li>        </ul>\r
 918         <strong>Returns:</strong>\r
 919         <ul>\r
 920             <li><code>void</code></li>\r
 921         </ul>\r
 922     </div>\r
 923                 </div>\r
 924                         </div>\r
 925         </td>\r
 926         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#loadData" href="output/Ext.data.Store.html#loadData">Store</a></td>\r
 927     </tr>\r
 928         <tr class="method-row inherited expandable">\r
 929         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 930         <td class="sig">\r
 931         <a id="Ext.sql.SQLiteStore-on"></a>\r
 932             <b>on</b>(&nbsp;<code>String eventName</code>, <code>Function handler</code>, <span class="optional" title="Optional">[<code>Object scope</code>]</span>, <span class="optional" title="Optional">[<code>Object options</code>]</span>&nbsp;) : void            <div class="mdesc">\r
 933                         <div class="short">Appends an event handler to this element (shorthand for addListener)</div>\r
 934             <div class="long">\r
 935                 Appends an event handler to this element (shorthand for addListener)    <div class="mdetail-params">\r
 936         <strong>Parameters:</strong>\r
 937         <ul><li><code>eventName</code> : String<div class="sub-desc">The type of event to listen for</div></li><li><code>handler</code> : Function<div class="sub-desc">The method the event invokes</div></li><li><code>scope</code> : Object<div class="sub-desc">(optional) The scope in which to execute the handler
 938 function. The handler function's "this" context.</div></li><li><code>options</code> : Object<div class="sub-desc">(optional)</div></li>        </ul>\r
 939         <strong>Returns:</strong>\r
 940         <ul>\r
 941             <li><code>void</code></li>\r
 942         </ul>\r
 943     </div>\r
 944                 </div>\r
 945                         </div>\r
 946         </td>\r
 947         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#on" href="output/Ext.util.Observable.html#on">Observable</a></td>\r
 948     </tr>\r
 949         <tr class="method-row inherited alt expandable">\r
 950         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 951         <td class="sig">\r
 952         <a id="Ext.sql.SQLiteStore-purgeListeners"></a>\r
 953             <b>purgeListeners</b>() : void            <div class="mdesc">\r
 954                         <div class="short">Removes all listeners for this object</div>\r
 955             <div class="long">\r
 956                 Removes all listeners for this object    <div class="mdetail-params">\r
 957         <strong>Parameters:</strong>\r
 958         <ul><li>None.</li>        </ul>\r
 959         <strong>Returns:</strong>\r
 960         <ul>\r
 961             <li><code>void</code></li>\r
 962         </ul>\r
 963     </div>\r
 964                 </div>\r
 965                         </div>\r
 966         </td>\r
 967         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#purgeListeners" href="output/Ext.util.Observable.html#purgeListeners">Observable</a></td>\r
 968     </tr>\r
 969         <tr class="method-row inherited expandable">\r
 970         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 971         <td class="sig">\r
 972         <a id="Ext.sql.SQLiteStore-query"></a>\r
 973             <b>query</b>(&nbsp;<code>String field</code>, <code>String/RegExp value</code>, <span class="optional" title="Optional">[<code>Boolean anyMatch</code>]</span>, <span class="optional" title="Optional">[<code>Boolean caseSensitive</code>]</span>&nbsp;) : MixedCollection            <div class="mdesc">\r
 974                         <div class="short">Query the records by a specified property.</div>\r
 975             <div class="long">\r
 976                 Query the records by a specified property.    <div class="mdetail-params">\r
 977         <strong>Parameters:</strong>\r
 978         <ul><li><code>field</code> : String<div class="sub-desc">A field on your records</div></li><li><code>value</code> : String/RegExp<div class="sub-desc">Either a string that the field
 979 should begin with, or a RegExp to test against the field.</div></li><li><code>anyMatch</code> : Boolean<div class="sub-desc">(optional) True to match any part not just the beginning</div></li><li><code>caseSensitive</code> : Boolean<div class="sub-desc">(optional) True for case sensitive comparison</div></li>        </ul>\r
 980         <strong>Returns:</strong>\r
 981         <ul>\r
 982             <li><code>MixedCollection</code><div class="sub-desc">Returns an Ext.util.MixedCollection of the matched records</div></li>\r
 983         </ul>\r
 984     </div>\r
 985                 </div>\r
 986                         </div>\r
 987         </td>\r
 988         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#query" href="output/Ext.data.Store.html#query">Store</a></td>\r
 989     </tr>\r
 990         <tr class="method-row inherited alt expandable">\r
 991         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
 992         <td class="sig">\r
 993         <a id="Ext.sql.SQLiteStore-queryBy"></a>\r
 994             <b>queryBy</b>(&nbsp;<code>Function fn</code>, <span class="optional" title="Optional">[<code>Object scope</code>]</span>&nbsp;) : MixedCollection            <div class="mdesc">\r
 995                         <div class="short">Query the cached records in this Store using a filtering function. The specified function
 996 will be called with each re...</div>\r
 997             <div class="long">\r
 998                 Query the cached records in this Store using a filtering function. The specified function
 999 will be called with each record in this Store. If the function returns <tt>true</tt> the record is
1000 included in the results.    <div class="mdetail-params">\r
1001         <strong>Parameters:</strong>\r
1002         <ul><li><code>fn</code> : Function<div class="sub-desc">The function to be called. It will be passed the following parameters:<ul>
1003 <li><b>record</b> : Ext.data.Record<p class="sub-desc">The <a ext:cls="Ext.data.Record" href="output/Ext.data.Record.html">record</a>
1004 to test for filtering. Access field values using <a ext:cls="Ext.data.Record" ext:member="get" href="output/Ext.data.Record.html#get">Ext.data.Record.get</a>.</p></li>
1005 <li><b>id</b> : Object<p class="sub-desc">The ID of the Record passed.</p></li>
1006 </ul></div></li><li><code>scope</code> : Object<div class="sub-desc">(optional) The scope of the function (defaults to this)</div></li>        </ul>\r
1007         <strong>Returns:</strong>\r
1008         <ul>\r
1009             <li><code>MixedCollection</code><div class="sub-desc">Returns an Ext.util.MixedCollection of the matched records</div></li>\r
1010         </ul>\r
1011     </div>\r
1012                 </div>\r
1013                         </div>\r
1014         </td>\r
1015         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#queryBy" href="output/Ext.data.Store.html#queryBy">Store</a></td>\r
1016     </tr>\r
1017         <tr class="method-row inherited expandable">\r
1018         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1019         <td class="sig">\r
1020         <a id="Ext.sql.SQLiteStore-rejectChanges"></a>\r
1021             <b>rejectChanges</b>() : void            <div class="mdesc">\r
1022                         <div class="short">Cancel outstanding changes on all changed records.</div>\r
1023             <div class="long">\r
1024                 Cancel outstanding changes on all changed records.    <div class="mdetail-params">\r
1025         <strong>Parameters:</strong>\r
1026         <ul><li>None.</li>        </ul>\r
1027         <strong>Returns:</strong>\r
1028         <ul>\r
1029             <li><code>void</code></li>\r
1030         </ul>\r
1031     </div>\r
1032                 </div>\r
1033                         </div>\r
1034         </td>\r
1035         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#rejectChanges" href="output/Ext.data.Store.html#rejectChanges">Store</a></td>\r
1036     </tr>\r
1037         <tr class="method-row inherited alt expandable">\r
1038         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1039         <td class="sig">\r
1040         <a id="Ext.sql.SQLiteStore-relayEvents"></a>\r
1041             <b>relayEvents</b>(&nbsp;<code>Object o</code>, <code>Array events</code>&nbsp;) : void            <div class="mdesc">\r
1042                         <div class="short">Relays selected events from the specified Observable as if the events were fired by <tt><b>this</b></tt>.</div>\r
1043             <div class="long">\r
1044                 Relays selected events from the specified Observable as if the events were fired by <tt><b>this</b></tt>.    <div class="mdetail-params">\r
1045         <strong>Parameters:</strong>\r
1046         <ul><li><code>o</code> : Object<div class="sub-desc">The Observable whose events this object is to relay.</div></li><li><code>events</code> : Array<div class="sub-desc">Array of event names to relay.</div></li>        </ul>\r
1047         <strong>Returns:</strong>\r
1048         <ul>\r
1049             <li><code>void</code></li>\r
1050         </ul>\r
1051     </div>\r
1052                 </div>\r
1053                         </div>\r
1054         </td>\r
1055         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#relayEvents" href="output/Ext.util.Observable.html#relayEvents">Observable</a></td>\r
1056     </tr>\r
1057         <tr class="method-row inherited expandable">\r
1058         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1059         <td class="sig">\r
1060         <a id="Ext.sql.SQLiteStore-reload"></a>\r
1061             <b>reload</b>(&nbsp;<span class="optional" title="Optional">[<code>Object options</code>]</span>&nbsp;) : void            <div class="mdesc">\r
1062                         <div class="short">Reloads the Record cache from the configured Proxy using the configured Reader and
1063 the options from the last load ope...</div>\r
1064             <div class="long">\r
1065                 <p>Reloads the Record cache from the configured Proxy using the configured Reader and
1066 the options from the last load operation performed.</p>
1067 <p><b>It is important to note that for remote data sources, loading is asynchronous,
1068 and this call will return before the new data has been loaded. Perform any post-processing
1069 in a callback function, or in a "load" event handler.</b></p>    <div class="mdetail-params">\r
1070         <strong>Parameters:</strong>\r
1071         <ul><li><code>options</code> : Object<div class="sub-desc">(optional) An object containing loading options which may override the options
1072 used in the last load operation. See <a ext:cls="Ext.data.Store" ext:member="load" href="output/Ext.data.Store.html#load">load</a> for details (defaults to null, in which case
1073 the most recently used options are reused).</div></li>        </ul>\r
1074         <strong>Returns:</strong>\r
1075         <ul>\r
1076             <li><code>void</code></li>\r
1077         </ul>\r
1078     </div>\r
1079                 </div>\r
1080                         </div>\r
1081         </td>\r
1082         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#reload" href="output/Ext.data.Store.html#reload">Store</a></td>\r
1083     </tr>\r
1084         <tr class="method-row inherited alt expandable">\r
1085         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1086         <td class="sig">\r
1087         <a id="Ext.sql.SQLiteStore-remove"></a>\r
1088             <b>remove</b>(&nbsp;<code>Ext.data.Record record</code>&nbsp;) : void            <div class="mdesc">\r
1089                         <div class="short">Remove a Record from the Store and fires the <a ext:cls="Ext.data.Store" ext:member="remove" href="output/Ext.data.Store.html#remove">remove</a> event.</div>\r
1090             <div class="long">\r
1091                 Remove a Record from the Store and fires the <a ext:cls="Ext.data.Store" ext:member="remove" href="output/Ext.data.Store.html#remove">remove</a> event.    <div class="mdetail-params">\r
1092         <strong>Parameters:</strong>\r
1093         <ul><li><code>record</code> : Ext.data.Record<div class="sub-desc">The Ext.data.Record object to remove from the cache.</div></li>        </ul>\r
1094         <strong>Returns:</strong>\r
1095         <ul>\r
1096             <li><code>void</code></li>\r
1097         </ul>\r
1098     </div>\r
1099                 </div>\r
1100                         </div>\r
1101         </td>\r
1102         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#remove" href="output/Ext.data.Store.html#remove">Store</a></td>\r
1103     </tr>\r
1104         <tr class="method-row inherited expandable">\r
1105         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1106         <td class="sig">\r
1107         <a id="Ext.sql.SQLiteStore-removeAll"></a>\r
1108             <b>removeAll</b>() : void            <div class="mdesc">\r
1109                         <div class="short">Remove all Records from the Store and fires the <a ext:cls="Ext.data.Store" ext:member="clear" href="output/Ext.data.Store.html#clear">clear</a> event.</div>\r
1110             <div class="long">\r
1111                 Remove all Records from the Store and fires the <a ext:cls="Ext.data.Store" ext:member="clear" href="output/Ext.data.Store.html#clear">clear</a> event.    <div class="mdetail-params">\r
1112         <strong>Parameters:</strong>\r
1113         <ul><li>None.</li>        </ul>\r
1114         <strong>Returns:</strong>\r
1115         <ul>\r
1116             <li><code>void</code></li>\r
1117         </ul>\r
1118     </div>\r
1119                 </div>\r
1120                         </div>\r
1121         </td>\r
1122         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#removeAll" href="output/Ext.data.Store.html#removeAll">Store</a></td>\r
1123     </tr>\r
1124         <tr class="method-row inherited alt expandable">\r
1125         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1126         <td class="sig">\r
1127         <a id="Ext.sql.SQLiteStore-removeAt"></a>\r
1128             <b>removeAt</b>(&nbsp;<code>Number index</code>&nbsp;) : void            <div class="mdesc">\r
1129                         <div class="short">Remove a Record from the Store at the specified index. Fires the <a ext:cls="Ext.data.Store" ext:member="remove" href="output/Ext.data.Store.html#remove">remove</a> event.</div>\r
1130             <div class="long">\r
1131                 Remove a Record from the Store at the specified index. Fires the <a ext:cls="Ext.data.Store" ext:member="remove" href="output/Ext.data.Store.html#remove">remove</a> event.    <div class="mdetail-params">\r
1132         <strong>Parameters:</strong>\r
1133         <ul><li><code>index</code> : Number<div class="sub-desc">The index of the record to remove.</div></li>        </ul>\r
1134         <strong>Returns:</strong>\r
1135         <ul>\r
1136             <li><code>void</code></li>\r
1137         </ul>\r
1138     </div>\r
1139                 </div>\r
1140                         </div>\r
1141         </td>\r
1142         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#removeAt" href="output/Ext.data.Store.html#removeAt">Store</a></td>\r
1143     </tr>\r
1144         <tr class="method-row inherited expandable">\r
1145         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1146         <td class="sig">\r
1147         <a id="Ext.sql.SQLiteStore-removeListener"></a>\r
1148             <b>removeListener</b>(&nbsp;<code>String eventName</code>, <code>Function handler</code>, <span class="optional" title="Optional">[<code>Object scope</code>]</span>&nbsp;) : void            <div class="mdesc">\r
1149                         <div class="short">Removes a listener</div>\r
1150             <div class="long">\r
1151                 Removes a listener    <div class="mdetail-params">\r
1152         <strong>Parameters:</strong>\r
1153         <ul><li><code>eventName</code> : String<div class="sub-desc">The type of event to listen for</div></li><li><code>handler</code> : Function<div class="sub-desc">The handler to remove</div></li><li><code>scope</code> : Object<div class="sub-desc">(optional) The scope (this object) for the handler</div></li>        </ul>\r
1154         <strong>Returns:</strong>\r
1155         <ul>\r
1156             <li><code>void</code></li>\r
1157         </ul>\r
1158     </div>\r
1159                 </div>\r
1160                         </div>\r
1161         </td>\r
1162         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#removeListener" href="output/Ext.util.Observable.html#removeListener">Observable</a></td>\r
1163     </tr>\r
1164         <tr class="method-row inherited alt expandable">\r
1165         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1166         <td class="sig">\r
1167         <a id="Ext.sql.SQLiteStore-resumeEvents"></a>\r
1168             <b>resumeEvents</b>() : void            <div class="mdesc">\r
1169                         <div class="short">Resume firing events. (see <a ext:cls="Ext.util.Observable" ext:member="suspendEvents" href="output/Ext.util.Observable.html#suspendEvents">suspendEvents</a>)</div>\r
1170             <div class="long">\r
1171                 Resume firing events. (see <a ext:cls="Ext.util.Observable" ext:member="suspendEvents" href="output/Ext.util.Observable.html#suspendEvents">suspendEvents</a>)    <div class="mdetail-params">\r
1172         <strong>Parameters:</strong>\r
1173         <ul><li>None.</li>        </ul>\r
1174         <strong>Returns:</strong>\r
1175         <ul>\r
1176             <li><code>void</code></li>\r
1177         </ul>\r
1178     </div>\r
1179                 </div>\r
1180                         </div>\r
1181         </td>\r
1182         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#resumeEvents" href="output/Ext.util.Observable.html#resumeEvents">Observable</a></td>\r
1183     </tr>\r
1184         <tr class="method-row inherited expandable">\r
1185         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1186         <td class="sig">\r
1187         <a id="Ext.sql.SQLiteStore-setDefaultSort"></a>\r
1188             <b>setDefaultSort</b>(&nbsp;<code>String fieldName</code>, <span class="optional" title="Optional">[<code>String dir</code>]</span>&nbsp;) : void            <div class="mdesc">\r
1189                         <div class="short">Sets the default sort column and order to be used by the next load operation.</div>\r
1190             <div class="long">\r
1191                 Sets the default sort column and order to be used by the next load operation.    <div class="mdetail-params">\r
1192         <strong>Parameters:</strong>\r
1193         <ul><li><code>fieldName</code> : String<div class="sub-desc">The name of the field to sort by.</div></li><li><code>dir</code> : String<div class="sub-desc">(optional) The sort order, "ASC" or "DESC" (case-sensitive, defaults to "ASC")</div></li>        </ul>\r
1194         <strong>Returns:</strong>\r
1195         <ul>\r
1196             <li><code>void</code></li>\r
1197         </ul>\r
1198     </div>\r
1199                 </div>\r
1200                         </div>\r
1201         </td>\r
1202         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#setDefaultSort" href="output/Ext.data.Store.html#setDefaultSort">Store</a></td>\r
1203     </tr>\r
1204         <tr class="method-row inherited alt expandable">\r
1205         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1206         <td class="sig">\r
1207         <a id="Ext.sql.SQLiteStore-sort"></a>\r
1208             <b>sort</b>(&nbsp;<code>String fieldName</code>, <span class="optional" title="Optional">[<code>String dir</code>]</span>&nbsp;) : void            <div class="mdesc">\r
1209                         <div class="short">Sort the Records.
1210 If remote sorting is used, the sort is performed on the server, and the cache is
1211 reloaded. If local...</div>\r
1212             <div class="long">\r
1213                 Sort the Records.
1214 If remote sorting is used, the sort is performed on the server, and the cache is
1215 reloaded. If local sorting is used, the cache is sorted internally.    <div class="mdetail-params">\r
1216         <strong>Parameters:</strong>\r
1217         <ul><li><code>fieldName</code> : String<div class="sub-desc">The name of the field to sort by.</div></li><li><code>dir</code> : String<div class="sub-desc">(optional) The sort order, "ASC" or "DESC" (case-sensitive, defaults to "ASC")</div></li>        </ul>\r
1218         <strong>Returns:</strong>\r
1219         <ul>\r
1220             <li><code>void</code></li>\r
1221         </ul>\r
1222     </div>\r
1223                 </div>\r
1224                         </div>\r
1225         </td>\r
1226         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#sort" href="output/Ext.data.Store.html#sort">Store</a></td>\r
1227     </tr>\r
1228         <tr class="method-row inherited expandable">\r
1229         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1230         <td class="sig">\r
1231         <a id="Ext.sql.SQLiteStore-sum"></a>\r
1232             <b>sum</b>(&nbsp;<code>String property</code>, <code>Number start</code>, <code>Number end</code>&nbsp;) : Number            <div class="mdesc">\r
1233                         <div class="short">Sums the value of <i>property</i> for each record between start and end and returns the result.</div>\r
1234             <div class="long">\r
1235                 Sums the value of <i>property</i> for each record between start and end and returns the result.    <div class="mdetail-params">\r
1236         <strong>Parameters:</strong>\r
1237         <ul><li><code>property</code> : String<div class="sub-desc">A field on your records</div></li><li><code>start</code> : Number<div class="sub-desc">The record index to start at (defaults to 0)</div></li><li><code>end</code> : Number<div class="sub-desc">The last record index to include (defaults to length - 1)</div></li>        </ul>\r
1238         <strong>Returns:</strong>\r
1239         <ul>\r
1240             <li><code>Number</code><div class="sub-desc">The sum</div></li>\r
1241         </ul>\r
1242     </div>\r
1243                 </div>\r
1244                         </div>\r
1245         </td>\r
1246         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#sum" href="output/Ext.data.Store.html#sum">Store</a></td>\r
1247     </tr>\r
1248         <tr class="method-row inherited alt expandable">\r
1249         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1250         <td class="sig">\r
1251         <a id="Ext.sql.SQLiteStore-suspendEvents"></a>\r
1252             <b>suspendEvents</b>() : void            <div class="mdesc">\r
1253                         <div class="short">Suspend the firing of all events. (see <a ext:cls="Ext.util.Observable" ext:member="resumeEvents" href="output/Ext.util.Observable.html#resumeEvents">resumeEvents</a>)</div>\r
1254             <div class="long">\r
1255                 Suspend the firing of all events. (see <a ext:cls="Ext.util.Observable" ext:member="resumeEvents" href="output/Ext.util.Observable.html#resumeEvents">resumeEvents</a>)    <div class="mdetail-params">\r
1256         <strong>Parameters:</strong>\r
1257         <ul><li>None.</li>        </ul>\r
1258         <strong>Returns:</strong>\r
1259         <ul>\r
1260             <li><code>void</code></li>\r
1261         </ul>\r
1262     </div>\r
1263                 </div>\r
1264                         </div>\r
1265         </td>\r
1266         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#suspendEvents" href="output/Ext.util.Observable.html#suspendEvents">Observable</a></td>\r
1267     </tr>\r
1268         <tr class="method-row inherited expandable">\r
1269         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1270         <td class="sig">\r
1271         <a id="Ext.sql.SQLiteStore-un"></a>\r
1272             <b>un</b>(&nbsp;<code>String eventName</code>, <code>Function handler</code>, <span class="optional" title="Optional">[<code>Object scope</code>]</span>&nbsp;) : void            <div class="mdesc">\r
1273                         <div class="short">Removes a listener (shorthand for removeListener)</div>\r
1274             <div class="long">\r
1275                 Removes a listener (shorthand for removeListener)    <div class="mdetail-params">\r
1276         <strong>Parameters:</strong>\r
1277         <ul><li><code>eventName</code> : String<div class="sub-desc">The type of event to listen for</div></li><li><code>handler</code> : Function<div class="sub-desc">The handler to remove</div></li><li><code>scope</code> : Object<div class="sub-desc">(optional) The scope (this object) for the handler</div></li>        </ul>\r
1278         <strong>Returns:</strong>\r
1279         <ul>\r
1280             <li><code>void</code></li>\r
1281         </ul>\r
1282     </div>\r
1283                 </div>\r
1284                         </div>\r
1285         </td>\r
1286         <td class="msource"><a ext:cls="Ext.util.Observable" ext:member="#un" href="output/Ext.util.Observable.html#un">Observable</a></td>\r
1287     </tr>\r
1288             </table>
1289                 <a id="Ext.sql.SQLiteStore-events"></a>
1290         <h2>Public Events</h2>
1291                 <table cellspacing="0" class="member-table">
1292             <tr>
1293                 <th class="sig-header" colspan="2">Event</th>
1294                 <th class="msource-header">Defined By</th>
1295             </tr>
1296                 <tr class="event-row inherited expandable">\r
1297         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1298         <td class="sig">\r
1299         <a id="Ext.sql.SQLiteStore-add"></a>\r
1300             <b>add</b> : (&nbsp;<code>Store this</code>, <code>Ext.data.Record[] records</code>, <code>Number index</code>&nbsp;)            <div class="mdesc">\r
1301                         <div class="short">Fires when Records have been added to the Store</div>\r
1302             <div class="long">\r
1303                 Fires when Records have been added to the Store    <div class="mdetail-params">\r
1304         <strong style="font-weight:normal;">Listeners will be called with the following arguments:</strong>\r
1305         <ul><li><code>this</code> : Store<div class="sub-desc"></div></li><li><code>records</code> : Ext.data.Record[]<div class="sub-desc">The array of Records added</div></li><li><code>index</code> : Number<div class="sub-desc">The index at which the record(s) were added</div></li>        </ul>\r
1306     </div>\r
1307                 </div>\r
1308                         </div>\r
1309         </td>\r
1310         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#event-add" href="output/Ext.data.Store.html#event-add">Store</a></td>\r
1311     </tr>\r
1312         <tr class="event-row inherited alt expandable">\r
1313         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1314         <td class="sig">\r
1315         <a id="Ext.sql.SQLiteStore-beforeload"></a>\r
1316             <b>beforeload</b> : (&nbsp;<code>Store this</code>, <code>Object options</code>&nbsp;)            <div class="mdesc">\r
1317                         <div class="short">Fires before a request is made for a new data object.  If the beforeload handler returns false
1318 the load action will b...</div>\r
1319             <div class="long">\r
1320                 Fires before a request is made for a new data object.  If the beforeload handler returns false
1321 the load action will be canceled.    <div class="mdetail-params">\r
1322         <strong style="font-weight:normal;">Listeners will be called with the following arguments:</strong>\r
1323         <ul><li><code>this</code> : Store<div class="sub-desc"></div></li><li><code>options</code> : Object<div class="sub-desc">The loading options that were specified (see <a ext:cls="Ext.data.Store" ext:member="load" href="output/Ext.data.Store.html#load">load</a> for details)</div></li>        </ul>\r
1324     </div>\r
1325                 </div>\r
1326                         </div>\r
1327         </td>\r
1328         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#event-beforeload" href="output/Ext.data.Store.html#event-beforeload">Store</a></td>\r
1329     </tr>\r
1330         <tr class="event-row inherited expandable">\r
1331         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1332         <td class="sig">\r
1333         <a id="Ext.sql.SQLiteStore-clear"></a>\r
1334             <b>clear</b> : (&nbsp;<code>Store this</code>&nbsp;)            <div class="mdesc">\r
1335                         <div class="short">Fires when the data cache has been cleared.</div>\r
1336             <div class="long">\r
1337                 Fires when the data cache has been cleared.    <div class="mdetail-params">\r
1338         <strong style="font-weight:normal;">Listeners will be called with the following arguments:</strong>\r
1339         <ul><li><code>this</code> : Store<div class="sub-desc"></div></li>        </ul>\r
1340     </div>\r
1341                 </div>\r
1342                         </div>\r
1343         </td>\r
1344         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#event-clear" href="output/Ext.data.Store.html#event-clear">Store</a></td>\r
1345     </tr>\r
1346         <tr class="event-row inherited alt expandable">\r
1347         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1348         <td class="sig">\r
1349         <a id="Ext.sql.SQLiteStore-datachanged"></a>\r
1350             <b>datachanged</b> : (&nbsp;<code>Store this</code>&nbsp;)            <div class="mdesc">\r
1351                         <div class="short">Fires when the data cache has changed in a bulk manner (e.g., it has been sorted, filtered, etc.) and a
1352 widget that ...</div>\r
1353             <div class="long">\r
1354                 Fires when the data cache has changed in a bulk manner (e.g., it has been sorted, filtered, etc.) and a
1355 widget that is using this Store as a Record cache should refresh its view.    <div class="mdetail-params">\r
1356         <strong style="font-weight:normal;">Listeners will be called with the following arguments:</strong>\r
1357         <ul><li><code>this</code> : Store<div class="sub-desc"></div></li>        </ul>\r
1358     </div>\r
1359                 </div>\r
1360                         </div>\r
1361         </td>\r
1362         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#event-datachanged" href="output/Ext.data.Store.html#event-datachanged">Store</a></td>\r
1363     </tr>\r
1364         <tr class="event-row inherited expandable">\r
1365         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1366         <td class="sig">\r
1367         <a id="Ext.sql.SQLiteStore-load"></a>\r
1368             <b>load</b> : (&nbsp;<code>Store this</code>, <code>Ext.data.Record[] records</code>, <code>Object options</code>&nbsp;)            <div class="mdesc">\r
1369                         <div class="short">Fires after a new set of Records has been loaded.</div>\r
1370             <div class="long">\r
1371                 Fires after a new set of Records has been loaded.    <div class="mdetail-params">\r
1372         <strong style="font-weight:normal;">Listeners will be called with the following arguments:</strong>\r
1373         <ul><li><code>this</code> : Store<div class="sub-desc"></div></li><li><code>records</code> : Ext.data.Record[]<div class="sub-desc">The Records that were loaded</div></li><li><code>options</code> : Object<div class="sub-desc">The loading options that were specified (see <a ext:cls="Ext.data.Store" ext:member="load" href="output/Ext.data.Store.html#load">load</a> for details)</div></li>        </ul>\r
1374     </div>\r
1375                 </div>\r
1376                         </div>\r
1377         </td>\r
1378         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#event-load" href="output/Ext.data.Store.html#event-load">Store</a></td>\r
1379     </tr>\r
1380         <tr class="event-row inherited alt expandable">\r
1381         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1382         <td class="sig">\r
1383         <a id="Ext.sql.SQLiteStore-loadexception"></a>\r
1384             <b>loadexception</b> : ()            <div class="mdesc">\r
1385                         <div class="short">Fires if an exception occurs in the Proxy during loading.
1386 Called with the signature of the Proxy's "loadexception" ev...</div>\r
1387             <div class="long">\r
1388                 Fires if an exception occurs in the Proxy during loading.
1389 Called with the signature of the Proxy's "loadexception" event.    <div class="mdetail-params">\r
1390         <strong style="font-weight:normal;">Listeners will be called with the following arguments:</strong>\r
1391         <ul><li>None.</li>        </ul>\r
1392     </div>\r
1393                 </div>\r
1394                         </div>\r
1395         </td>\r
1396         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#event-loadexception" href="output/Ext.data.Store.html#event-loadexception">Store</a></td>\r
1397     </tr>\r
1398         <tr class="event-row inherited expandable">\r
1399         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1400         <td class="sig">\r
1401         <a id="Ext.sql.SQLiteStore-metachange"></a>\r
1402             <b>metachange</b> : (&nbsp;<code>Store this</code>, <code>Object meta</code>&nbsp;)            <div class="mdesc">\r
1403                         <div class="short">Fires when this store's reader provides new metadata (fields). This is currently only supported for JsonReaders.</div>\r
1404             <div class="long">\r
1405                 Fires when this store's reader provides new metadata (fields). This is currently only supported for JsonReaders.    <div class="mdetail-params">\r
1406         <strong style="font-weight:normal;">Listeners will be called with the following arguments:</strong>\r
1407         <ul><li><code>this</code> : Store<div class="sub-desc"></div></li><li><code>meta</code> : Object<div class="sub-desc">The JSON metadata</div></li>        </ul>\r
1408     </div>\r
1409                 </div>\r
1410                         </div>\r
1411         </td>\r
1412         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#event-metachange" href="output/Ext.data.Store.html#event-metachange">Store</a></td>\r
1413     </tr>\r
1414         <tr class="event-row inherited alt expandable">\r
1415         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1416         <td class="sig">\r
1417         <a id="Ext.sql.SQLiteStore-remove"></a>\r
1418             <b>remove</b> : (&nbsp;<code>Store this</code>, <code>Ext.data.Record record</code>, <code>Number index</code>&nbsp;)            <div class="mdesc">\r
1419                         <div class="short">Fires when a Record has been removed from the Store</div>\r
1420             <div class="long">\r
1421                 Fires when a Record has been removed from the Store    <div class="mdetail-params">\r
1422         <strong style="font-weight:normal;">Listeners will be called with the following arguments:</strong>\r
1423         <ul><li><code>this</code> : Store<div class="sub-desc"></div></li><li><code>record</code> : Ext.data.Record<div class="sub-desc">The Record that was removed</div></li><li><code>index</code> : Number<div class="sub-desc">The index at which the record was removed</div></li>        </ul>\r
1424     </div>\r
1425                 </div>\r
1426                         </div>\r
1427         </td>\r
1428         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#event-remove" href="output/Ext.data.Store.html#event-remove">Store</a></td>\r
1429     </tr>\r
1430         <tr class="event-row inherited expandable">\r
1431         <td class="micon"><a class="exi" href="#expand">&nbsp;</a></td>\r
1432         <td class="sig">\r
1433         <a id="Ext.sql.SQLiteStore-update"></a>\r
1434             <b>update</b> : (&nbsp;<code>Store this</code>, <code>Ext.data.Record record</code>, <code>String operation</code>&nbsp;)            <div class="mdesc">\r
1435                         <div class="short">Fires when a Record has been updated</div>\r
1436             <div class="long">\r
1437                 Fires when a Record has been updated    <div class="mdetail-params">\r
1438         <strong style="font-weight:normal;">Listeners will be called with the following arguments:</strong>\r
1439         <ul><li><code>this</code> : Store<div class="sub-desc"></div></li><li><code>record</code> : Ext.data.Record<div class="sub-desc">The Record that was updated</div></li><li><code>operation</code> : String<div class="sub-desc">The update operation being performed. Value may be one of:
1440 <pre><code>Ext.data.Record.EDIT
1441  Ext.data.Record.REJECT
1442  Ext.data.Record.COMMIT</code></pre></div></li>        </ul>\r
1443     </div>\r
1444                 </div>\r
1445                         </div>\r
1446         </td>\r
1447         <td class="msource"><a ext:cls="Ext.data.Store" ext:member="#event-update" href="output/Ext.data.Store.html#event-update">Store</a></td>\r
1448     </tr>\r
1449             </table>
1450
1451         </div>