Kbase P116836: Can a string constant be selected without using a table name?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/19/2006 |
|
Status: Unverified
GOAL:
Can a string constant be selected without using a table name?
GOAL:
Is there a table which guarantees that only a single row will be returned?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
The SYSPROGRESS.SYSCALCTABLE table is guaranteed to return only a single row and is a read only table.
For example, to have a query which returns a constant string value you can do the following:
SELECT 'Some String Value' FROM SYSPROGRESS.SYSCALCTABLE