File: pt_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 (121 lines) | stat: -rw-r--r-- 6,328 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
 
<!DOCTYPE html>
<html lang="en" dir="ltr" class="no-js">
<head>
    <meta charset="utf-8" />
    <title>pt: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="pt_start.html" class="wikilink1" title="pt:start">pt</a></bdi> » <bdi><span class="curid"><a href="pt_dbopen.html" class="wikilink1" title="pt: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>pt: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="pt_dbopen.html#dbopen">DBOpen</a></div>
<ul class="toc">
<li class="level3"><div class="li"><a href="pt_dbopen.html#formato">Formato</a></div></li>
<li class="level3"><div class="li"><a href="pt_dbopen.html#descricao">Descrição</a></div></li>
<li class="level3"><div class="li"><a href="pt_dbopen.html#exemplo">Exemplo</a></div></li>
<li class="level3"><div class="li"><a href="pt_dbopen.html#ver_tambem">Ver também</a></div></li>
<li class="level3"><div class="li"><a href="pt_dbopen.html#ligacoes_externas">Ligações externas</a></div></li>
<li class="level3"><div class="li"><a href="pt_dbopen.html#historia">História</a></div></li>
</ul></li>
</ul>
</div>
</div>
<h2 class="sectionedit1" id="dbopen">DBOpen</h2>
<div class="level2">
</div>
<h3 class="sectionedit2" id="formato">Formato</h3>
<div class="level3">
<p>
<strong>dbopen</strong> <em>SQLiteFile</em><br/>
<strong>dbopen</strong> ( <em>SQLiteFile</em> )<br/>
<strong>dbopen</strong> <em>DatabaseNumber</em> , <em>SQLiteFile</em><br/>
<strong>dbopen</strong> ( <em>DatabaseNumber</em> , <em>SQLiteFile</em> )
</p>
</div>
<h3 class="sectionedit3" id="descricao">Descrição</h3>
<div class="level3">
<p>
Abre um ficheiro SQLite .Se o ficheiro não existe então é criado. Podem ser feitas até oito ligações ao mesmo tempo num programa.  Se um número não for especificado então será usada a ligação 0.
</p>
</div>
<h3 class="sectionedit4" id="exemplo">Exemplo</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>
mostra
</p>
<pre class="code">1one3.14
3three9.43
2two6.28</pre>
</div>
<h3 class="sectionedit5" id="ver_tambem">Ver também</h3>
<div class="level3">
<p>
<a href="pt_dbclose.html" class="wikilink1" title="pt:dbclose">DBClose</a>, <a href="pt_dbcloseset.html" class="wikilink1" title="pt:dbcloseset">DBCloseSet</a>, <a href="pt_dbexecute.html" class="wikilink1" title="pt:dbexecute">DBExecute</a>, <a href="pt_dbfloat.html" class="wikilink1" title="pt:dbfloat">DBFloat</a>, <a href="pt_dbint.html" class="wikilink1" title="pt:dbint">DBInt</a>, <a href="pt_dbnull.html" class="wikilink1" title="pt:dbnull">DBNull</a>, <span class="curid"><a href="pt_dbopen.html" class="wikilink1" title="pt:dbopen">DBOpen</a></span>, <a href="pt_dbopenset.html" class="wikilink1" title="pt:dbopenset">DBOpenSet</a>, <a href="pt_dbrow.html" class="wikilink1" title="pt:dbrow">DBRow</a>, <a href="pt_dbstring.html" class="wikilink1" title="pt:dbstring">DBString</a>. <a href="pt_freedb.html" class="wikilink2" title="pt:freedb" rel="nofollow">Freedb</a>, <a href="pt_freedbset.html" class="wikilink2" title="pt:freedbset" rel="nofollow">Freedbset</a>
</p>
</div>
<h3 class="sectionedit6" id="ligacoes_externas">Ligações externas</h3>
<div class="level3">
<p>
Mais informação acerca de bases de dados em geral e SQLite especificamente pode ser encontrada em <a href="http://sqlite.org" class="urlextern" title="http://sqlite.org"  rel="nofollow">SQLite Home Page</a> e <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="historia">História</h3>
<div class="level3">
<p>
0.9.6y - introduzido<br/>
0.9.9.19 - Capacidade para 8 ligações
</p>
</div>
                                    </div>
                <div class="docInfo"><bdi>pt/dbopen.txt</bdi> · Last modified: 2012/12/19 15:44 by <bdi>m_santos</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>