File fhSQL.lua

Functions

close (dbconection, dbconnection) Close db connection.
connect (connection_string) Connect to any ADO compliant database See connectionstrings.com for information on string format for different databases.
connectSQLite (sFilename) Connect to a SQLite3 database file, the database file will be created if it does not exist when opened.
execute (dbconection, statement) Executes provided SQL statement Any SQL statement can be used and the database recordset value will contain the result from the statement.
fetch (resultset, dbconnection) Used to get a single row from a resultset, this is used where only a single row is needed if multiple rows are needed use the rows function.
rows (resultset, dbconnection) Used to iterate through result sets.
select (dbconection, statement) Creates a result set based on the passed select statement.


Functions

close (dbconection, dbconnection)
Close db connection.

Parameters:

  • dbconection:
  • dbconnection: Connection to close
connect (connection_string)
Connect to any ADO compliant database See connectionstrings.com for information on string format for different databases. Read more

Parameters:

  • connection_string: connection string for database to use.

Return value:

    fhSQL Object - Object to use to run SQL statements against the selected database.
connectSQLite (sFilename)
Connect to a SQLite3 database file, the database file will be created if it does not exist when opened.

Parameters:

  • sFilename: database file name

Return value:

    fhSQL Object - Object to use to run SQL statements against the selected database.
execute (dbconection, statement)
Executes provided SQL statement Any SQL statement can be used and the database recordset value will contain the result from the statement. It is recommended to use the select function when calling the select statement as this supports multiple concurrent resultsets, but the execute command does not.
db:execute("insert into mytable values ('George Bush', '123-4567')")

Parameters:

  • dbconection:
  • statement:
fetch (resultset, dbconnection)
Used to get a single row from a resultset, this is used where only a single row is needed if multiple rows are needed use the rows function.

Parameters:

  • resultset: result set from select call.
  • dbconnection: - connection

Return value:

    table table of fields
rows (resultset, dbconnection)
Used to iterate through result sets. Called on the returned result set from a select function. It provides a simple interation function for example
local people = db:select("select * from test ")
for person in people:rows() do
print(tostring(person.name).."\t"..tostring(person.phone))
end

Parameters:

  • resultset: - result set to read
  • dbconnection: - connection

Return value:

    table - table of fields from the row keyed on field name
select (dbconection, statement)
Creates a result set based on the passed select statement. For example
local people = db:select("select * from test ")

Parameters:

  • dbconection:
  • statement:

Return value:

    resultSetObject, result set object which can be processed using the rows function.

Valid XHTML 1.0!