SQLite made Simple - Revision history

Ghenne: /* Delete Button */

2025-11-28T16:14:52Z

Delete Button

@@ Line 161: / Line 161: @@
 * We call nameDeleted() on successful deletion.
 * If the deletion is unsuccessful, nothing happens.
-<pre>
+<tabber>
 Function btnDelete_onclick()
    sqlList = []
@@ Line 173: / Line 190: @@
    MsgBox txtFind.value & " Deleted"
 End Function
-</pre>
+</syntaxhighlight>

Ghenne: /* Find Button */

2025-11-28T16:13:29Z

Find Button

@@ Line 113: / Line 113: @@
 * The results (there could be more than one) are returned in an array.
 * If there are no rows in the array, nothing was found.
-<pre>
+<tabber>
 Function btnFind_onclick()
    sqlList=[]
@@ Line 129: / Line 154: @@
    txtAge.value = results.rows.item(0).age
 End Function
-</pre>
+</syntaxhighlight>
 === Delete Button ===

Ghenne: /* Save Button */

2025-11-28T16:12:20Z

Save Button

@@ Line 78: / Line 78: @@
 * Don't save anything if name is empty.
 * INSERT INTO tells SQLite to add a record into the studentData table.
-<pre>
+<tabber>
 Function btnSave_onclick()
    If txtName.value="" Then Exit Function
@@ Line 86: / Line 105: @@
    Sql(DB, sqlList)
 End Function
-</pre>
+</syntaxhighlight>
 === Find Button ===

Ghenne at 16:11, 28 November 2025

2025-11-28T16:11:20Z

@@ Line 29: / Line 29: @@
 * [[Sql]] sends an array of commands to SQLite for processing.
-<pre>
+<tabber>
-Dim DB
+ JavaScript=
 Sub Main
@@ Line 47: / Line 72: @@
    MsgBox error
 End Sub
-</pre>
+</syntaxhighlight>
 === Save Button ===

Ghenne at 15:56, 28 November 2025

2025-11-28T15:56:25Z

