Documentation Source Text

Check-in [17a3eefb66]
Login

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

Overview
Comment:Changed lang.html to use hd_resolve for linkage rather than crafted links.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 17a3eefb6632f155561fcfd25a1b95cc281b9222
User & Date: shaneh 2009-05-14 18:12:52
Context
2009-05-14
18:13
Generate doc_pagelink_crossref.html which shows which pages link to which. Useful for finding orphans. check-in: bd0b540d7b user: shaneh tags: trunk
18:12
Changed lang.html to use hd_resolve for linkage rather than crafted links. check-in: 17a3eefb66 user: shaneh tags: trunk
2009-05-11
17:41
Document the goofy behavior of PRIMARY KEY(x DESC) still allowing x to be a rowid if it is of type INTEGER. check-in: b354d15151 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/lang.in.

22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
..
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70



71
72
73
74
75
76
77
78
79
80
81
82
83
...
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116



117
118
119
120
121
122
123

<p>The following syntax documentation topics are available:</p>

<table width="100%" cellpadding="5" border="0">
<tr><td valign="top"><ul>

<tcl>
set i 0
set lang_section_list {
  {{CREATE TABLE} createtable}
  {{CREATE VIRTUAL TABLE} createvtab}
  {{CREATE INDEX} createindex}
  {VACUUM vacuum}
  {{DROP TABLE} droptable}
  {{DROP INDEX} dropindex}
  {INSERT insert}
................................................................................
  {DELETE delete}
  {UPDATE update}
  {SELECT select}
  {comment comment}
  {EXPLAIN explain}
  {expression expr}
  {{BEGIN TRANSACTION} transaction}
  {{COMMIT TRANSACTION} transaction}
  {{END TRANSACTION} transaction}
  {{ROLLBACK TRANSACTION} transaction}
  {SAVEPOINT savepoint}
  {{RELEASE SAVEPOINT} savepoint}
  {PRAGMA pragma.html}
  {{ON CONFLICT clause} conflict}
  {{CREATE VIEW} createview}
  {{DROP VIEW} dropview}
  {{CREATE TRIGGER} createtrigger}
  {{DROP TRIGGER} droptrigger}
  {{ATTACH DATABASE} attach}
  {{DETACH DATABASE} detach}
  {REINDEX reindex}
  {{ALTER TABLE} altertable}
  {{ANALYZE} analyze}
  {{INDEXED BY} indexedby}
  {{aggregate functions} aggfunc}
  {{core functions} corefunc}
  {{date and time functions} datefunc}
  {keywords keywords}
}
set lang_section_break [expr {([llength $lang_section_list]+2)/3}]
foreach {section} [lsort -index 0 -dictionary $lang_section_list] {
  foreach {s_title s_tag} $section {}



  if {$s_tag=="pragma.html"} {
    set url $s_tag
  } else {
    set url lang_$s_tag.html
  }
  hd_puts "<li><a href=\"$url\">$s_title</a></li>"
  incr i
  if {$i==$lang_section_break || $i==2*$lang_section_break} {
    hd_puts "</ul></td><td valign=\"top\"><ul>"
  }
}
</tcl>
</ul></td></tr></table>
................................................................................
  return "<i><font color=\"#ff3434\">$name</font></i>"
}
proc Keyword {name} {
  return "<font color=\"#2c2cf0\">$name</font>"
}
proc Example {text} {
  hd_puts "<blockquote><pre>$text</pre></blockquote>"
}

proc Section {name label keywords} {
  global DOC
  hd_close_main
  hd_open_main lang_$label.html
  hd_header "SQLite Query Language: $name" $DOC/pages/lang.in
  eval hd_keywords $keywords



  hd_puts {<a href="lang.html">
           <h2 align="center">SQL As Understood By SQLite</h2></a>}
  hd_puts "<h1>$name</h1>"
}

###############################################################################
Section {ALTER TABLE} altertable {{ALTER TABLE} {ALTER}}







|
|







 







|
|
|

|












|
|
|
|
|
|
|
|
>
>
>





|







 







|

|





>
>
>







22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
..
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
...
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129

<p>The following syntax documentation topics are available:</p>

<table width="100%" cellpadding="5" border="0">
<tr><td valign="top"><ul>

<tcl>
  set i 0
  set lang_section_list {
  {{CREATE TABLE} createtable}
  {{CREATE VIRTUAL TABLE} createvtab}
  {{CREATE INDEX} createindex}
  {VACUUM vacuum}
  {{DROP TABLE} droptable}
  {{DROP INDEX} dropindex}
  {INSERT insert}
................................................................................
  {DELETE delete}
  {UPDATE update}
  {SELECT select}
  {comment comment}
  {EXPLAIN explain}
  {expression expr}
  {{BEGIN TRANSACTION} transaction}
  {{COMMIT TRANSACTION} transaction COMMIT}
  {{END TRANSACTION} transaction COMMIT}
  {{ROLLBACK TRANSACTION} transaction ROLLBACK}
  {SAVEPOINT savepoint}
  {{RELEASE SAVEPOINT} savepoint SAVEPOINT}
  {PRAGMA pragma.html}
  {{ON CONFLICT clause} conflict}
  {{CREATE VIEW} createview}
  {{DROP VIEW} dropview}
  {{CREATE TRIGGER} createtrigger}
  {{DROP TRIGGER} droptrigger}
  {{ATTACH DATABASE} attach}
  {{DETACH DATABASE} detach}
  {REINDEX reindex}
  {{ALTER TABLE} altertable}
  {{ANALYZE} analyze}
  {{INDEXED BY} indexedby}
  {{aggregate functions} aggfunc aggfunc}
  {{core functions} corefunc corefunc}
  {{date and time functions} datefunc datefunc}
  {keywords keywords {SQL keywords}}
  }
  set lang_section_break [expr {([llength $lang_section_list]+2)/3}]
  foreach {section} [lsort -index 0 -dictionary $lang_section_list] {
  foreach {s_title s_tag s_kw} $section {}
  if {$s_kw == ""} {
    set s_kw $s_title
  }
  if {$s_tag=="pragma.html"} {
    set url $s_tag
  } else {
    set url lang_$s_tag.html
  }
  hd_resolve "<li>\[$s_kw|$s_title\]</li>"
  incr i
  if {$i==$lang_section_break || $i==2*$lang_section_break} {
    hd_puts "</ul></td><td valign=\"top\"><ul>"
  }
}
</tcl>
</ul></td></tr></table>
................................................................................
  return "<i><font color=\"#ff3434\">$name</font></i>"
}
proc Keyword {name} {
  return "<font color=\"#2c2cf0\">$name</font>"
}
proc Example {text} {
  hd_puts "<blockquote><pre>$text</pre></blockquote>"
  }

  proc Section {name label keywords} {
  global DOC
  hd_close_main
  hd_open_main lang_$label.html
  hd_header "SQLite Query Language: $name" $DOC/pages/lang.in
  eval hd_keywords $keywords
  if {[lsearch $keywords $name] == -1} {
    eval hd_keywords { $name }
  }
  hd_puts {<a href="lang.html">
           <h2 align="center">SQL As Understood By SQLite</h2></a>}
  hd_puts "<h1>$name</h1>"
}

###############################################################################
Section {ALTER TABLE} altertable {{ALTER TABLE} {ALTER}}