Home >	Contents >	Index >

AssetMaker   |    Cart Tags   |    Errors   |    Miscellany   |    Index

STORAGE

This tag defines the data type of the column being defined for the property. A STORAGE statement is nested within a set of PROPERTY tags.

Syntax

<STORAGE 
TYPE="datatype" 
[LENGTH="length"]/>

Parameters

TYPE (required)

The data type of the column that this PROPERTY statement defines. You can specify any of the following data types: CHAR, VARCHAR, LONGVARCHAR, BINARY, SMALLINT, INTEGER, BIGINT, DOUBLE, TIMESTAMP.

These data types are defined by the following Sites database properties located in the futuretense.ini file:

Type (generic ODBC/JDBC data type)	Property
CHAR	cc.char
VARCHAR	cc.varchar
LONGVARCHAR	cc.bigtext
BINARY	cc.blob
SMALLINT	cc.smallint
INTEGER	cc.integer
BIGINT	cc.bigint
DOUBLE	cc.double
TIMESTAMP	cc.datetime

 

LENGTH (required if TYPE="VARCHAR")

The length of the field. Only applicable if the type is either VARCHAR or CHAR and required if the type is VARCHAR.

Examples

This defines an asset property using CHAR storage

<PROPERTY NAME="newuser" DESCRIPTION="New User">
   <STORAGE TYPE="CHAR" LENGTH="2"/>
   <INPUTFORM TYPE="TEXT" WIDTH="1" MAXLENGTH="1" INSTRUCTION="T or F"/>
   <SEARCHFORM DESCRIPTION="New User is" TYPE="TEXT" WIDTH="3" MAXLENGTH="3"/>
</PROPERTY>

This defines an asset property with VARCHAR storage.

<PROPERTY NAME="address" DESCRIPTION="Address">
   <STORAGE TYPE="VARCHAR" LENGTH="24"/>
   <INPUTFORM TYPE="TEXT" WIDTH="24" MAXLENGTH="24" />
   <SEARCHFORM DESCRIPTION="Address is" TYPE="TEXT" WIDTH="24" MAXLENGTH="24"/>
</PROPERTY>

This defines an asset property with LONGVARCHAR (clob) storage.

<PROPERTY NAME="description" DESCRIPTION="Description">
   <STORAGE TYPE="LONGVARCHAR" LENGTH="5000"/>
   <INPUTFORM TYPE="TEXTAREA" ROWS="8" COLS="48" REQUIRED="NO" DEFAULT="Provide full description here." />
</PROPERTY>

This defines an asset property with BINARY (blob) storage.

<PROPERTY NAME="document" DESCRIPTION="Document">
   <STORAGE TYPE="BINARY"/>
   <INPUTFORM TYPE="UPLOAD" WIDTH="24" MAXLENGTH="64" MIMETYPE="application/msword" LINKTEXT="Edit with Microsoft Word" />
</PROPERTY>

This defines an asset property with SMALLINT storage.

<PROPERTY NAME="bedrooms" DESCRIPTION="No. Bedrooms">
   <STORAGE TYPE="SMALLINT" LENGTH="1"/>
   <INPUTFORM TYPE="TEXT" WIDTH="1" MAXLENGTH="1" />
   <SEARCHFORM DESCRIPTION="No. Bedrooms is" TYPE="TEXT" WIDTH="1" MAXLENGTH="1"/>
</PROPERTY>

This defines an asset property with INTEGER storage.

<PROPERTY NAME="rooms" DESCRIPTION="No. Rooms">
   <STORAGE TYPE="INTEGER" LENGTH="5"/>
   <INPUTFORM TYPE="TEXT" WIDTH="5" MAXLENGTH="5" />
   <SEARCHFORM DESCRIPTION="No. Rooms is" TYPE="TEXT" WIDTH="1" MAXLENGTH="5"/>
</PROPERTY>

This defines an asset property with BIGINT storage.

<PROPERTY NAME="empid" DESCRIPTION="Employee Id">
   <STORAGE TYPE="BIGINT" LENGTH="32"/>
   <INPUTFORM TYPE="TEXT" WIDTH="16" MAXLENGTH="32" />
   <SEARCHFORM DESCRIPTION="Employee Id is" TYPE="TEXT" WIDTH="16" MAXLENGTH="32"/>
</PROPERTY>

This defines an asset property with DOUBLE storage.

<PROPERTY NAME="sqfootage" DESCRIPTION="Square Footage">
   <STORAGE TYPE="DOUBLE" LENGTH="64"/>
   <INPUTFORM TYPE="TEXT" WIDTH="16" MAXLENGTH="64" />
</PROPERTY>

This defines an asset property with TIMESTAMP storage.

<PROPERTY NAME="purchasedate" DESCRIPTION="Purchase Date">
   <STORAGE TYPE="TIMESTAMP"/>
   <INPUTFORM TYPE="TEXT" WIDTH="16" MAXLENGTH="64" />
</PROPERTY>

		Home >	Contents >	Index >
	Oracle Miscellaneous Reference Copyright (c) 2013, 2019, Oracle and/or its affiliates. All rights reserved.