← Older revision		Revision as of 15:56, 28 November 2025
Line 33:		Line 33:

	Sub Main		Sub Main
	DB = SqlOpenDatabase("~~students.db~~")		DB = SqlOpenDatabase("localStorage")
	sqlList=[]		sqlList=[]
	sqlList[0]=["CREATE TABLE studentData('name', 'age', PRIMARY KEY('name') );", _		sqlList[0]=["CREATE TABLE studentData('name', 'age', PRIMARY KEY('name') );", _

Ghenne at 15:55, 28 November 2025

2025-11-28T15:55:08Z

← Older revision		Revision as of 15:55, 28 November 2025
Line 1:		Line 1:
	== SQLite Overview ==		== SQLite Overview ==

	[http://en.wikipedia.org/wiki/Sqlite SQLite] is a fast, popular and easy to use database. Its speed and easy of use make it a practical choice for use when you need an indexed file system for an app. Databases you create can be accessed, without change, on any platform SQLite supports. It is ~~built into most mobile devices that AppStudio supports as well as Chrome~~ and ~~Safari on the desktop. It is not supported by Internet Explorer or FireFox~~.		[http://en.wikipedia.org/wiki/Sqlite SQLite] is a fast, popular and easy to use database. Its speed and easy of use make it a practical choice for use when you need an indexed file system for an app. Databases you create can be accessed, without change, on any platform SQLite supports. Using the [[Support_for_SQLite\|SQLite (WASM) library]], it is usable on almost all platforms and browsers.

	* Your app can create, update and delete SQLite databases.		* Your app can create, update and delete SQLite databases.
	* Databases are kept in your app's ~~private directory~~.		* Databases are kept in your app's localStorage.
	* Apps cannot access each other's data for security purposes.		* Apps cannot access each other's data for security purposes.
	* The exception is apps which are ~~load~~ from the same server.		* The exception is apps which are loaded from the same server.
	* Databases cannot be directly imported or exported, once again, for security reasons. You can include an SQLite database with your app.		* Databases cannot be directly imported or exported, once again, for security reasons. You can include an SQLite database with your app.
	* Databases can be imported or exported using SqlExport and SqlImport ~~We will go in depth on SQLite in the next Section~~.		* Databases can be imported or exported using SqlExport and SqlImport.

	~~The maximum size of an~~ SQLite ~~database varies by OS and device~~. ~~Here's an article with more information: http://www.html5rocks.com/en/tutorials/offline/quota-research/~~		We will go in depth on SQLite in the next Section.

	~~== Asynchronous Results ==~~		The maximum size of an SQLite database varies by OS and device. It is limited by the maximum size of localStorage, generally about 5 or 10 megs.

	* The ~~results~~ of ~~calls to the~~ database ~~are returned asynchronously~~. ~~That means that after a statement involving the database~~ is ~~executed,~~ the ~~next statement in the program is executed - even though the database operation may not be complete.~~
	* When it finishes, it will call a success or fail function in your program.
	* In the meantime, ~~you can do other processing: update controls on the screen~~ or ~~do calculations~~.
	* Do not do a [[MsgBox]] statement while you are waiting for an SQL call to finish - you will lose the callback.

	~~console.log("Before doing call")~~
	~~sqlList="CREATE TABLE myData('name', 'age')"~~
	~~sql(DB, [sqlList, Success_Function, Fail_Function])~~
	~~console.log("After doing call")~~

	~~Function Success_Function(transaction, result)~~
	~~console.log("Success - result received"~~
	~~End function~~

	~~Function Fail_Function(transaction, result)~~
	~~console.log("Fail")~~
	~~End function~~

	~~The result will be 3 messages, in this order, in the Chrome Debugger Console:~~

	~~Before doing call~~
	~~After doing call~~
	~~Success - result received~~

	== Sample App ==		== Sample App ==
Line 60:		Line 36:
	sqlList=[]		sqlList=[]
	sqlList[0]=["CREATE TABLE studentData('name', 'age', PRIMARY KEY('name') );", _		sqlList[0]=["CREATE TABLE studentData('name', 'age', PRIMARY KEY('name') );", _
	success, fail]		success, fail]
	Sql(DB, sqlList)		Sql(DB, sqlList)
	End Sub		End Sub

	Sub success()		Sub success()
			console.log("success")
	End Sub		End Sub

	Sub fail()		Sub fail(error)
			MsgBox error
	End Sub		End Sub
	</pre>		</pre>
Line 79:		Line 57:
	sqlList = []		sqlList = []
	sqlList[0]=["INSERT INTO studentData (name,age) VALUES (?,?)", _		sqlList[0]=["INSERT INTO studentData (name,age) VALUES (?,?)", _
	[txtName.value, ~~TxtAge~~.value]]		[txtName.value, txtAge.value], success, fail]
	Sql(DB, sqlList)		Sql(DB, sqlList)
	End Function		End Function
Line 93:		Line 71:
	sqlList=[]		sqlList=[]
	sqlList[0]=["SELECT * FROM studentData WHERE name=?", txtFind.value, nameFound]		sqlList[0]=["SELECT * FROM studentData WHERE name=?", txtFind.value, nameFound]
	~~txtFind.value & "'", nameFound]~~
	Sql(DB, sqlList)		Sql(DB, sqlList)
	End Function		End Function

	Function nameFound(transaction, results)		Function nameFound(transaction, results)
	If results.rows.length>0 Then		If results.rows.length > 0 Then
	MsgBox results.rows.item(0).name & " is " & results.rows.item(0).age		MsgBox results.rows.item(0).name & " is " & results.rows.item(0).age
	Else		Else
	MsgBox "Name not found"		MsgBox "Name not found"
	End If		End If
			txtName.value = results.rows.item(0).name
			txtAge.value = results.rows.item(0).age
	End Function		End Function

	</pre>		</pre>

Line 116:		Line 94:
	sqlList[0]=["DELETE FROM studentData WHERE name=?", txtFind.value, nameDeleted]		sqlList[0]=["DELETE FROM studentData WHERE name=?", txtFind.value, nameDeleted]
	Sql(DB, sqlList)		Sql(DB, sqlList)
			txtName.value = ""
			txtAge.value = ""
	End Function		End Function

Line 121:		Line 101:
	MsgBox txtFind.value & " Deleted"		MsgBox txtFind.value & " Deleted"
	End Function		End Function

	</pre>		</pre>

Ghenne at 20:43, 1 February 2021

2021-02-01T20:43:16Z

← Older revision		Revision as of 20:43, 1 February 2021
Line 57:		Line 57:

	Sub Main		Sub Main
	DB = SqlOpenDatabase("students.db~~","1.0","My Student Database~~")		DB = SqlOpenDatabase("students.db")
	sqlList=[]		sqlList=[]
	sqlList[0]=["CREATE TABLE studentData('name', 'age', PRIMARY KEY('name') );", _		sqlList[0]=["CREATE TABLE studentData('name', 'age', PRIMARY KEY('name') );", _

Ghenne: /* SQLite Overview */

2015-05-14T09:57:24Z

SQLite Overview

← Older revision		Revision as of 09:57, 14 May 2015
Line 1:		Line 1:
	== SQLite Overview ==		== SQLite Overview ==

	[http://en.wikipedia.org/wiki/Sqlite SQLite] is a fast, popular and easy to use database. Its speed and easy of use make it a practical choice for use when you need an indexed file system for an app. Databases you create can be accessed, without change, on any platform SQLite supports. It is built into ~~all~~ mobile devices that AppStudio supports as well as the desktop.		[http://en.wikipedia.org/wiki/Sqlite SQLite] is a fast, popular and easy to use database. Its speed and easy of use make it a practical choice for use when you need an indexed file system for an app. Databases you create can be accessed, without change, on any platform SQLite supports. It is built into most mobile devices that AppStudio supports as well as Chrome and Safari on the desktop. It is not supported by Internet Explorer or FireFox.

	* Your app can create, update and delete SQLite databases.		* Your app can create, update and delete SQLite databases.

Ghenne: /* Save Button */

2014-10-07T17:58:46Z

Save Button

← Older revision		Revision as of 17:58, 7 October 2014
Line 78:		Line 78:
	If txtName.value="" Then Exit Function		If txtName.value="" Then Exit Function
	sqlList = []		sqlList = []
	sqlList[0]=["INSERT INTO studentData (name,age) VALUES (?,?)", [txtName.value, TxtAge.value]]		sqlList[0]=["INSERT INTO studentData (name,age) VALUES (?,?)", _
			[txtName.value, TxtAge.value]]
	Sql(DB, sqlList)		Sql(DB, sqlList)
	End Function		End Function

Ghenne: /* Save Button */

2014-10-07T17:58:25Z

Save Button

← Older revision		Revision as of 17:58, 7 October 2014
Line 78:		Line 78:
	If txtName.value="" Then Exit Function		If txtName.value="" Then Exit Function
	sqlList = []		sqlList = []
	sqlList[0]=["INSERT INTO studentData (name,age) VALUES (?,?)", _		sqlList[0]=["INSERT INTO studentData (name,age) VALUES (?,?)", [txtName.value, TxtAge.value]]
	[txtName.value, TxtAge.value]]
	Sql(DB, sqlList)		Sql(DB, sqlList)
	End Function		End Function