Squirrel/Server/Functions/SQLite/sqlite free

Latest revision as of 17:04, 25 October 2010

This function frees a previously used query struct. This function should always be used after the query result has been processed to avoid any memory leaks.

[edit] Syntax

bool sqlite_free( UserPointer result )

[edit] Arguments

• result - This is a pointer to a result struct retrieved from sqlite_query or sqlite_next_row

[edit] Example

This will free the carried out query from the memory when 'free' is type into the server console.

 
function onScriptLoad()
{
	LoadModule( "lu_sqlite" );
	pSQDatabase <- sqlite_open( "database.sqlite" );
	
	return 1;
}
 
function onConsoleInput( szCommand, szText )
{
	if ( szCommand == "free" )
	{
		local query = sqlite_query( pSQDatabase, "SELECT Foo FROM Bar WHERE FooBar='" + szText + "'" );
		sqlite_free( query );
	}
	
	return 1;
}
 

[edit] Notes

The function LoadModule and sqlite_open and sqlite_query and event onScriptLoad and onConsoleInput were used in this example. More info about them in the corresponding pages.

For a larger example, check the SQLite database example from the wiki tutorials.

[edit] Related Functions

These functions are provided by the official module lu_sqlite.

• sqlite_close
• sqlite_column_count
• sqlite_column_data
• sqlite_free
• sqlite_next_row
• sqlite_open
• sqlite_query