ADO Connection & Recordset Functions
Examples to the code below:
Set cn = OpenCn("db1")
Opens a connection to the "db1" database.
Set rs = OpenRs(cn, "SELECT * FROM tblProducts;")
Opens a recordset. You need to set the connetion first.
Closes a recordset.
Closes a connection.
arr = GetArrayAll("db1", "SELECT * FROM tblProducts;")
arr is an array containing the records from tblProducts.
arr = GetArrayPaged("db1", "SELECT * FROM tblProducts;", 20, 3, intPageTotal, intRecTotal)
arr is an array containing one specific page of the recordset. The values intPageTotal and intRecTotal will be set by the function and can be used later on to create a navigation.