Kbase P15649: Can I access data from a view using a FOR EACH statement ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Can I access data from a view using a FOR EACH statement ?
FIX:
What is a view:
A subset of rows and columns in one or more tables or two or more joined tables. Represented internally by a stored command, not stored data, a view can display data from one or more tables or from other views. The following SQL statements define and delete views: CREATE VIEW and DROP VIEW.
FOR EACH:
The FOR EACH statement moves data from the ?DATABASE? to the record buffer
Consequently it is not possible to do a FOR EACH on a VIEW