Reading
values from an external file
Using external files
Often you want to set the Transaction object values from an
external file. For example, you might want to retrieve values from your
PowerBuilder initialization file when you are developing the application
or from an application-specific initialization file when you distribute
the application.
ProfileString function
You can use the PowerScript ProfileString function to retrieve
values from a text file that is structured into sections containing
variable assignments, like a Windows INI file. The PowerBuilder
initialization file is such a file, consisting of several sections
including PB, Application, and Database:
|
1 2 3 4 5 6 7 8 9 |
[PB] variables and their values ... [Application] variables and their values ... [Database] variables and their values ... |
The ProfileString function has this syntax:
|
1 |
ProfileString ( file, section, key, default ) |
Example
This script reads values from an initialization file to set the
Transaction object to connect to a database. Conditional code sets the
variable startupfile to the appropriate value for each platform:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
sqlca.DBMS = ProfileString(startupfile, "database",& "dbms", "") sqlca.database = ProfileString(startupfile,& "database", "database", "") sqlca.userid = ProfileString(startupfile, "database",& "userid", "") sqlca.dbpass = ProfileString(startupfile, "database",& "dbpass", "") sqlca.logid = ProfileString(startupfile, "database",& "logid", "") sqlca.logpass = ProfileString(startupfile, "database",& "LogPassWord","") sqlca.servername = ProfileString(startupfile,& "database", "servername","") sqlca.dbparm = ProfileString(startupfile, "database",& "dbparm", "") |