ExecuteSQLDelete - Revision history

AlexTMjugador: Changed "DeprecatedWithAlt" template to "Deprecated"

2015-02-13T16:24:16Z

Changed "DeprecatedWithAlt" template to "Deprecated"

← Older revision		Revision as of 16:24, 13 February 2015
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{Server function}}		{{Server function}}
	{{~~DeprecatedWithAlt~~\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent DELETE usage}}		{{Deprecated\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent DELETE usage.}}

	This function deletes any rows (from the database) that meet the specified conditions in the specified table.		This function deletes any rows (from the database) that meet the specified conditions in the specified table.

2015-02-11T16:40:03Z

Example

← Older revision		Revision as of 16:40, 11 February 2015
Line 29:		Line 29:
	executeSQLCreateTable("table", "row TEXT")		executeSQLCreateTable("table", "row TEXT")
	end		end
	addEventHandler("onResourceStart", getResourceRootElement(~~getThisResource()~~), tableCreate)		addEventHandler("onResourceStart", getResourceRootElement(), tableCreate)

	-- Add's a command "deleterow" to delete the row called "row"		-- Add's a command "deleterow" to delete the row called "row"

2012-07-20T21:21:35Z

← Older revision		Revision as of 21:21, 20 July 2012
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{Server function}}		{{Server function}}
			{{DeprecatedWithAlt\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent DELETE usage}}
	This function deletes any rows (from the database) that meet the specified conditions in the specified table.		This function deletes any rows (from the database) that meet the specified conditions in the specified table.

2010-06-08T18:46:10Z

2010-06-08T16:12:03Z

Example

← Older revision		Revision as of 16:12, 8 June 2010
Line 22:		Line 22:

	===Example===		===Example===
	This example creates a table and add's a command to delete the ~~rows~~ inside the table.		This example creates a table and add's a command to delete the row called "row" inside the table.
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	-- Create's the table named "table" on resource start.		-- Create's the table named "table" on resource start.

2010-06-08T16:11:30Z

Example

← Older revision		Revision as of 16:11, 8 June 2010
Line 22:		Line 22:

	===Example===		===Example===
	This example creates a table and add a command to delete the rows inside the table.		This example creates a table and add's a command to delete the rows inside the table.
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	-- Create's the table named "table" on resource start.		-- Create's the table named "table" on resource start.

2010-06-08T16:11:14Z

Example

← Older revision		Revision as of 16:11, 8 June 2010
Line 22:		Line 22:

	===Example===		===Example===
	This example ~~deletes~~ a table ~~on start~~.		This example creates a table and add a command to delete the rows inside the table.
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	-- Create's the table named "table" on resource start.		-- Create's the table named "table" on resource start.

2010-06-08T16:10:31Z

Example

← Older revision		Revision as of 16:10, 8 June 2010
Line 22:		Line 22:

	===Example===		===Example===
	This ~~page does not currently have an~~ example		This example deletes a table on start.
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	--~~enter an example here~~		-- Create's the table named "table" on resource start.
			function tableCreate()
			executeSQLCreateTable("table", "row TEXT")
			end
			addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), tableCreate)

			-- Add's a command "deleterow" to delete the row called "row"

			function rowDelete()
			executeSQLDelete("table", "row")
			end
			addCommandHandler("deleterow", rowDelete)
	</syntaxhighlight>		</syntaxhighlight>

2007-08-26T15:36:30Z

2007-08-26T14:50:08Z

← Older revision		Revision as of 14:50, 26 August 2007
Line 24:		Line 24:
	This page does not currently have an example		This page does not currently have an example
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	~~Pending~~		--enter an example here
	</syntaxhighlight>		</syntaxhighlight>

	==See Also==		==See Also==
	{{Registry_functions}}		{{Registry_functions}}