Adobe Dreamweaver API Reference CS5 - Manual (Page 80)

75 DREAMWEAVER API REFERENCE
The database API
Last updated 8/27/2013
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 objects where each object has three properties:
table , schema , and catalog . Table is the name of the
table. Schema is the name of the schema that contains the table. Catalog is the catalog that contains the table.
Example
The statement
MMDB.getTables ("EmpDB"); might produce an array of two objects. The first object’s properties
might be similar to the following example:
object1[table:"Employees", schema:"personnel", catalog:"syscat"]
The second object’s properties might be similar to the following example:
object2[table:"Departments", schema:"demo", catalog:"syscat2"]
MMDB.getViews()
Availability
Dreamweaver UltraDev 4.
Description
This function gets a list of all the views that are defined for the specified database. Each view object has
catalog ,
schema , and view properties.
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() :