SqlOpenDatabase: Difference between revisions

From NSB App Studio
Jump to navigation Jump to search
No edit summary
No edit summary
Line 12: Line 12:
Rem SqlOpenDatabase sample
Rem SqlOpenDatabase sample
DB = SqlOpenDatabase("customers.db","1.0","My Customer Database")
DB = SqlOpenDatabase("customers.db","1.0","My Customer Database")
If DB=0 Then MsgBox "Could not open. "
Print "Database version is " & DB.version</pre>
</pre>


== Output ==
== Output ==


<pre>
<pre>
(the database is created if it did not exist)
Database version is 1.0
</pre>
</pre>



Revision as of 19:31, 15 September 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")
Print "Database version is " & DB.version

Output

Database version is 1.0

Related Items

Sql