User Guide

Database access functions 99
Example
The code MMDB.getSPParamsAsString ("EmpDB","getNewEmployeesMakingAtLeast") can
return a string of form name
startDate;direction:in;datatype:date,
salary;direction:in;datatype:integer
.
In this example, the stored procedure,
getNewEmployeesMakingAtLeast, has two parameters:
startDate and Salary. For startDate, the direction is in and the data type is date. For
salary, the direction is in and the data type is date.
MMDB.getTables()
Availability
Dreamweaver UltraDev 1.
Description
This function gets a list of all the tables that are defined for the specified database. Each table
object has three properties:
table, schema, and catalog.
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.
000_DW_API_Print.book Page 99 Wednesday, August 20, 2003 9:14 AM