NumericFormat DBParm parameter for ODBC interface
When you create a profile to access a data source through
the ODBC interface, the syntax for setting the NumericFormat DBParm
parameter in the development environment has been simplified in
Version 6 and later versions. (The syntax for setting NumericFormat
in a PowerBuilder application script is unchanged.)
The NumericFormat syntax you use depends on the backend DBMS
you are accessing. For example, to set a value for NumericFormat
when accessing an Oracle ODBC data source, type the following value
in the NumericFormat box on the Syntax tab in the Database Profile
Setup – ODBC dialog box:
|
1 |
%s, %s |
PowerBuilder or InfoMaker generates the correct ODBC syntax
for NumericFormat and saves your setting in the initialization file
as follows:
|
1 |
DBParm=Connectstring='DSN=EAS Demo DB V3',NumericFormat='''%s, %s''' |
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest