Date DBParm parameter for ODBC interface
When you create a profile to access a data source through
the ODBC interface, the syntax for setting the Date DBParm parameter
in the development environment has been simplified in Version 6
and later versions. (The syntax for setting Date in a PowerBuilder
application script is unchanged.)
To set a value for Date, specify the following value in the
Date Format box on the Syntax tab in the Database Profile Setup
– ODBC dialog box:
|
1 |
<span>date_format</span> |
where date_format is the date
format you want PowerBuilder or InfoMaker to use when it builds
a SQL UPDATE statement to update a data source. For example:
|
1 |
yyyy-mm-dd |
PowerBuilder or InfoMaker generates the correct ODBC syntax
for Date and saves your setting in the initialization file as follows:
|
1 |
DBParm=Connectstring='DSN=PB Demo DB V2021',Date=' '''yyyy-mm-dd''' ' |
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest