User Guide

Database access functions 97
Returns
An array of view objects where each object has three properties: catalog, schema, and view.
Use
catalog or schema to restrict or filter the number of views that pertain to an individual
schema name or catalog name that is defined as part of the connection information.
Example
The following example returns the views for a given connection value,
CONN_LIST.getValue():
var viewObjects = MMDB.getViews(CONN_LIST.getValue())
for (i = 0; i < viewObjects.length; i++)
{
thisView = viewObjects[i]
thisSchema = Trim(thisView.schema)
if (thisSchema.length == 0)
{
thisSchema = Trim(thisView.catalog)
}
if (thisSchema.length > 0)
{
thisSchema += "."
}
views.push(String(thisSchema + thisView.view))
}
MMDB.showResultset()
Availability
Dreamweaver UltraDev 1.
Description
This function displays a dialog box that contains the results of executing the specified SQL
statement.The dialog box displays a tabular grid in which the header provides column
information that describes the result set. If the connection string or the SQL statement is
invalid, an error appears. This function validates the SQL statement.
Arguments
connName, SQLstatement
■ The connName argument is a connection name that is specified in the Connection
Manager. It identifies the connection string that Dreamweaver should use to make a
database connection to a live data source.
■ The SQLstatement argument is the SQL SELECT statement.
000_DW_API_Print.book Page 97 Wednesday, July 20, 2005 11:58 AM