Documentation Source Text

<title>Alphabetical List Of SQLite Documents</title>
<h2 align=center>Alphabetical List Of Documents</h1>
<tcl>hd_keywords {*doclist}</tcl>

<var class="rightsidebar border2px desktoponly">
See Also:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[permuted index | Permuted Title Index]
<li>[keyword index | Website Keyword Index]
</ul>
</var>

<ol>
<tcl>
hd_keywords {alphabetical listing of documents}
db eval {
  SELECT filename, pagetitle
    FROM page
   WHERE pagetitle IS NOT NULL AND pagetitle!='No Title'
   ORDER BY pagetitle COLLATE nocase
} {
  hd_puts "<li><a href=\"$filename\">$pagetitle</a></li>\n"

<title>SQLite Documentation</title>

<h2 align="center">Documents By Category</h1>
<style>
.showhide {
  margin-left: 0;
  padding-left: 0;
  list-style-type: none;
}
.showhide > li {
  clear: both;
  padding-left: 1em;
  text-indent: -1em;
}
.showhide > li li {
  padding-left: 0;
  text-indent: 0;
}
.showhide ul {display: none;}
.showhide > li > a {
  text-decoration: none;
  color: black;
  cursor: pointer;
}
.sh_mark {
  float: left;
  width: 1em;
}
</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 {}

  end_heading
  set ::prevHead $text
}
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>

<title>Website Keyword Index</title>
<h2 align=center>Keyword Index</h1>

<var class="rightsidebar border2px desktoponly">
Other Documentation Indexes:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[doclist | Alphabetical List Of Documents]
<li>[permuted index | Permuted Document Title Index]
</ul>
</var>

<ul class='lessindent'>
<tcl>
hd_keywords {keyword index}
db eval {
  UPDATE keyword SET indexKw=0
   WHERE kw GLOB '*s' AND indexKw
     AND EXISTS(SELECT 1 FROM keyword AS x
                 WHERE x.kw = substr(keyword.kw,1,length(keyword.kw)-1));

<title>SQLite Site Map</title>


<tcl>hd_keywords {permuted index}</tcl>
<h2>Permuted Index</h2>

<var class="rightsidebar border2px desktoponly">
Other Documentation Indices:
<ul>
<li>[categorical listing of SQLite documents | Categorical Document List]
<li>[books about SQLite | Books About SQLite]
<li>[doclist | Alphabetical List Of Documents]
<li>[keyword index | Website Keyword Index]
</ul>
</var>

<ul class='lessindent'>
<tcl>
db eval {
  DROP TABLE IF EXISTS px;
  CREATE TEMP TABLE px(title COLLATE nocase,link);
}
db eval {SELECT pagetitle, filename FROM page WHERE pagetitle!='No Title'} {
  set nword [llength $pagetitle]

    set perm "$lastpart — $firstpart"
    db eval {INSERT INTO px VALUES($perm,$filename)}
  }
}
db eval {
  SELECT title, link FROM px ORDER BY title
} {
  hd_putsnl "<li><a href=\"$link\">$title</a></li>"
} 
</tcl>
</ul>

  .toct {margin-left:0;}
  .fancy-toc1 {padding-left:4ex;text-indent:-2ex;}
  .fancy-toc2 {padding-left:8ex;text-indent:-4ex;}
  .fancy-toc3 {padding-left:12ex;text-indent:-6ex;}
  .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%;
}

/* Container for an image */
.imgcontainer img {
  max-height: 100%;
  max-width: 100%;
}


.doccat a {
  color: #044a64 ;
  text-decoration: none;
}
.doccat h {
  font-weight: bold;