File: en_dbopen.html

package info (click to toggle)
basic256 1.1.4.0-2
  • links: PTS, VCS
  • area: main
  • in suites: stretch
  • size: 24,460 kB
  • sloc: cpp: 10,148; yacc: 3,023; java: 1,091; lex: 1,051; sh: 117; xml: 33; makefile: 15
file content (131 lines) | stat: -rw-r--r-- 7,012 bytes parent folder | download | duplicates (2) 
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
119
120
121
122
123
124
125
126
127
128
129
130
131
 
<!DOCTYPE html>
<html lang="en" dir="ltr" class="no-js">
<head>
    <meta charset="utf-8" />
    <title>en: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="en_start.html" class="wikilink1" title="en:start">en</a></bdi> » <bdi><span class="curid"><a href="en_dbopen.html" class="wikilink1" title="en: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>en: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="en_dbopen.html#dbopen_statement">DBOpen (Statement)</a></div>
<ul class="toc">
<li class="level3"><div class="li"><a href="en_dbopen.html#format">Format</a></div></li>
<li class="level3"><div class="li"><a href="en_dbopen.html#description">Description</a></div></li>
<li class="level3"><div class="li"><a href="en_dbopen.html#example">Example</a></div></li>
<li class="level3"><div class="li"><a href="en_dbopen.html#see_also">See Also</a></div></li>
<li class="level3"><div class="li"><a href="en_dbopen.html#external_links">External Links</a></div></li>
<li class="level3"><div class="li"><a href="en_dbopen.html#history">History</a></div></li>
</ul></li>
</ul>
</div>
</div>
<h2 class="sectionedit1" id="dbopen_statement">DBOpen (Statement)</h2>
<div class="level2">
</div>
<h3 class="sectionedit2" id="format">Format</h3>
<div class="level3">
<p>
<strong>dbopen</strong> <em><a class="explain" href="en_expressions.html#string_expressions">file_name</a></em><br/>
<strong>dbopen</strong> ( <em><a class="explain" href="en_expressions.html#string_expressions">file_name</a></em> )<br/>
<strong>dbopen</strong> <em><a class="explain" href="en_dbopen.html">database_number</a></em> , <em><a class="explain" href="en_expressions.html#string_expressions">file_name</a></em><br/>
<strong>dbopen</strong> ( <em><a class="explain" href="en_dbopen.html">database_number</a></em> , <em><a class="explain" href="en_expressions.html#string_expressions">file_name</a></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. Up to eight database connections can be made at a time in a program.  If the database number is not specified then connection 0 will be used.
</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 &quot;dbtest.sqlite3&quot;
# delete old foo table - trap error if new database
onerror errortrap
dbexecute &quot;drop table foo;&quot;
offerror
# create and populate
dbexecute &quot;create table foo (id integer, words text, value decimal);&quot;
dbexecute &quot;insert into foo values (1,&#039;one&#039;,3.14);&quot;
dbexecute &quot;insert into foo values (2,&#039;two&#039;,6.28);&quot;
dbexecute &quot;insert into foo values (3,&#039;three&#039;,9.43);&quot;
# open a recordset and loop through the rows of data
dbopenset &quot;select * from foo order by words;&quot;
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">
</div>
<div class="plugin_include_content plugin_include__en:start">
<div class="level3">
<p>
<a href="en_dbclose.html" class="wikilink1" title="en:dbclose">DBClose</a>, <a href="en_dbcloseset.html" class="wikilink1" title="en:dbcloseset">DBCloseSet</a>, <a href="en_dbexecute.html" class="wikilink1" title="en:dbexecute">DBExecute</a>, <a href="en_dbfloat.html" class="wikilink1" title="en:dbfloat">DBFloat</a>, <a href="en_dbint.html" class="wikilink1" title="en:dbint">DBInt</a>, <a href="en_dbnull.html" class="wikilink1" title="en:dbnull">DBNull</a>, <span class="curid"><a href="en_dbopen.html" class="wikilink1" title="en:dbopen">DBOpen</a></span>, <a href="en_dbopenset.html" class="wikilink1" title="en:dbopenset">DBOpenSet</a>, <a href="en_dbrow.html" class="wikilink1" title="en:dbrow">DBRow</a>, <a href="en_dbstring.html" class="wikilink1" title="en:dbstring">DBString</a>. <a href="en_freedb.html" class="wikilink1" title="en:freedb">Freedb</a>, <a href="en_freedbset.html" class="wikilink1" title="en:freedbset">Freedbset</a>
</p>
</div>
</div>
<div class="level3">
</div>
<h3 class="sectionedit9" 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="sectionedit10" id="history">History</h3>
<div class="level3">
<div class="table sectionedit11"><table class="inline">
	<tr class="row0">
		<td class="col0">0.9.6y</td><td class="col1">New to Version</td>
	</tr>
	<tr class="row1">
		<td class="col0">0.9.9.19</td><td class="col1">Added ability to have 8 database connections</td>
	</tr>
</table></div>
</div>
                                    </div>
                <div class="docInfo"><bdi>en/dbopen.txt</bdi> · Last modified: 2014/02/08 12:22 by <bdi>admin</bdi></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>