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
Содержание DREAMWEAVER MX 2004-DREAMWEAVER API
Страница 1: ...Dreamweaver API Reference...
Страница 24: ...24 Contents...
Страница 32: ......
Страница 70: ...70 Chapter 5 Fireworks Integration...
Страница 76: ...76 Chapter 6 Flash Integration...
Страница 116: ...116 Chapter 9 The JavaBeans API...
Страница 140: ......
Страница 152: ...152 Chapter 11 Application...
Страница 218: ...218 Chapter 12 Workspace...
Страница 248: ...248 Chapter 13 Site...
Страница 292: ...292 Chapter 14 Document...
Страница 378: ...378 Chapter 17 Design...
Страница 430: ...430 Chapter 18 Code...
Страница 486: ...486 Index...