Previous Next Contents


Data Model Editor

The data model editor allows you to create a data model and add or remove tables.

Related Topics
Specify Base Name and Location
Description
Decide what to name the data model and specify the directory where it is stored.

 Properties
Field
Value
Example
Name
Name of the data model.
Simple1
Directory
Directory in which to store the data model.
C:\nab\apps\HelloWld\

Related Topic
Calculation Properties
Description
Generate new values based on existing values from the database.

 Properties
Field
Value
Example
Column Name
Name of the calculated field.
Calc1
Type
The calculation type.
DATATYPE_DOUBLE
Calculation
The calculation formula to assign to this field.
6*3
AVG
Add a function to compute the average value of specified items.
avg()
COUNT
Add a function to compute the total number of specified items.
count(*)
MAX
Add a function to compute the sum of all specified values.
max()
MIN
Add a function to compute the maximum value of specified items.
min()
SUM
Add a function to compute the sum of specified items.
sum()
+
Add an addition operator.
+
-
Add a subtraction operator.
-
*
Add a multiplication operator.
*
/
Add a division operator.
/
(
Add an opening parenthetic delimiter.
(
)
Add a closing parenthetic delimiter.
)
Select Column Name to Insert
Table columns to add to the calculation.
table1.column1

Related Topic
Select Connection
Description
Decide to create a new connection to the database or use an existing connection.

 Properties
Field
Value
Create a new connection
Connect to the database using a new connection.
Use an exisiting connection
Select a database connection from the drop-down list of all existing connections.

Related Topic
Insert Tables
Description
Add a table to the data model.

 Properties
Field
Value
Example
Driver
Database driver type.
ODBC
Data Sources
Name of the data source.
DataSource
Database Name
Name of the database you are connecting to.
DBName
User name
User ID required by the data source.
nsample
Password
User password required by the data source.
nsample

Related Topic
Add Tables to Data Model
Description
Choose the database tables to add to the data model.

 Properties
Field
Value
Available Tables
One or more table names to add to the data model.
Tables in Data Model
Tables to add to the data model.
>
Move a selected table name to the Tables in Data Model column.
<
Remove a selected table name from the Tables in Data Model column.
<<
Remove all table names from the Tables in Data Model column.
>>
Move all tables names to the Tables in Data Model column.

Related Topics
 

© Copyright 1999 Netscape Communications Corp.