Lucent Technologies CentreVu Report Designer, User Manual

Page: 239 / 266

SQL Query and CMS Database Table Basics CentreVu Report Designer Version 8 User Guide
Creating a Custom Data Table
18-17
Interval The Interval data type is not supported by CMS.
An interval column allows you to specify an
interval
qualifier of year, month, day, hour, or minute.
Money The Money data type is not supported by CMS.
If you data will be dollars and cents, you should use
Decimal.
2g. Select the type of data that
the field will store.
→
The additional prompts that
appear differ depending on
your selected data type.
2h. Complete the definition of
the column by responding to
the additional prompts that
appear. The prompts that
appear and the order in
which they appear in
depend on the data type you
selected The following table
lists the possible prompts.
→
When you have responded
to all of the prompts for the
column, a new highlighted
line appears in the table,
and the
Add Name
field
reappears at the top of the
screen.
2i. Repeat Steps 2f through 2h
for each column that you
want to add.
Prompt What to Do
PRECISION Select either
Smallfloat
or
Float
.
PRECISION
appears for the
Float
type.
INDEX Enter y if you want to make the column an index.
INDEX
appears for all types except
Serial
. A
column with the
Serial
data type automatically
becomes an index.
Make the column an index only if the column will
be used for row searches and the table will contain
more than 200 rows of data.