Kbase 15864: How to select the working database from within the 4GL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
How to select the working database from within the 4GL
In order to use metaschema files, many customers would like to
select the working database from within the 4GL and not the Dictionary
The point here is that the Dictionary only works with one database
at a time, even if more than one database is connected. That
database has the "DICTDB" logical name or alias.
So, the statement to use to select a working database from the
4gl is the following:
CREATE ALIAS DICTDB FOR DATABASE my_db.
Where my_db is the logical name of my database.
This statement must be run in a separate procedure than the procedure
which will actually access the metaschema files.
For more, see the Progress Language Ref. (CREATE ALIAS statement).
A related example can be found in the following knowledgebase entry:
16499 Example using CREATE ALIAS to re-use code for 2 databases
Progress Software Technical Support Note # 15864