SqlOpenDatabase: Difference between revisions
Jump to navigation
Jump to search
Created page with "SqlOpenDatabase(''filename'', ''version'', ''fullname'', ''maxSize'') '''Description''' SQLOPENDATABASE is used to create and open SQLite databases. filename is the actual n..." |
No edit summary |
||
| Line 1: | Line 1: | ||
SqlOpenDatabase(''filename'', ''version'', ''fullname'', ''maxSize'') | SqlOpenDatabase(''filename'', ''version'', ''fullname'', ''maxSize'') | ||
== Description == | |||
SqlOpenDataBase is used to create and open SQLite databases. filename is the actual name of the file. version is the version number (optional). Used on file creation. Set to "1.0" if no value supplied.. fullname is a long description of the file. (optional). Used on file creation. Set to filename if no value supplied., maxsize is the maximum number of records (optional). Used on file creation. Set to 1,000,000 if no value supplied. | |||
For more information, see Tech Note 15. | For more information, see Tech Note 15. | ||
== Example == | |||
<pre> | <pre> | ||
| Line 15: | Line 15: | ||
</pre> | </pre> | ||
== Output == | |||
<pre> | <pre> | ||
| Line 21: | Line 21: | ||
</pre> | </pre> | ||
== Related Items == | |||
[[sql|SQL]] | [[sql|SQL]] | ||
[[Category:Language Reference]] | |||
Revision as of 03:31, 17 August 2012
SqlOpenDatabase(filename, version, fullname, maxSize)
Description
SqlOpenDataBase is used to create and open SQLite databases. filename is the actual name of the file. version is the version number (optional). Used on file creation. Set to "1.0" if no value supplied.. fullname is a long description of the file. (optional). Used on file creation. Set to filename if no value supplied., maxsize is the maximum number of records (optional). Used on file creation. Set to 1,000,000 if no value supplied.
For more information, see Tech Note 15.
Example
REM SqlOpenDatabase sample
DB = SqlOpenDatabase("customers.db","1.0","My Customer Database")
If DB=0 Then MsgBox "Could not open. "
Output
(the database is created if it did not exist)