===== DBOpen (Statement) =====

==== Format ====
**dbopen** [[stringexpressions|file_name]]\\
**dbopen** ( [[stringexpressions|file_name]] )\\
**dbopen** [[integerexpressions|database_number]] , [[stringexpressions|file_name]]\\
**dbopen** ( [[integerexpressions|database_number]] , [[stringexpressions|file_name]] )

==== Description ====
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.

==== Example ====
<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
</code>
will display
<code>
1one3.14
3three9.43
2two6.28
</code>

==== See Also ====
{{page>en:start#Database (SQLITE)&noheader}}

==== External Links ====
More information about databases in general and SQLite specifically can be found at [[http://sqlite.org|SQLite Home Page]] and [[http://en.wikipedia.org/wiki/SQL|SQL at Wikipedia]].

==== History ==== 
|0.9.6y|New to Version|
|0.9.9.19|Added ability to have 8 database connections|