System.Data.SQLite
Check-in [1c78566dfe]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Pickup SQLite core library doc changes from upstream.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 1c78566dfe3a8d38a682acbc8f4b613bd725dc91
User & Date: mistachkin 2016-01-06 17:56:22
Context
2016-01-07
23:37
Move the 'empty' test file to the new 'template' directory. check-in: 518569fee5 user: mistachkin tags: trunk
2016-01-06
17:56
Pickup SQLite core library doc changes from upstream. check-in: 1c78566dfe user: mistachkin tags: trunk
17:47
Update SQLite core library to the 3.10.0 release. check-in: 07117807e3 user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to Doc/Extra/Core/lang.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_aggfunc.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_altertable.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_analyze.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_attach.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_comment.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_conflict.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_corefunc.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_createindex.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_createtable.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_createtrigger.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_createview.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_createvtab.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_datefunc.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"
................................................................................
   335    334   
   336    335   <a name="localtime"></a>
   337    336   
   338    337   <p>The "localtime" modifier (12) assumes the time string to its left is in
   339    338   Universal Coordinated Time (UTC) and adjusts the time
   340    339   string so that it displays localtime.  If "localtime"
   341    340   follows a time that is not UTC, then the behavior is undefined.
   342         -The "utc" is the opposite of "localtime".  "utc" assumes that the string
          341  +The "utc" modifier is the opposite of "localtime".  
          342  +"utc" assumes that the string
   343    343   to its left is in the local timezone and adjusts that string to be in UTC.
   344    344   If the prior string is not in localtime, then the result of "utc" is
   345    345   undefined.</p>
   346    346   
   347    347   <h3>Examples</h3>
   348    348   
   349    349   <p>Compute the current date.<p>

Changes to Doc/Extra/Core/lang_delete.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_detach.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_dropindex.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_droptable.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_droptrigger.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_dropview.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_explain.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_expr.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"
................................................................................
   391    390   </tr>
   392    391   <tr>
   393    392   <td align="right" valign="top"><b>$</b><i>AAAA</i></td><td width="20"></td>
   394    393   <td>A dollar-sign followed by an identifier name also holds a spot for a named
   395    394   parameter with the name $AAAA.  The identifier name in this case can include
   396    395   one or more occurrences of "::" and a suffix enclosed in "(...)" containing
   397    396   any text at all.  This syntax is the form of a variable name in the
   398         -<a href="http://www.tcl.tk/">Tcl programming language</a>.  The presence
          397  +<a href="http://www.tcl-lang.org/">Tcl programming language</a>.  The presence
   399    398   of this syntax results from the fact that SQLite is really a 
   400    399   <a href="tclsqlite.html">Tcl extension</a> that has escaped into the wild.</td>
   401    400   </tr>
   402    401   </table>
   403    402   </blockquote>
   404    403   
   405    404   <p>Parameters that are not assigned values using
