To meet your needs, we constantly work to improve Querix products.
This means that Lycia documentation is developing as well.
In case you have found a certain dissonance between the provided information and the actual behavior of Lycia 3 and/or your applications, please, let us know about this via documentation@querix.com so that we can introduce the necessary changes to our documentation.
Thank you for your attention and cooperation.
Use the DATABASE statement to open the database which will become the default database and the current database.
|
Element |
Description |
|
Database Name |
The name of the database |
|
Server |
The name of the host system where database resides. |
|
Variable |
A variable that contains the database specification |
The DATABASE statement is required, if your 4GL program references a database at least once. This statement can be used in two ways:
You can specify the current database during the runtime so that the statements could access the data in the database at runtime.
You can specify the default database which will be opened automatically when the program is run and which will be used during compilation (it also allows the INITIALIZE and VALIDATE statements to access syscolatt or syscolval)
DATABASE statement should be used if the application intends to connect to one database at a time. For setting multiple database connections see the CONNECT TO statement description.
Unlike SQL statements, DATABASE statement can include variables of the STRING datatype.
Related articles: