Sql - Revision history

Ghenne: /* Example */

2021-02-01T20:46:42Z

Example

← Older revision		Revision as of 20:46, 1 February 2021
Line 22:		Line 22:

	sqlList=[]		sqlList=[]
	sqlList[1]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"]		sqlList[0]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"]
	Sql(DB, sqlList)		Sql(DB, sqlList)

Ghenne: /* Example */

2021-02-01T20:41:31Z

Example

← Older revision		Revision as of 20:41, 1 February 2021
Line 19:		Line 19:
	sqlList=[]		sqlList=[]
	sqlList[0]=["Drop Table customerData;",,skipError]		sqlList[0]=["Drop Table customerData;",,skipError]
			Sql(DB, sqlList)

			sqlList=[]
	sqlList[1]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"]		sqlList[1]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"]
	Sql(DB, sqlList)		Sql(DB, sqlList)

Ghenne: /* Description */

2014-10-07T10:42:45Z

Description

← Older revision		Revision as of 10:42, 7 October 2014
Line 6:		Line 6:

	<pre>		<pre>
	[sqlStatement, [args], successCallback, errorCallback]		[sqlStatement, [args,] successCallback, errorCallback]
	</pre>		</pre>

	''sqlStatement'' is a string containing the SQL statement to execute. ''successCallback'' is a function which is called after the statement has finished executing. ''errorCallback'' is a function which is called if an error occurred while executing the statement.		''sqlStatement'' is a string containing the SQL statement to execute. ''args'' is an optional string or array containing substitution values for parameters. ''successCallback'' is a function which is called after the statement has finished executing. ''errorCallback'' is a function which is called if an error occurred while executing the statement.

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

Ghenne: /* Description */

2014-10-07T10:41:27Z

Description

← Older revision		Revision as of 10:41, 7 October 2014
Line 6:		Line 6:

	<pre>		<pre>
	[sqlStatement, successCallback, errorCallback]		[sqlStatement, [args], successCallback, errorCallback]
	</pre>		</pre>

Ghenne: /* SQLite Error Codes */

2013-11-11T22:13:26Z

SQLite Error Codes

← Older revision		Revision as of 22:13, 11 November 2013
Line 12:		Line 12:

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

	~~== SQLite Error Codes ==~~
	~~These codes are returned in err.code in the errCallBack function.~~
	~~<pre>~~
	~~OK 0 Successful result~~
	~~ERROR 1 SQL error or missing database~~
	~~INTERNAL 2 Internal logic error in SQLite~~
	~~PERM 3 Access permission denied~~
	~~ABORT 4 Callback routine requested an abort~~
	~~BUSY 5 The database file is locked~~
	~~LOCKED 6 A table in the database is locked~~
	~~NOMEM 7 A malloc() failed~~
	~~READONLY 8 Attempt to write a readonly database~~
	~~INTERRUPT 9 Operation terminated by sqlite3_interrupt()*/~~
	~~IOERR 10 Some kind of disk I/O error occurred~~
	~~CORRUPT 11 The database disk image is malformed~~
	~~NOTFOUND 12 Unknown opcode in sqlite3_file_control()~~
	~~FULL 13 Insertion failed because database is full~~
	~~CANTOPEN 14 Unable to open the database file~~
	~~PROTOCOL 15 Database lock protocol error~~
	~~EMPTY 16 Database is empty~~
	~~SCHEMA 17 The database schema changed~~
	~~TOOBIG 18 String or BLOB exceeds size limit~~
	~~CONSTRAINT 19 Abort due to constraint violation~~
	~~MISMATCH 20 Data type mismatch~~
	~~MISUSE 21 Library used incorrectly~~
	~~NOLFS 22 Uses OS features not supported on host~~
	~~AUTH 23 Authorization denied~~
	~~FORMAT 24 Auxiliary database format error~~
	~~RANGE 25 2nd parameter to sqlite3_bind out of range~~
	~~NOTADB 26 File opened that is not a database file~~
	~~NOTICE 27 Notifications from sqlite3_log()~~
	~~WARNING 28 Warnings from sqlite3_log()~~
	~~ROW 100 sqlite3_step() has another row ready~~
	~~DONE 101 sqlite3_step() has finished executing~~
	~~</pre>~~

	== Example ==		== Example ==

Ghenne: /* SQLite Error Codes */

2013-10-25T15:45:08Z

SQLite Error Codes

← Older revision		Revision as of 15:45, 25 October 2013
Line 14:		Line 14:

	== SQLite Error Codes ==		== SQLite Error Codes ==
	These codes are returned in err.code		These codes are returned in err.code in the errCallBack function.
	<pre>		<pre>
	OK 0 Successful result		OK 0 Successful result

Ghenne: /* SQLite Error Codes: These codes are returned in err.code */

2013-10-25T15:22:37Z

SQLite Error Codes: These codes are returned in err.code

← Older revision		Revision as of 15:22, 25 October 2013
Line 13:		Line 13:
	For more information, see [[Using SQLite]].		For more information, see [[Using SQLite]].

	== SQLite Error Codes: These codes are returned in err.code ==		== SQLite Error Codes ==
			These codes are returned in err.code
	<pre>		<pre>
	OK 0 Successful result		OK 0 Successful result

Ghenne: /* Description */

2013-10-25T15:22:18Z

Description

← Older revision		Revision as of 15:22, 25 October 2013
Line 13:		Line 13:
	For more information, see [[Using SQLite]].		For more information, see [[Using SQLite]].

	SQLite Error Codes: These codes are returned in err.code		== SQLite Error Codes: These codes are returned in err.code ==
	<pre>		<pre>
	OK 0 Successful result		OK 0 Successful result

Ghenne: /* Example */

2013-10-25T15:21:43Z

Example

← Older revision		Revision as of 15:21, 25 October 2013
Line 59:		Line 59:
	Function skipError(tx, err)		Function skipError(tx, err)
	Print "Error: " & err.errcode		Print "Error: " & err.errcode
	~~end~~ Function		End Function
	</pre>		</pre>

Ghenne: /* Example */

2013-10-25T15:21:27Z

Example

← Older revision		Revision as of 15:21, 25 October 2013
Line 56:		Line 56:
	sqlList[1]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"]		sqlList[1]=["Create Table customerData('name', 'age', 'sales', PRIMARY KEY('name') );"]
	Sql(DB, sqlList)		Sql(DB, sqlList)

			Function skipError(tx, err)
			Print "Error: " & err.errcode
			end Function
	</pre>		</pre>