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.
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:
[PB]
variables and their values
...
[Application]
variables and their values
...
[Database]
variables and their values
...
The ProfileString function has this syntax:
ProfileString ( file, section, key, default )
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:
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", "")
