Kbase P114695: Can SQL queries be executed from the 4GL Procedure Editor ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/29/2006 |
|
Status: Unverified
GOAL:
Can SQL queries be executed from the 4GL Procedure Editor ?
GOAL:
Can 4GL execute SELECT statements ?
FACT(s) (Environment):
Can 4GL execute SQL queries ?
Progress 9.1x
OpenEdge 10.0x
FIX:
You can run SELECT queries from 4GL, but you have to keep in mind that it only supports SQL-89 syntax. So anything specific to SQL-92 will not work. Another problem is that SQL-89 has been deprecated in OpenEdge, so running SQL queries in 4GL is not recommended anymore.