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
|
<!DOCTYPE html>
<html lang="en" dir="ltr" class="no-js">
<head>
<meta charset="utf-8" />
<title>nl: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="nl_start.html" class="wikilink1" title="nl:start">nl</a></bdi> » <bdi><span class="curid"><a href="nl_dbopen.html" class="wikilink1" title="nl: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>nl: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="nl_dbopen.html#dbopen">DBOpen</a></div>
<ul class="toc">
<li class="level3"><div class="li"><a href="nl_dbopen.html#formaat">Formaat</a></div></li>
<li class="level3"><div class="li"><a href="nl_dbopen.html#beschrijving">Beschrijving</a></div></li>
<li class="level3"><div class="li"><a href="nl_dbopen.html#voorbeeld">Voorbeeld</a></div></li>
<li class="level3"><div class="li"><a href="nl_dbopen.html#zie_ook">Zie ook</a></div></li>
<li class="level3"><div class="li"><a href="nl_dbopen.html#externe_links">Externe Links</a></div></li>
<li class="level3"><div class="li"><a href="nl_dbopen.html#nieuw_vanaf">Nieuw vanaf</a></div></li>
</ul></li>
</ul>
</div>
</div>
<h2 class="sectionedit1" id="dbopen">DBOpen</h2>
<div class="level2">
</div>
<h3 class="sectionedit2" id="formaat">Formaat</h3>
<div class="level3">
<p>
<strong>dbopen</strong> <em>SQLiteFile</em><br/>
<strong>dbopen</strong> ( <em>SQLiteFile</em> )
</p>
</div>
<h3 class="sectionedit3" id="beschrijving">Beschrijving</h3>
<div class="level3">
<p>
De functie opent een SQLite database bestand. Als het bestand niet bestaat, dan wordt het aangemaakt.
</p>
</div>
<h3 class="sectionedit4" id="voorbeeld">Voorbeeld</h3>
<div class="level3">
<pre class="code basic4gl">#database foo <span class="sy0">-</span> maak de database aan, zet dat in de database <span class="sy0">-</span> open dan een recordset en lees de <span class="kw3">data</span> uit de tabel.
# maak een nieuw bestand aan en open het
dbopen <span class="st0">"dbtest.sqlite3"</span>
# wis de oude tabel, vang de fout op indien de tabel niet bestaat.
onerror errortrap
dbexecute <span class="st0">"drop table foo;"</span>
offerror
# create <span class="kw3">and</span> populate
dbexecute <span class="st0">"create table foo (id integer, words text, value decimal);"</span>
dbexecute <span class="st0">"insert into foo values (1,'een',3.14);"</span>
dbexecute <span class="st0">"insert into foo values (2,'twee',6.28);"</span>
dbexecute <span class="st0">"insert into foo values (3,'drie',9.43);"</span>
# open een recordset en ga door alle rijen
dbopenset <span class="st0">"select * from foo order by words;"</span>
<span class="kw3">while</span> dbrow<span class="br0">(</span><span class="br0">)</span>
<span class="kw2">print</span> dbint<span class="br0">(</span><span class="nu0">0</span><span class="br0">)</span> <span class="sy0">+</span> dbstring<span class="br0">(</span><span class="nu0">1</span><span class="br0">)</span> <span class="sy0">+</span> dbfloat<span class="br0">(</span><span class="nu0">2</span><span class="br0">)</span>
<span class="kw3">end</span> <span class="kw3">while</span>
dbcloseset
# Sluit de boel maar
dbclose
<span class="kw3">end</span>
errortrap<span class="sy0">:</span>
# <span class="co1">'t is goed, ga gewoon verder </span>
<span class="kw3">return</span></pre>
<p>
toont dan
</p>
<pre class="code">1een3.14
3drie9.43
2twee6.28</pre>
</div>
<h3 class="sectionedit5" id="zie_ook">Zie ook</h3>
<div class="level3">
<p>
<a href="nl_dbclose.html" class="wikilink1" title="nl:dbclose">DBClose</a>, <a href="nl_dbcloseset.html" class="wikilink1" title="nl:dbcloseset">DBCloseSet</a>, <a href="nl_dbexecute.html" class="wikilink1" title="nl:dbexecute">DBExecute</a>, <a href="nl_dbfloat.html" class="wikilink1" title="nl:dbfloat">DBFloat</a>, <a href="nl_dbint.html" class="wikilink1" title="nl:dbint">DBInt</a>, <a href="nl_dbopenset.html" class="wikilink1" title="nl:dbopenset">DBOpenSet</a>, <a href="nl_dbrow.html" class="wikilink1" title="nl:dbrow">DBRow</a>, <a href="nl_dbstring.html" class="wikilink1" title="nl:dbstring">DBString</a>
</p>
</div>
<h3 class="sectionedit6" id="externe_links">Externe Links</h3>
<div class="level3">
<p>
Meer informatie over database en SQLLite vind je op <a href="http://sqlite.org" class="urlextern" title="http://sqlite.org" rel="nofollow">SQLite Home Page</a> en <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="nieuw_vanaf">Nieuw vanaf</h3>
<div class="level3">
<p>
0.9.6y
</p>
<hr />
<p>
<a href="nl_dbint.html" class="wikilink1" title="nl:dbint">vorige</a> | <a href="nl_databases.html" class="wikilink1" title="nl:databases">Databank</a> | <a href="nl_dbopenset.html" class="wikilink1" title="nl:dbopenset">volgende</a>
</p>
</div>
</div>
<div class="docInfo"><bdi>nl/dbopen.txt</bdi> · Last modified: 2012/02/13 14:34 by <bdi>tlesseliers</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>
|
