SqlOpenDatabase: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
(5 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
SqlOpenDatabase(''filename | SqlOpenDatabase(''filename'') | ||
== Description == | == Description == | ||
SqlOpenDataBase is used to create and open SQLite databases | SqlOpenDataBase is used to create and open SQLite databases. | ||
If ''filename'' does not exist, it is created. | ''filename'' is the actual name of the file. If ''filename'' does not exist, it is created. | ||
For more information on SQLite, see [[Using SQLite]]. | For more information on SQLite, see [[Using SQLite]]. | ||
Line 13: | Line 13: | ||
<pre> | <pre> | ||
Rem SqlOpenDatabase sample | Rem SqlOpenDatabase sample | ||
DB = SqlOpenDatabase("customers.db" | DB = SqlOpenDatabase("customers.db") | ||
Print "Database version is " & DB.version</pre> | If DB.version <> "" Then | ||
Print "Database version is " & DB.version | |||
Else | |||
print "Database not found." | |||
End If | |||
</pre> | |||
== Output == | == Output == | ||
Line 25: | Line 30: | ||
[[sql|Sql]] | [[sql|Sql]] | ||
[[SQLite Reference]] | |||
[[Using SQLite]] | |||
[[Category:Language Reference]] | [[Category:Language Reference]] | ||
[[Category:Miscellaneous]] | [[Category:Miscellaneous]] |
Revision as of 20:40, 1 February 2021
SqlOpenDatabase(filename)
Description
SqlOpenDataBase is used to create and open SQLite databases.
filename is the actual name of the file. If filename does not exist, it is created.
For more information on SQLite, see Using SQLite.
Example
Rem SqlOpenDatabase sample DB = SqlOpenDatabase("customers.db") If DB.version <> "" Then Print "Database version is " & DB.version Else print "Database not found." End If
Output
Database version is 1.0