Differences

This shows you the differences between two versions of the page.

--- en:dbopen [2016/08/12 21:26]
admin
+++ en:dbopen [2020/02/28 10:46]
@@ Line 1: / Line 1: @@
-===== 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>
-one3.14
-three9.43
-two6.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|

DokuWiki

User Tools

Site Tools

Differences

Page Tools