Documentation Source Text

Check-in [84b8acdf6c]
Login

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

Overview
Comment:Improve the cross-platform display of show/hide lists.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | mobile-friendly
Files: files | file ages | folders
SHA1: 84b8acdf6c682618fc9eb77ba598c4b8cfef36ac
User & Date: drh 2016-09-02 00:30:06
Context
2016-09-02
01:04
Improved rendering of CodeBlock in fancy-format. check-in: a5ef7d9aff user: drh tags: mobile-friendly
00:30
Improve the cross-platform display of show/hide lists. check-in: 84b8acdf6c user: drh tags: mobile-friendly
2016-09-01
21:53
Refinements to the prosupport.html page. check-in: cc74d20ccd user: drh tags: mobile-friendly
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/capi3ref.in.

299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
  hd_putsnl "var w = Math.max(document.documentElement.clientWidth, \
             window.innerWidth || 0);"
  hd_putsnl "var nCol = Math.floor(w/$w);"
  hd_putsnl "if(nCol<=0) nCol=1;"
  hd_putsnl "var nRow = Math.ceil(($vx.length+1)/nCol);"
  if {$title!=""} {
    hd_putsnl "var h=\"<tr><td colspan=\"+nCol;"
    hd_putsnl "h += \">$title</td></tr><tr><td><ul>\""
  } else {
    hd_putsnl "var h=\"<tr><td><ul>\""
  }
  hd_putsnl "var ea"
  hd_putsnl "for(var i=0; i<$vx.length; i++){"
  hd_putsnl "  if( (++j)>nRow ){"
  hd_putsnl "    h += \"</ul></td>\\n<td><ul>\\n\";"
  hd_putsnl "    j = 1;"
  hd_putsnl "  }"
  hd_putsnl "  if($vx\[i\].u==\"\" || $vx\[i\].s==2){"
  hd_putsnl "    h += \"<li>\""
  hd_putsnl "    ea = \"\""
  hd_putsnl "  }else{"
  hd_putsnl "    h += \"<li><a href='\";"







|

|




|







299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
  hd_putsnl "var w = Math.max(document.documentElement.clientWidth, \
             window.innerWidth || 0);"
  hd_putsnl "var nCol = Math.floor(w/$w);"
  hd_putsnl "if(nCol<=0) nCol=1;"
  hd_putsnl "var nRow = Math.ceil(($vx.length+1)/nCol);"
  if {$title!=""} {
    hd_putsnl "var h=\"<tr><td colspan=\"+nCol;"
    hd_putsnl "h += \">$title</td></tr><tr><td><ul class='multicol_list'>\""
  } else {
    hd_putsnl "var h=\"<tr><td><ul class='multicol_list'>\""
  }
  hd_putsnl "var ea"
  hd_putsnl "for(var i=0; i<$vx.length; i++){"
  hd_putsnl "  if( (++j)>nRow ){"
  hd_putsnl "    h += \"</ul></td>\\n<td><ul class='multicol_list'>\\n\";"
  hd_putsnl "    j = 1;"
  hd_putsnl "  }"
  hd_putsnl "  if($vx\[i\].u==\"\" || $vx\[i\].s==2){"
  hd_putsnl "    h += \"<li>\""
  hd_putsnl "    ea = \"\""
  hd_putsnl "  }else{"
  hd_putsnl "    h += \"<li><a href='\";"

Changes to pages/docs.in.

29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
..
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
</style>
<script>
function showhide(n){
  var ul = document.getElementById("sh_sub_"+n)
  var mk = document.getElementById("sh_mark_"+n)
  if( ul.style.display!="block" ){
    ul.style.display = "block";
    mk.innerHTML = "&#x25be;";
  } else {
    ul.style.display = "none";
    mk.innerHTML = "&#x25b8;";
  }
}
</script>
<ul class="showhide">
<tcl>
hd_keywords {categorical listing of SQLite documents} {documents by category}
set prevHead {}
................................................................................
}
proc end_heading {} {
  global lDoc cnt prevHead
  if {$prevHead==""} return
  incr cnt
  hd_puts "<li><a onclick='showhide($cnt)'>"
  hd_puts "<span class='sh_mark' id='sh_mark_$cnt'>"
  hd_puts "&#x25b8;</span> $prevHead</a>\n"
  hd_putsnl "<ul id='sh_sub_$cnt'>"
  foreach {name url} $lDoc {
    hd_putsnl "<li><a href='$url'>$name</a>"
  }
  hd_putsnl </ul>
  set lDoc {}
}
source [file join $::DOC pages docsdata.tcl]
end_heading
</tcl>
</ul>







|


|







 







|











