EOEC_NO_REC_VW2

(SQL View)
Index Back

View 2 that returns no rows

Work record that never has rows. Used to act in a main record in a grid that contains nothing but derived record fields because the grid has to have at least one record view field.

SELECT COUNTRY FROM %Table(INSTALLATION) WHERE 1=2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Default Value: USA

Prompt Table: COUNTRY_TBL