................................................................................
   411    410   the <a href="limits.html#max_variable_number">SQLITE_MAX_VARIABLE_NUMBER</a> macro.  An individual <a href="c3ref/sqlite3.html">database connection</a>
   412    411   D can reduce its maximum parameter number below the compile-time maximum
   413    412   using the <a href="c3ref/limit.html">sqlite3_limit</a>(D, <a href="c3ref/c_limit_attached.html#sqlitelimitvariablenumber">SQLITE_LIMIT_VARIABLE_NUMBER</a>,...) interface.
   414    413   </p>
   415    414   
   416    415   <a name="like"></a>
   417    416   
   418         -<h3>The LIKE and GLOB operators</h3>
          417  +<h3>The LIKE, GLOB, REGEXP, and MATCH operators</h3>
   419    418   <p>The LIKE operator does a pattern matching comparison. The operand
   420    419   to the right of the LIKE operator contains the pattern and the left hand
   421    420   operand contains the string to match against the pattern.
   422    421   
   423    422   A percent symbol ("%") in the LIKE pattern matches any
   424    423   sequence of zero or more characters in the string.  An underscore
   425    424   ("_") in the LIKE pattern matches any single character in the
   426    425   string.  Any other character matches itself or its lower/upper case
   427         -equivalent (i.e. case-insensitive matching).  (A bug: SQLite only
          426  +equivalent (i.e. case-insensitive matching).
          427  +
          428  +<u>Important Note:</u> SQLite only
   428    429   understands upper/lower case for ASCII characters by default.  The
   429    430   LIKE operator is case sensitive by default for unicode characters that are
   430    431   beyond the ASCII range.  For example,
   431    432   the expression <b>'a'&nbsp;LIKE&nbsp;'A'</b>
   432         -is TRUE but <b>'&aelig;'&nbsp;LIKE&nbsp;'&AElig;'</b> is FALSE.)<p>
          433  +is TRUE but <b>'&aelig;'&nbsp;LIKE&nbsp;'&AElig;'</b> is FALSE.
          434  +The ICU extension to SQLite includes an enhanced version of the
          435  +LIKE operator that does case folding across all unicode characters.</p>
   433    436   
   434    437   <p>If the optional ESCAPE clause is present, then the expression
   435    438   following the ESCAPE keyword must evaluate to a string consisting of
   436    439   a single character. This character may be used in the LIKE pattern
   437    440   to include literal percent or underscore characters. The escape
   438    441   character followed by a percent symbol (%), underscore (_), or a second
   439    442   instance of the escape character itself matches a

Changes to Doc/Extra/Core/lang_indexedby.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_insert.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_keywords.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_naming.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_reindex.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_replace.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_savepoint.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_select.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_transaction.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_update.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_vacuum.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/lang_with.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/pragma.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"
................................................................................
   429    428       change only endures for the current session.  The cache size reverts
   430    429       to the default value when the database is closed and reopened.</p>
   431    430   
   432    431   
   433    432   <a name="pragma_cache_spill"></a>
   434    433   <hr>
   435    434       <p><b>PRAGMA cache_spill;
   436         -         <br>PRAGMA cache_spill=</b><i>boolean</i><b>;</b></p>
          435  +         <br>PRAGMA cache_spill=</b><i>boolean</i><b>;
          436  +         <br>PRAGMA </b><i>schema.</i><b>cache_spill=<i>N</i>;</b></p>
   437    437   
   438    438       <p>The cache_spill pragma enables or disables the ability of the pager
   439    439       to spill dirty cache pages to the database file in the middle of a 
   440    440       transaction.  Cache_spill is enabled by default and most applications
   441    441       should leave it that way as cache spilling is usually advantageous.
   442    442       However, a cache spill has the side-effect of acquiring an
   443    443       <a href="lockingv3.html#excl_lock">EXCLUSIVE lock</a> on the database file.  Hence, some applications that
   444    444       have large long-running transactions may want to disable cache spilling
   445    445       in order to prevent the application from acquiring an exclusive lock
   446    446       on the database until the moment that the transaction <a href="lang_transaction.html">COMMIT</a>s.
          447  +    <p>The "PRAGMA cache_spill=<i>N</i>" form of this pragma sets a minimum
          448  +    cache size threshold required for spilling to occur. The number of pages
          449  +    in cache must exceed both the cache_spill threshold and the maximum cache
          450  +    size set by the <a href="pragma.html#pragma_cache_size">PRAGMA cache_size</a> statement in order for spilling to
          451  +    occur.
          452  +    <p>The "PRAGMA cache_spill=<i>boolean</i>" form of this pragma applies
          453  +    across all databases attached to the database connection.  But the
          454  +    "PRAGMA cache_spill=<i>N</i>" form of this statement only applies to
          455  +    the "main" schema or whatever other schema is specified as part of the
          456  +    statement.
   447    457   <a name="pragma_case_sensitive_like"></a>
   448    458   <hr>
   449    459       <p><b>PRAGMA case_sensitive_like = </b><i>boolean</i><b>;</b></p>
   450    460       <p>The default behavior of the <a href="lang_expr.html#like">LIKE</a> operator is to ignore case
   451    461       for ASCII characters. Hence, by default <b>'a' LIKE 'A'</b> is
   452    462       true.  The case_sensitive_like pragma installs a new application-defined
   453    463       LIKE function that is either case sensitive or insensitive depending
