Description
When you update data in the DataWindow painter, PowerBuilder builds a SQL UPDATE statement in the background. The Date parameter determines how PowerBuilder specifies a date datatype when it builds the SQL UPDATE statement.
Applies to
ODBC
O90 Oracle9i
O10 Oracle 10g
ORA Oracle (for 11g and later)
Syntax
The syntax you use to specify the Date parameter differs slightly depending on the database.
The Database Profile Setup dialog box inserts special characters (quotes and backslashes) where needed, so you can specify just the date format.
In a PowerBuilder application script, you must use the following syntax:
ODBC syntax
PowerBuilder parses the backslash followed by two single quotes (\'') as a single quote when it builds the SQL UPDATE statement.
Date=' \''date_format\'' '
Oracle syntax
PowerBuilder parses each set of four consecutive single quotes ('''') as a single quote when it builds the SQL UPDATE statement.
Date=' ''''date_format'''' '
|
Parameter |
Description |
|---|---|
|
' \''
' '''' |
ODBC syntax Type a single quote, followed by one space, followed by a backslash, followed by two single quotes. There is no space between the two single quotes and the beginning of the date format. Oracle syntax Type a single quote, followed by one space, followed by four single quotes. There is no space between the four single quotes and the beginning of the date format. |
|
date_format |
The date format you want PowerBuilder to use when it builds a SQL UPDATE statement to update a data source in the DataWindow painter. For more on display formats, see the the section called “Date display formats” in Users Guide. |
|
\'' '
'''' ' |
ODBC syntax Type a backslash, followed by two single quotes, followed by one space, followed by a single quote. There is no space between the end of the date format and the backslash. Oracle syntax Type four single quotes, followed by one space, followed by a single quote. There is no space between the end of the date format and the four single quotes. |
Default value
The default value for Date depends on the DBMS you are accessing, as summarized in the following table:
|
DBMS |
Date default value |
|---|---|
|
ODBC |
If no value is specified for the Date database parameter, PowerBuilder looks for a date format in the section for your ODBC driver in the PBODB initialization file. If no date format is found in the initialization file, PowerBuilder uses the ODBC date format escape sequence. |
|
Oracle |
The default Oracle date format. For information, see your Oracle documentation. |
Examples
About these examples
Assume you are updating a table named Employee by setting the Startdate column to 2006-04-23. This date is represented by the following date format:
yyyy-mm-dd
Example 1 (ODBC syntax)
To specify that PowerBuilder should use this format for the date datatype when it builds the SQL UPDATE statement:
-
Database profile
Type the following in the Date Format box on the Syntax page in the Database Profile Setup dialog box:
yyyy-mm-dd
-
Application
Type the following in code:
SQLCA.DBParm="Date=' \''yyyy-mm-dd\'' '"
What happens
PowerBuilder builds the following SQL UPDATE statement to update the table:
UPDATE EMPLOYEE SET STARTDATE='2006-04-23'
Example 2 (Oracle syntax)
To specify that PowerBuilder should use this format for the date datatype when it builds the SQL UPDATE statement:
-
Database profile
Type the following in the Date format box on the Syntax page in the Database Profile Setup dialog box:
yyyy-mm-dd
-
Application
Type the following in code:
SQLCA.DBParm="Date=' ''''yyyy-mm-dd'''' '"
What happens
PowerBuilder builds the following SQL UPDATE statement to update the table:
UPDATE EMPLOYEE SET STARTDATE='2006-04-23'
See also
