ExecuteSQLDelete: Difference between revisions

From Multi Theft Auto: Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 11: Line 11:
==Syntax==  
==Syntax==  
<syntaxhighlight lang="lua">
<syntaxhighlight lang="lua">
bool executeSQLDelete ( string table, string conditions )
bool executeSQLDelete ( string tableName, string conditions )
</syntaxhighlight>  
</syntaxhighlight>  


===Required Arguments===  
===Required Arguments===  
*'''table:''' The name of the table you want to modify.
*'''tableName:''' The name of the table you want to modify.
*'''conditions:''' The conditions that need to be met before a row is deleted.
*'''conditions:''' The conditions that need to be met before a row is deleted.



Revision as of 12:25, 21 August 2007

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

The SQLite database contains globally stored data and can be used by scripts to store and retrieve data in a structured manner.

The executed SQL query is the following:

[sql]DELETE FROM <table> WHERE <conditions>

Syntax

bool executeSQLDelete ( string tableName, string conditions )

Required Arguments

  • tableName: The name of the table you want to modify.
  • conditions: The conditions that need to be met before a row is deleted.

Returns

The function returns a boolean which is true on success, and false on failure.

See Also