User Guide

100 Chapter 7: The Database API
Arguments
connName
• 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.
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.
Returns
Nothing. This function returns an error if the SQL statement or the connection string is invalid.
000_DW_API_Print.book Page 100 Wednesday, August 20, 2003 9:14 AM