|
Function
|
Description
|
|
[Access.Open](filename)
|
Opens the access file to be read.
Parameter(s)
filename - The name of the source TIFF file.
|
|
[Access.Query](query, filename)
|
Executes the query (e.g. SELECT* FROM [Customers]) and returns a multi-dimensional array of results. The filename parameter is optional if the Access database is already opened by using the [Access.Open] function.
Parameter(s)
query - SQL based query.
filename - The name of the source Access file.
|
|
[Access.RowCount](filename, tablename)
|
Returns the number of rows in the specified table.
Parameter(s)
filename - The name of the source Access file.
tablename - The name Access table.
|
|
[Access.ColumnCount](filename, tablename)
|
Returns the number of columns in the specified table.
Parameter(s)
filename - The name of the source Access file.
tablename - The name Access table.
|
|
[Access.Close]()
|
Closes the currently opened access database file.
|
|
|
|
|
[ODBC.Open](connectionstring)
|
ODBC database connection using the connection string. Eg. “dsn=….;Uid=….;Pwd=…”.
Parameter(s)
connectionstring - The database connection.
|
|
[ODBC.Query](query, connectionstring)
|
Executes the query (eg. SELECT * FROM Customers) and returns a multi-dimensional array of results. If the connection is already opened connectionstring is optional.
Parameter(s)
query - SQL based query.
connectionstring - The database connection.
|
|
[ODBC.Close]()
|
Closes the currently opened ODBC database connection.
|
|
|
|
|
[SQL.Open](connectionstring)
|
Opens an SQL server database connection using the connection string. Eg. “datasource=….;User=….;Password=…..;IntialCatalog=….”.
Parameter(s)
connectionstring - The database connection.
|
|
[SQL.Query](query, connectionstring)
|
Executes the query (eg. SELECT * FROM Customers) and returns a multi-dimensional array of results. If the connection is already opened connectionstring is optional.
Parameter(s)
query - SQL based query.
connectionstring - The database connection.
|
|
[SQL.Close]()
|
Closes the currently opened SQL server database connection.
|