1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
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
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
|
<!DOCTYPE html>
<html lang="en" dir="ltr" class="no-js">
<head>
<meta charset="utf-8" />
<title>de:dbopen [BASIC 256 - Language Documentation]</title>
<link rel="stylesheet" type="text/css" href="lib/exe/cssc171c1dfe8519125bb40a349172b001a.css"/>
</head>
<body>
<div id="dokuwiki__site"><div id="dokuwiki__top" class="site dokuwiki mode_show tpl_dokuwiki ">
<div id="dokuwiki__header"><div class="pad group">
<div class="headings group">
<h1><a href="start.html" accesskey="h" title="[H]"><img src="lib/tpl/dokuwiki/images/logo.png" width="64" height="64" alt="" /> <span>BASIC 256 - Language Documentation</span></a></h1>
</div>
</div>
<div class="breadcrumbs">
<div class="youarehere"><span class="bchead">You are here: </span><span class="home"><bdi><a href="start.html" class="wikilink1" title="start">start</a></bdi></span> » <bdi><a href="de_start.html" class="wikilink1" title="de:start">de</a></bdi> » <bdi><span class="curid"><a href="de_dbopen.html" class="wikilink1" title="de:dbopen">dbopen</a></span></bdi></div>
</div>
<hr class="a11y" />
</div></div>
<div class="wrapper group">
<div id="dokuwiki__content"><div class="pad group">
<div class="pageId"><span>de:dbopen</span></div>
<div class="page group">
<div id="dw__toc">
<h3 class="toggle">Table of Contents</h3>
<div>
<ul class="toc">
<li class="level2"><div class="li"><a href="de_dbopen.html#dbopen">DBOpen</a></div>
<ul class="toc">
<li class="level3"><div class="li"><a href="de_dbopen.html#format">Format</a></div></li>
<li class="level3"><div class="li"><a href="de_dbopen.html#description">Description</a></div></li>
<li class="level3"><div class="li"><a href="de_dbopen.html#example">Example</a></div></li>
<li class="level3"><div class="li"><a href="de_dbopen.html#see_also">See Also</a></div></li>
<li class="level3"><div class="li"><a href="de_dbopen.html#external_links">External Links</a></div></li>
<li class="level3"><div class="li"><a href="de_dbopen.html#new_to_version">New To Version</a></div></li>
</ul></li>
</ul>
</div>
</div>
<h2 class="sectionedit1" id="dbopen">DBOpen</h2>
<div class="level2">
</div>
<h3 class="sectionedit2" id="format">Format</h3>
<div class="level3">
<p>
<strong>dbopen</strong> <em>SQLiteFile</em><br/>
<strong>dbopen</strong> ( <em>SQLiteFile</em> )
</p>
</div>
<h3 class="sectionedit3" id="description">Description</h3>
<div class="level3">
<p>
Open an SQLite database file. If the file does not exist then create it.
</p>
</div>
<h3 class="sectionedit4" id="example">Example</h3>
<div class="level3">
<pre class="code">#database foo - create a database, populate a table, open a recordset and read data from table.
# create a new database file or open it
dbopen "dbtest.sqlite3"
# delete old foo table - trap error if new database
onerror errortrap
dbexecute "drop table foo;"
offerror
# create and populate
dbexecute "create table foo (id integer, words text, value decimal);"
dbexecute "insert into foo values (1,'one',3.14);"
dbexecute "insert into foo values (2,'two',6.28);"
dbexecute "insert into foo values (3,'three',9.43);"
# open a recordset and loop through the rows of data
dbopenset "select * from foo order by words;"
while dbrow()
print dbint(0) + dbstring(1) + dbfloat(2)
end while
dbcloseset
# wrap everything up
dbclose
end
errortrap:
# accept error - display nothing - return to next statement
return</pre>
<p>
will display
</p>
<pre class="code">1one3.14
3three9.43
2two6.28</pre>
</div>
<h3 class="sectionedit5" id="see_also">See Also</h3>
<div class="level3">
<p>
<a href="de_dbclose.html" class="wikilink1" title="de:dbclose">DBClose</a>, <a href="de_dbcloseset.html" class="wikilink1" title="de:dbcloseset">DBCloseSet</a>, <a href="de_dbexecute.html" class="wikilink1" title="de:dbexecute">DBExecute</a>, <a href="de_dbfloat.html" class="wikilink1" title="de:dbfloat">DBFloat</a>, <a href="de_dbint.html" class="wikilink1" title="de:dbint">DBInt</a>, <a href="de_dbopenset.html" class="wikilink1" title="de:dbopenset">DBOpenSet</a>, <a href="de_dbrow.html" class="wikilink1" title="de:dbrow">DBRow</a>, <a href="de_dbstring.html" class="wikilink1" title="de:dbstring">DBString</a>
</p>
</div>
<h3 class="sectionedit6" id="external_links">External Links</h3>
<div class="level3">
<p>
More information about databases in general and SQLite specifically can be found at <a href="http://sqlite.org" class="urlextern" title="http://sqlite.org" rel="nofollow">SQLite Home Page</a> and <a href="http://en.wikipedia.org/wiki/SQL" class="urlextern" title="http://en.wikipedia.org/wiki/SQL" rel="nofollow">SQL at Wikipedia</a>.
</p>
</div>
<h3 class="sectionedit7" id="new_to_version">New To Version</h3>
<div class="level3">
<p>
0.9.6y
</p>
</div>
</div>
<div class="docInfo"><bdi>de/dbopen.txt</bdi> · Last modified: 2011/03/29 11:56 (external edit)</div>
</div></div>
<hr class="a11y" />
</div>
<div id="dokuwiki__footer"><div class="pad">
<div class="license">Except where otherwise noted, content on this wiki is licensed under the following license: <bdi><a href="http://creativecommons.org/licenses/by-sa/3.0/" rel="license" class="urlextern">CC Attribution-Share Alike 3.0 Unported</a></bdi></div>
</div></div>
</div></div>
<div id="screen__mode" class="no"></div>
</body>
</html>
|
