Squirrel/Server/Functions/SQLite/sqlite open

Latest revision as of 16:58, 26 October 2010

This function opens an SQLite database or creates a new one.

[edit] Syntax

UserPointer sqlite_open( string filename )

[edit] Arguments

• filename - This is the filename of the previously saved database or filename for the new database

[edit] Example

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

[edit] Example 2.

This example shows how to open to a database with a single command. The command loads a previously saved database from 'database.db', or if the file doesn't exist, creates a new database.

 
function onConsoleInput( cmd, text )
{
     if ( cmd == "connectsql" )
     {
          local db = sqlite_open( "database.db" );
          
          print( "Opening an SQLite database..." );
     }
     
     return 1;
}
 

[edit] Notes

The call onConsoleInput was used in in this example. More info about it in corresponding page.

[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