Kbase 15161: How to access extent fields from ESQL array elements
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
How to access extent fields from ESQL array elements
How to access an extent field from ESQL?
----------------------------------------
You can access an element of an extent field
from ESQL in the following manner in versions 6,7,8:
EXEC SQL BEGIN DECLARE SECTION;
float month;
EXEC SQL END DECLARE SECTION;
...
EXEC SQL DECLARE x CURSOR FOR select month\-quota[1] from salesrep;
EXEC SQL FETCH x into :month;
...
In version 7.3 and version 8 you can also use a variable for the
subscript of the extent. For example:
...
EXEC SQL DECLARE x CURSOR FOR select month\-quota[ :i ] from salesrep;
EXEC SQL FETCH x into :month;
...
Progress Software Technical Support Note # 15161