................................................................................
   455    465       When case_sensitive_like is disabled, the default LIKE behavior is
   456    466       expressed.  When case_sensitive_like is enabled, case becomes
   457    467       significant.  So, for example,
   458    468       <b>'a' LIKE 'A'</b> is false but <b>'a' LIKE 'a'</b> is still true.</p>
   459    469   
   460    470       <p>This pragma uses <a href="c3ref/create_function.html">sqlite3_create_function()</a> to overload the
   461    471       LIKE and GLOB functions, which may override previous implementations
   462         -    of LIKE and GLOB registered by the application.</p>
          472  +    of LIKE and GLOB registered by the application.  This pragma
          473  +    only changes the behavior of the SQL <a href="lang_expr.html#like">LIKE</a> operator.  It does not
          474  +    change the behavior of the <a href="c3ref/strlike.html">sqlite3_strlike()</a> C-language interface,
          475  +    which is always case insensitive.</p>
   463    476   <a name="pragma_cell_size_check"></a>
   464    477   <hr>
   465    478       <p><b>PRAGMA cell_size_check
   466    479          <br>PRAGMA cell_size_check = </b><i>boolean</i><b>;</b></p>
   467    480       <p>The cell_size_check pragma enables or disables additional sanity
   468    481       checking on database b-tree pages as they are initially read from disk.
   469    482       With cell size checking enabled, database corruption is detected earlier

Changes to Doc/Extra/Core/syntax.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/alter-table-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/analyze-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/attach-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/begin-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/column-constraint.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/column-def.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/comment-syntax.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/commit-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/common-table-expression.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/compound-operator.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/compound-select-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/conflict-clause.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/create-index-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/create-table-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/create-trigger-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/create-view-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/create-virtual-table-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/cte-table-name.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/delete-stmt-limited.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/delete-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/detach-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/drop-index-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/drop-table-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/drop-trigger-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/drop-view-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/expr.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/factored-select-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/foreign-key-clause.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/indexed-column.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/insert-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/join-clause.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/join-constraint.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/join-operator.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/literal-value.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/numeric-literal.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/ordering-term.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/pragma-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/pragma-value.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/qualified-table-name.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/raise-function.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/recursive-cte.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/reindex-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/release-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/result-column.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/rollback-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/savepoint-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/select-core.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/select-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/signed-number.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/simple-select-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/sql-stmt-list.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/sql-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/table-constraint.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/table-or-subquery.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/type-name.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/update-stmt-limited.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/update-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/vacuum-stmt.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntax/with-clause.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="../about.html">About</a>
    90         -    <a href="../sitemap.html">Sitemap</a>
    91     90       <a href="../docs.html">Documentation</a>
    92     91       <a href="../download.html">Download</a>
    93     92       <a href="../copyright.html">License</a>
    94         -    <a href="../news.html">News</a>
    95     93       <a href="../support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Extra/Core/syntaxdiagrams.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"

