Was this helpful?
Ingres Data Types
When you create a Vision frame based on an Ingres database table, the visual query and form contain fields that correspond to columns in the database table. These columns have data types that control the type of information that can be contained in the column and how Ingres handles that information. The names and data types of the fields are taken from the table's definition.
The following table lists the data types that Vision uses and the situations where they can be used:
Usage
Char
varchar
Small
int
integer
decimal
none
string
money
date
float
record
type
array
User frame return type
X
X
X
X
X
X
X
4GL proc return type
X
X
X
X
X
X
X
3GL proc return type
X
X
 
X
X
 
X
Database proc return type
 
X
 
X
 
 
 
Local proc return type
X
X
X
X
 
X
X
Local variables
X
X
X
 
 
X
X
X
Global variables
X
X
X
 
 
X
X
X
Record type attributes
X
X
X
 
X
X
X
X
Global constants
X
X
X
 
 
 
X
 
Vision supports the standard Ingres data types, with the exception of long varchar, long bit, byte, byte varying, and long byte. If a Vision frame is based on a table that has a column of one of those types, the column is not displayed or included in the visual query. The remaining columns in the table are displayed.
Last modified date: 01/30/2023