29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
..
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
</style>
<script>
function showhide(n){
  var ul = document.getElementById("sh_sub_"+n)
  var mk = document.getElementById("sh_mark_"+n)
  if( ul.style.display!="block" ){
    ul.style.display = "block";
    mk.innerHTML = "&#x25bc;";
  } else {
    ul.style.display = "none";
    mk.innerHTML = "&#x25ba;";
  }
}
</script>
<ul class="showhide">
<tcl>
hd_keywords {categorical listing of SQLite documents} {documents by category}
set prevHead {}
................................................................................
}
proc end_heading {} {
  global lDoc cnt prevHead
  if {$prevHead==""} return
  incr cnt
  hd_puts "<li><a onclick='showhide($cnt)'>"
  hd_puts "<span class='sh_mark' id='sh_mark_$cnt'>"
  hd_puts "&#x25ba;</span> $prevHead</a>\n"
  hd_putsnl "<ul id='sh_sub_$cnt'>"
  foreach {name url} $lDoc {
    hd_putsnl "<li><a href='$url'>$name</a>"
  }
  hd_putsnl </ul>
  set lDoc {}
}
source [file join $::DOC pages docsdata.tcl]
end_heading
</tcl>
</ul>

Changes to pages/fancyformat.tcl.

213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
...
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
  set x {
    <script>
      function toggle_toc(){
        var sub = document.getElementById("toc_sub")
        var mk = document.getElementById("toc_mk")
        if( sub.style.display!="block" ){
          sub.style.display = "block";
          mk.innerHTML = "&#x25be;";
        } else {
          sub.style.display = "none";
          mk.innerHTML = "&#x25b8;";
        }
      }
    </script>
  }
  regsub -all {\n\s+} $x "\n" x
  return $x;
}
................................................................................
  set toc [subst {
    <div class=fancy>

    <div class=nosearch>
      <div class="fancy_title">$::Addtoc(title)</div>
      <div class="fancy_toc">
         <a onclick="toggle_toc()">
         <span class="fancy_toc_mark" id="toc_mk">&#x25b8;</span>
         Table Of Contents</a>
         <div id="toc_sub">$::Addtoc(toc)</div>
      </div>
    </div>
    [javascript_toc_toggle]
  }]
  set fancy [subst {







|


|







 







|







213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
...
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
  set x {
    <script>
      function toggle_toc(){
        var sub = document.getElementById("toc_sub")
        var mk = document.getElementById("toc_mk")
        if( sub.style.display!="block" ){
          sub.style.display = "block";
          mk.innerHTML = "&#x25bc;";
        } else {
          sub.style.display = "none";
          mk.innerHTML = "&#x25ba;";
        }
      }
    </script>
  }
  regsub -all {\n\s+} $x "\n" x
  return $x;
}
................................................................................
  set toc [subst {
    <div class=fancy>

    <div class=nosearch>
      <div class="fancy_title">$::Addtoc(title)</div>
      <div class="fancy_toc">
         <a onclick="toggle_toc()">
         <span class="fancy_toc_mark" id="toc_mk">&#x25ba;</span>
         Table Of Contents</a>
         <div id="toc_sub">$::Addtoc(toc)</div>
      </div>
    </div>
    [javascript_toc_toggle]
  }]
  set fancy [subst {

Changes to pages/rescode.in.

734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749

750
751
752
753
754

755
756
757
758
759
760
761
762
763
764
765
766

767
768
769
770
771

772
773
774
775
776

777
778
779
780
781
782
783
}

</tcl>
<h1>Primary Result Code List</h1>
<p>The $nPrimCode result codes are 
   [result code definitions|defined in sqlite3.h] and are listed in
   alphabetical order below: 
<table border=0 width="100%" cellpadding=10>
  <tr><td valign="top" align="left"><ul>
<tcl>
set nrow [expr {($nPrimCode+2)/3}]
set i 0
foreach name [lsort [array names prim_rc]] {
  if {$i==$nrow} {
    hd_puts "</ul></td><td valign=\"top\" align=\"left\"><ul>\n"
    set i 0

  }
  incr i
  hd_resolve "<li> \[$name\] ($prim_rc($name))\n"
}
hd_puts "</td></td></table>\n\n"


hd_fragment extrc {extended result code} {extended result codes} \
                  {extended error code} {extended error codes}
</tcl>
<h1>Extended Result Code List</h1>
<p>The $nExtCode extended result codes
  are [extended result code definitions|defined in sqlite3.h] and are
  listed in alphabetical order below:
  <table border=0 width="100%" cellpadding=10>
  <tr><td valign="top" align="left"><ul>
<tcl>
set nrow [expr {($nExtCode+1)/2}]

set i 0
foreach name [lsort [array names ext_rc]] {
  if {$i==$nrow} {
    hd_puts "</ul></td><td valign=\"top\" align=\"left\"><ul>\n"
    set i 0

  }
  incr i
  hd_resolve "<li> \[$name\] ($ext_rc($name))\n"
}
hd_puts "</td></td></table>\n\n"


</tcl>
<h1>Result Code Meanings</h1>
<p>
The meanings for all $nResCode result code values are shown below,
in numeric order.








<
<

<
|

<
<
<
>
|
<
<
<
<
>








<
<

<
>
|

<
<
<
>
|
<
<
<
<
>







734
735
736
737
738
739
740


741

742
743



744
745




746
747
748
749
750
751
752
753
754


755

756
757
758



759
760




761
762
763
764
765
766
767
768
}

</tcl>
<h1>Primary Result Code List</h1>
<p>The $nPrimCode result codes are 
   [result code definitions|defined in sqlite3.h] and are listed in
   alphabetical order below: 


<tcl>

set lx {}
foreach name [lsort [array names prim_rc]] {



  lappend lx [list $name "$name&nbsp;($prim_rc($name))" 0]
}




output_list {} 320 $lx

hd_fragment extrc {extended result code} {extended result codes} \
                  {extended error code} {extended error codes}
</tcl>
<h1>Extended Result Code List</h1>
<p>The $nExtCode extended result codes
  are [extended result code definitions|defined in sqlite3.h] and are
  listed in alphabetical order below:


<tcl>


set lx {}
foreach name [lsort [array names ext_rc]] {



  lappend lx [list $name "$name&nbsp;($ext_rc($name))" 0]
}




output_list {} 450 $lx

</tcl>
<h1>Result Code Meanings</h1>
<p>
The meanings for all $nResCode result code values are shown below,
in numeric order.

Changes to pages/support.in.

25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
<a href="http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-announce">
<nobr>sqlite-announce</nobr></a>
&mdash; Announcements of new SQLite releases.</td>
<a class="button" href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce">Sign-up</a>
</li>
</ul>

<tcl>hd_fragment prosupport {professional support}</tcl>
<h2>Paid Professional Support</h2>

<p>
If you would like professional support for SQLite
or if you want custom modifications performed by the
original author of SQLite, these services are available for a modest fee.
For additional information visit
[http://www.hwaci.com/sw/sqlite/prosupport.html] or contact:</p>

<table border="0" cellpadding="15">
<tr><td valign="top">
D. Richard Hipp <br />
Hwaci - Applied Software Research <br />
704.948.4565 <br />
<a href="mailto:drh@hwaci.com">drh@hwaci.com</a>
</td><td valign="top">
<a class="button" href="http://www.hwaci.com/sw/sqlite/prosupport.html">More Info</a>
</td>
</table>

<h2>Proprietary SQLite Extensions</h2>

<p>The core SQLite library found on this website is in the
<a href="copyright.html">public domain</a>.  But there also exist







|



|


|
<








|







25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
<a href="http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-announce">
<nobr>sqlite-announce</nobr></a>
&mdash; Announcements of new SQLite releases.</td>
<a class="button" href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce">Sign-up</a>
</li>
</ul>

<tcl>hd_fragment prosupport</tcl>
<h2>Paid Professional Support</h2>

<p>
If you would like [professional support] for SQLite
or if you want custom modifications performed by the
original author of SQLite, these services are available for a modest fee.
For additional information visit contact:</p>


<table border="0" cellpadding="15">
<tr><td valign="top">
D. Richard Hipp <br />
Hwaci - Applied Software Research <br />
704.948.4565 <br />
<a href="mailto:drh@hwaci.com">drh@hwaci.com</a>
</td><td valign="top">
<a class="button" href="prosupport.html">More Info</a>
</td>
</table>

<h2>Proprietary SQLite Extensions</h2>

<p>The core SQLite library found on this website is in the
<a href="copyright.html">public domain</a>.  But there also exist

Changes to rawpages/sqlite.css.

197
198
199
200
201
202
203



204
205
206
207
208
209
210
  .fancy-toc4 {padding-left:16ex;text-indent:-8ex;}
  .fancy-toc5 {padding-left:20ex;text-indent:-10ex;}
  .fancy-toc6 {padding-left:24ex;text-indent:-12ex;}
  .lessindent {padding-left: 1em; margin-left: 0;}
}
/* End of "fancyformat" specific rules. */




.yyterm {
  background: #fff;
  border: 1px solid #000;
  border-radius: 11px;
  padding-left: 4px;
  padding-right: 4px;
  line-height: 125%;







>
>
>







197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
  .fancy-toc4 {padding-left:16ex;text-indent:-8ex;}
  .fancy-toc5 {padding-left:20ex;text-indent:-10ex;}
  .fancy-toc6 {padding-left:24ex;text-indent:-12ex;}
  .lessindent {padding-left: 1em; margin-left: 0;}
}
/* End of "fancyformat" specific rules. */

/* <ul> elements used for multi-column lists */
.multicol_list {padding-left:1em;margin-left:0;}

.yyterm {
  background: #fff;
  border: 1px solid #000;
  border-radius: 11px;
  padding-left: 4px;
  padding-right: 4px;
  line-height: 125%;