Changes to Doc/Special/Core/vtab.html.

    83     83   <div><!-- IE hack to prevent disappearing logo--></div>
    84     84   <div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
    85     85   
    86     86   <table width=100% class="menubar"><tr>
    87     87     <td width=100%>
    88     88     <div class="toolbar">
    89     89       <a href="about.html">About</a>
    90         -    <a href="sitemap.html">Sitemap</a>
    91     90       <a href="docs.html">Documentation</a>
    92     91       <a href="download.html">Download</a>
    93     92       <a href="copyright.html">License</a>
    94         -    <a href="news.html">News</a>
    95     93       <a href="support.html">Support</a>
           94  +    <a href="http://www.hwaci.com/sw/sqlite/prosupport.html">Purchase</a>
    96     95     </div>
    97     96   <script>
    98     97     gMsg = "Search SQLite Docs..."
    99     98     function entersearch() {
   100     99       var q = document.getElementById("q");
   101    100       if( q.value == gMsg ) { q.value = "" }
   102    101       q.style.color = "black"
................................................................................
   251    250   
   252    251   <h4>1.1.2 Eponymous virtual tables</h4>
   253    252   
   254    253   <p>Some virtual tables exist automatically in the "main" schema of
   255    254   every database connection in which their
   256    255   module is registered, even without a <a href="lang_createvtab.html">CREATE VIRTUAL TABLE</a> statement.
   257    256   Such virtual tables are called "eponymous virtual tables".
   258         -To use an eponymous virtual table, simple use the 
          257  +To use an eponymous virtual table, simply use the 
   259    258   module name as if it were a table.
   260    259   Eponymous virtual tables exist in the "main" schema only, so they will
   261    260   not work if prefixed with a different schema name.
   262    261   
   263    262   <p>An example of an eponymous virtual table is the <a href="dbstat.html">dbstat virtual table</a>.
   264    263   To use the dbstat virtual table as an eponymous virtual table, 
   265    264   simply query against the "dbstat"
................................................................................
   746    745       int needToFreeIdxStr;      /* Free idxStr using sqlite3_free() if true */
   747    746       int orderByConsumed;       /* True if output is already ordered */
   748    747       double estimatedCost;      /* Estimated cost of using this index */
   749    748       <b>/* Fields below are only available in SQLite 3.8.2 and later */</b>
   750    749       sqlite3_int64 estimatedRows;    /* Estimated number of rows returned */
   751    750       <b>/* Fields below are only available in SQLite 3.9.0 and later */</b>
   752    751       int idxFlags;              /* Mask of SQLITE_INDEX_SCAN_* flags */
          752  +    <b>/* Fields below are only available in SQLite 3.10.0 and later */</b>
          753  +    sqlite3_uint64 colUsed;    /* Input: Mask of columns used by statement */
   753    754     };
   754    755   </pre></blockquote>
   755    756   
   756         -<p>Please note the warnings on the "estimatedRows" and "idxFlags" field.
   757         -These fields were added with SQLite versions 3.8.2 and 3.9.0, respectively. 
          757  +<p>Note the warnings on the "estimatedRows", "idxFlags", and colUsed fields.
          758  +These fields were added with SQLite versions 3.8.2, 3.9.0, and 3.10.0, respectively. 
   758    759   Any extension that reads or writes these fields must first check that the 
   759         -version of the SQLite library in use is greater than or equal to 3.8.2 or
   760         -3.9.0 - perhaps using a call to <a href="c3ref/libversion.html">sqlite3_version()</a>. The result of attempting 
          760  +version of the SQLite library in use is greater than or equal to appropriate
          761  +version - perhaps comparing the value returned from <a href="c3ref/libversion.html">sqlite3_libversion_number()</a>
          762  +against constants 3008002, 3009000, and/or 3010000. The result of attempting 
   761    763   to access these fields in an sqlite3_index_info structure created by an 
   762    764   older version of SQLite are undefined.
   763    765   
   764    766   <p>In addition, there are some defined constants:
   765    767   
   766    768   <blockquote><pre>
   767         -  #define SQLITE_INDEX_CONSTRAINT_EQ    2
   768         -  #define SQLITE_INDEX_CONSTRAINT_GT    4
   769         -  #define SQLITE_INDEX_CONSTRAINT_LE    8
   770         -  #define SQLITE_INDEX_CONSTRAINT_LT    16
   771         -  #define SQLITE_INDEX_CONSTRAINT_GE    32
   772         -  #define SQLITE_INDEX_CONSTRAINT_MATCH 64
   773         -  #define SQLITE_INDEX_SCAN_UNIQUE      1     /* Scan visits at most 1 row */
          769  +  #define SQLITE_INDEX_CONSTRAINT_EQ      2
          770  +  #define SQLITE_INDEX_CONSTRAINT_GT      4
          771  +  #define SQLITE_INDEX_CONSTRAINT_LE      8
          772  +  #define SQLITE_INDEX_CONSTRAINT_LT     16
          773  +  #define SQLITE_INDEX_CONSTRAINT_GE     32
          774  +  #define SQLITE_INDEX_CONSTRAINT_MATCH  64
          775  +  #define SQLITE_INDEX_CONSTRAINT_LIKE   65     /* 3.10.0 and later only */
          776  +  #define SQLITE_INDEX_CONSTRAINT_GLOB   66     /* 3.10.0 and later only */
          777  +  #define SQLITE_INDEX_CONSTRAINT_REGEXP 67     /* 3.10.0 and later only */
          778  +  #define SQLITE_INDEX_SCAN_UNIQUE        1     /* Scan visits at most 1 row */
   774    779   </pre></blockquote>
   775    780   
   776    781   <p>The SQLite core calls the xBestIndex method when it is compiling a query
   777    782   that involves a virtual table. In other words, SQLite calls this method 
   778    783   when it is running <a href="c3ref/prepare.html">sqlite3_prepare()</a> or the equivalent. 
   779    784   By calling this method, the 
   780    785   SQLite core is saying to the virtual table that it needs to access 
