Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Format keyword lists in lang.html using a TCL proc. (CVS 961) |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
ca75f1ca12cd88dce688e272d73c3c22 |
| User & Date: | drh 2003-05-07 13:37:31.000 |
Context
|
2003-05-10
| ||
| 02:54 | Fixed metacharacter coloring with LP, RP, PLUS. Added more links. (CVS 962) (check-in: 2bbb080495 user: jplyon tags: trunk) | |
|
2003-05-07
| ||
| 13:37 | Format keyword lists in lang.html using a TCL proc. (CVS 961) (check-in: ca75f1ca12 user: drh tags: trunk) | |
| 04:04 | - Added entries for PRAGMAs database_list, temp_store and default_temp_store. - Fixed missing end tags. (CVS 960) (check-in: 55ae7b35ee user: jplyon tags: trunk) | |
Changes
Changes to www/lang.tcl.
1 2 3 | # # Run this Tcl script to generate the sqlite.html file. # | | | 1 2 3 4 5 6 7 8 9 10 11 |
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: lang.tcl,v 1.56 2003/05/07 13:37:31 drh Exp $}
puts {<html>
<head>
<title>Query Language Understood By SQLite</title>
</head>
<body bgcolor=white>
<h1 align=center>
|
| ︙ | ︙ | |||
1587 1588 1589 1590 1591 1592 1593 | by MS Access and SQL Server.) </table> <h2>Fallback Keywords</h2> <p>These keywords can be used as identifiers for SQLite objects without delimiters.</p> | | | > > > > > > > > > > > > > > > > > | > > > > > > > > > > > > > > | > > > > > > > > > | > > > > > > | > > > > > > | > > > > > > | > > > | | > > > > > > > > > > > > | > > > > > > > > > > > > > > | > > > > > > > | > > > > > > > > > > > | > | > > > > > | > > < < < < > > > > > > > > | 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616 1617 1618 1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 |
by MS Access and SQL Server.)
</table>
<h2>Fallback Keywords</h2>
<p>These keywords can be used as identifiers for SQLite objects without
delimiters.</p>
}
proc keyword_list {x} {
puts "<p>"
foreach k $x {
if {[string index $k 0]=="*"} {
set nonstandard 1
set k [string range $k 1 end]
} else {
set nonstandard 0
}
if {$nonstandard} {
puts "<i>$k</i> "
} else {
puts "$k "
}
}
puts "</p>\n"
}
keyword_list {
*ABORT
AFTER
ASC
*ATTACH
BEFORE
BEGIN
DEFERRED
CASCADE
*CLUSTER
*CONFLICT
*COPY
CROSS
*DATABASE
*DELIMITERS
DESC
*DETACH
EACH
END
*EXPLAIN
*FAIL
FOR
FULL
IGNORE
IMMEDIATE
INITIALLY
INNER
*INSTEAD
KEY
LEFT
MATCH
NATURAL
OF
*OFFSET
OUTER
*PRAGMA
*RAISE
*REPLACE
RESTRICT
RIGHT
*ROW
*STATEMENT
*TEMP
TEMPORARY
TRIGGER
*VACUUM
VIEW
}
puts {
<h2>Normal keywords</h2>
<p>These keywords can be used as identifiers for SQLite objects, but
must be enclosed in brackets or quotes for SQLite to recognize them as
an identifier.</p>
}
keyword_list {
ALL
AND
AS
BETWEEN
BY
CASE
CHECK
COLLATE
COMMIT
CONSTRAINT
CREATE
DEFAULT
DEFERRABLE
DELETE
DISTINCT
DROP
ELSE
EXCEPT
FOREIGN
FROM
*GLOB
GROUP
HAVING
IN
*INDEX
INSERT
INTERSECT
INTO
IS
*ISNULL
JOIN
LIKE
LIMIT
NOT
*NOTNULL
NULL
ON
OR
ORDER
PRIMARY
REFERENCES
ROLLBACK
SELECT
SET
TABLE
THEN
TRANSACTION
UNION
UNIQUE
UPDATE
USING
VALUES
WHEN
WHERE
}
puts {
<h2>Special words</h2>
<p>The following are not keywords in SQLite, but are used as names of
system objects. They can be used as an identifier for a different
type of object.</p>
}
keyword_list {
*_ROWID_
*MAIN
OID
*ROWID
*SQLITE_MASTER
*SQLITE_TEMP_MASTER
}
puts {
<p><hr /></p>
<p><a href="index.html"><img src="/goback.jpg" border=0 />
Back to the SQLite Home Page</a>
</p>
</body></html>}
|