SqlOpenDatabase: Difference between revisions

From NSB App Studio
Jump to navigation Jump to search
m Ghenne moved page Sqlopendatabase to SqlOpenDatabase
Line 7: Line 7:
If ''filename'' does not exist, it is created.
If ''filename'' does not exist, it is created.


For more information, see Tech Note 15.
For more information on SQLite, see [[Using SQLite]].


== Example ==
== Example ==

Revision as of 13:52, 12 November 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.

If filename does not exist, it is created.

For more information on SQLite, see Using SQLite.

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