................................................................................
   877    882   information in place of the ORDER BY clause information, but this fact
   878    883   should not make any difference to the xBestIndex method.) 
   879    884   If all terms of the ORDER BY clause are columns in the virtual table, 
   880    885   then nOrderBy will be the number of terms in the ORDER BY clause 
   881    886   and the aOrderBy[] array will identify the column for each term 
   882    887   in the order by clause and whether or not that column is ASC or DESC.
   883    888   
          889  +<a name="colUsed"></a>
          890  +
          891  +<p>In SQLite version 3.10.0 and later, the colUsed field is available
          892  +to indicate which fields of the virtual table are actually used by the
          893  +statement being prepared.  If the lowest bit of colUsed is set, that
          894  +means that the first column is used.  The second lowest bit corresponds
          895  +to the second column.  And so forth.  If the most significant bit of
          896  +colUsed is set, that means that one or more columns other than the 
          897  +first 63 columns are used.  If column usage information is needed by the
          898  +<a href="vtab.html#xfilter">xFilter</a> method, then the required bits must be encoded into either
          899  +the idxNum or idxStr output fields.
          900  +
   884    901   <h4>2.3.2 Outputs</h4>
   885    902   
   886    903   <p>Given all of the information above, the job of the xBestIndex 
   887    904   method it to figure out the best way to search the virtual table.
   888    905   
   889    906   <p>The xBestIndex method fills the idxNum and idxStr fields with 
   890    907   information that communicates an indexing strategy to the <a href="vtab.html#xfilter">xFilter</a> 

