SqlOpenDatabase - Revision history

Ghenne: /* Description */

2024-08-28T14:05:34Z

Description

← Older revision		Revision as of 14:05, 28 August 2024
Line 3:		Line 3:
	== Description ==		== Description ==

	SqlOpenDataBase is used to create and open SQLite databases.		SqlOpenDataBase is used to create and open SQLite databases. It works with both the SQLite WASM library and the Cordova SQLite plugin.

	''dbName'' is the name of the database. If ''dbName'' does not exist, it is created. The database is created in localStorage by default. If another name is supplied, it is created as that name - but will not persist if the app is restarted.		''dbName'' is the name of the database. If ''dbName'' does not exist, it is created. The database is created in localStorage by default. If another name is supplied, it is created as that name - but will not persist if the app is restarted.

2024-06-03T13:50:28Z

Description

← Older revision		Revision as of 13:50, 3 June 2024
Line 5:		Line 5:
	SqlOpenDataBase is used to create and open SQLite databases.		SqlOpenDataBase is used to create and open SQLite databases.

	''dbName'' is the name of the database. If ''dbName'' does not exist, it is created. The database is created in ~~temporary memory~~, ~~unless~~ the ~~name~~ is ~~''localStorage''~~.		''dbName'' is the name of the database. If ''dbName'' does not exist, it is created. The database is created in localStorage by default. If another name is supplied, it is created as that name - but will not persist if the app is restarted.

	For more information on SQLite, see [[Using SQLite]].		For more information on SQLite, see [[Using SQLite]].

2024-06-03T13:49:20Z

2024-04-28T14:46:37Z

← Older revision		Revision as of 14:46, 28 April 2024
Line 1:		Line 1:
	SqlOpenDatabase(''~~filename~~'')		SqlOpenDatabase(''dnName'')

	== Description ==		== Description ==
Line 5:		Line 5:
	SqlOpenDataBase is used to create and open SQLite databases.		SqlOpenDataBase is used to create and open SQLite databases.

	''dbName'' is the name of the database. If ''dbName'' does not exist, it is created. The database is created in temporary memory, unless ~~the use~~ the name ''localStorage''.		''dbName'' is the name of the database. If ''dbName'' does not exist, it is created. The database is created in temporary memory, unless the name is ''localStorage''.

	For more information on SQLite, see [[Using SQLite]].		For more information on SQLite, see [[Using SQLite]].

2024-04-28T14:45:57Z

Description

← Older revision		Revision as of 14:45, 28 April 2024
Line 5:		Line 5:
	SqlOpenDataBase is used to create and open SQLite databases.		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.		''dbName'' is the name of the database. If ''dbName'' does not exist, it is created. The database is created in temporary memory, unless the use the name ''localStorage''.

	For more information on SQLite, see [[Using SQLite]].		For more information on SQLite, see [[Using SQLite]].

2021-02-01T20:40:20Z

← Older revision		Revision as of 20:40, 1 February 2021
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

2013-10-25T15:05:59Z

Example

← Older revision		Revision as of 15:05, 25 October 2013
Line 20:		Line 20:
	Rem SqlOpenDatabase sample		Rem SqlOpenDatabase sample
	DB = SqlOpenDatabase("customers.db","1.0","My Customer Database")		DB = SqlOpenDatabase("customers.db","1.0","My Customer Database")
	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 ==

2013-10-25T15:02:25Z

← Older revision		Revision as of 15:02, 25 October 2013
Line 1:		Line 1:
	SqlOpenDatabase(''filename'', ''version'', ''fullname'', ''maxSize'')		SqlOpenDatabase(''filename''[, ''version''[, ''fullname''[, ''maxSize']]]')

	== Description ==		== Description ==

2013-10-25T15:01:58Z

Description

← Older revision		Revision as of 15:01, 25 October 2013
Line 7:		Line 7:
	''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 ~~(optional)~~. Used on file creation. Set to "1.0" if no value supplied.		''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.		''fullname'' (optional) is a long description of the file. (optional). Used on file creation. Set to ''filename'' if no value supplied.

2013-10-25T15:01:37Z

← Older revision		Revision as of 15:01, 25 October 2013
Line 3:		Line 3:
	== Description ==		== 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.		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.

			''version'' (optional) is the version number (optional). 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]].