SqlOpenDatabase: Difference between revisions

From NSB App Studio
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
SqlOpenDatabase(''filename''[, ''version''[, ''fullname''[, ''maxSize']]]')
SqlOpenDatabase(''filename'')


== Description ==
== Description ==
Line 6: Line 6:


''filename'' is the actual name of the file. If ''filename'' does not exist, it is created.
''filename'' is the actual name of the file. If ''filename'' does not exist, it is created.
''version'' (optional) is the version number. Used on file creation. Set to "1.0" if no value supplied.
''fullname'' (optional)  is a long description of the file. (optional). Used on file creation. Set to ''filename'' if no value supplied.
''maxsize'' (optional)  is the maximum number of records (optional). Used on file creation. Set to 1,000,000 if no value supplied.


For more information on SQLite, see [[Using SQLite]].
For more information on SQLite, see [[Using SQLite]].
Line 19: Line 13:
<pre>
<pre>
Rem SqlOpenDatabase sample
Rem SqlOpenDatabase sample
DB = SqlOpenDatabase("customers.db","1.0","My Customer Database")
DB = SqlOpenDatabase("customers.db")
If DB.version <> "" Then
If DB.version <> "" Then
   Print "Database version is " & DB.version
   Print "Database version is " & DB.version

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

Related Items

Sql

SQLite Reference

Using SQLite