Changes to System.Data.SQLite/ISQLiteNativeModule.cs.

   355    355           ///     int needToFreeIdxStr;      /* Free idxStr using sqlite3_free() if true */
   356    356           ///     int orderByConsumed;       /* True if output is already ordered */
   357    357           ///     double estimatedCost;      /* Estimated cost of using this index */
   358    358           ///     <![CDATA[<b>]]>/* Fields below are only available in SQLite 3.8.2 and later */<![CDATA[</b>]]>
   359    359           ///     sqlite3_int64 estimatedRows;    /* Estimated number of rows returned */
   360    360           ///     <![CDATA[<b>]]>/* Fields below are only available in SQLite 3.9.0 and later */<![CDATA[</b>]]>
   361    361           ///     int idxFlags;              /* Mask of SQLITE_INDEX_SCAN_* flags */
          362  +        ///     <![CDATA[<b>]]>/* Fields below are only available in SQLite 3.10.0 and later */<![CDATA[</b>]]>
          363  +        ///     sqlite3_uint64 colUsed;    /* Input: Mask of columns used by statement */
   362    364           ///   };
   363    365           /// </code></para>
   364    366           /// <para>
   365         -        /// Please note the warnings on the "estimatedRows" and "idxFlags" field.
   366         -        /// These fields were added with SQLite versions 3.8.2 and 3.9.0, respectively. 
          367  +        /// Note the warnings on the "estimatedRows", "idxFlags", and colUsed fields.
          368  +        /// These fields were added with SQLite versions 3.8.2, 3.9.0, and 3.10.0, respectively. 
   367    369           /// Any extension that reads or writes these fields must first check that the 
   368         -        /// version of the SQLite library in use is greater than or equal to 3.8.2 or
   369         -        /// 3.9.0 - perhaps using a call to sqlite3_version(). The result of attempting 
          370  +        /// version of the SQLite library in use is greater than or equal to appropriate
          371  +        /// version - perhaps comparing the value returned from sqlite3_libversion_number()
          372  +        /// against constants 3008002, 3009000, and/or 3010000. The result of attempting 
   370    373           /// to access these fields in an sqlite3_index_info structure created by an 
   371    374           /// older version of SQLite are undefined.
   372    375           /// </para>
   373    376           /// <para>
   374    377           /// In addition, there are some defined constants:
   375    378           /// </para>
   376    379           /// <para><code>
   377         -        ///   #define SQLITE_INDEX_CONSTRAINT_EQ    2
   378         -        ///   #define SQLITE_INDEX_CONSTRAINT_GT    4
   379         -        ///   #define SQLITE_INDEX_CONSTRAINT_LE    8
   380         -        ///   #define SQLITE_INDEX_CONSTRAINT_LT    16
   381         -        ///   #define SQLITE_INDEX_CONSTRAINT_GE    32
   382         -        ///   #define SQLITE_INDEX_CONSTRAINT_MATCH 64
   383         -        ///   #define SQLITE_INDEX_SCAN_UNIQUE      1     /* Scan visits at most 1 row */
          380  +        ///   #define SQLITE_INDEX_CONSTRAINT_EQ      2
          381  +        ///   #define SQLITE_INDEX_CONSTRAINT_GT      4
          382  +        ///   #define SQLITE_INDEX_CONSTRAINT_LE      8
          383  +        ///   #define SQLITE_INDEX_CONSTRAINT_LT     16
          384  +        ///   #define SQLITE_INDEX_CONSTRAINT_GE     32
          385  +        ///   #define SQLITE_INDEX_CONSTRAINT_MATCH  64
          386  +        ///   #define SQLITE_INDEX_CONSTRAINT_LIKE   65     /* 3.10.0 and later only */
          387  +        ///   #define SQLITE_INDEX_CONSTRAINT_GLOB   66     /* 3.10.0 and later only */
          388  +        ///   #define SQLITE_INDEX_CONSTRAINT_REGEXP 67     /* 3.10.0 and later only */
          389  +        ///   #define SQLITE_INDEX_SCAN_UNIQUE        1     /* Scan visits at most 1 row */
   384    390           /// </code></para>
   385    391           /// <para>
   386    392           /// The SQLite core calls the xBestIndex method when it is compiling a query
   387    393           /// that involves a virtual table. In other words, SQLite calls this method 
   388    394           /// when it is running sqlite3_prepare() or the equivalent. 
   389    395           /// By calling this method, the 
   390    396           /// SQLite core is saying to the virtual table that it needs to access 
................................................................................
   494    500           /// information in place of the ORDER BY clause information, but this fact
   495    501           /// should not make any difference to the xBestIndex method.) 
   496    502           /// If all terms of the ORDER BY clause are columns in the virtual table, 
   497    503           /// then nOrderBy will be the number of terms in the ORDER BY clause 
   498    504           /// and the aOrderBy[] array will identify the column for each term 
   499    505           /// in the order by clause and whether or not that column is ASC or DESC.
   500    506           /// </para>
          507  +        /// <para>
          508  +        /// In SQLite version 3.10.0 and later, the colUsed field is available
          509  +        /// to indicate which fields of the virtual table are actually used by the
          510  +        /// statement being prepared.  If the lowest bit of colUsed is set, that
          511  +        /// means that the first column is used.  The second lowest bit corresponds
          512  +        /// to the second column.  And so forth.  If the most significant bit of
          513  +        /// colUsed is set, that means that one or more columns other than the 
          514  +        /// first 63 columns are used.  If column usage information is needed by the
          515  +        /// xFilter method, then the required bits must be encoded into either
          516  +        /// the idxNum or idxStr output fields.
          517  +        /// </para>
   501    518           /// <para>
   502    519           /// Given all of the information above, the job of the xBestIndex 
   503    520           /// method it to figure out the best way to search the virtual table.
   504    521           /// </para>
   505    522           /// <para>
   506    523           /// The xBestIndex method fills the idxNum and idxStr fields with 
   507    524           /// information that communicates an indexing strategy to the xFilter