When you update data in the DataWindow painter, PowerBuilder builds a SQL UPDATE statement in the background. The Time parameter determines how PowerBuilder specifies a time datatype when it builds the SQL UPDATE statement.
JDB JDBC
ODBC
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g
The syntax you use to specify the Time 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 time format.
In code, you must use the following syntax:
JDBC and ODBC syntax PowerBuilder parses the backslash followed by two single quotes (\'') as a single quote when it builds the SQL UPDATE statement:
Time=' \''time_format\'' '
Oracle syntax PowerBuilder parses each set of four consecutive single quotes ('''') as a single quote when it builds the SQL UPDATE statement:
Time=' ''''time_format'''' '
The default value for Time depends on the DBMS you are accessing:
DBMS |
Date default value |
---|---|
JDBC |
If no value is specified for the Time parameter, PowerBuilder looks for a time format in the section for your JDBC driver in the registry. If no time format is found in the registry, PowerBuilder uses the JDBC time format escape sequence. |
ODBC |
If no value is specified for the Time parameter, PowerBuilder looks for a time format in the section for your ODBC driver in the PBODB125 initialization file. If no time format is found in the PBODB125 initialization file, PowerBuilder uses the ODBC time format escape sequence. |
Oracle |
The default Oracle date format. For information, see your Oracle documentation. |
Assume you are updating a table named Workhours by setting the Start column to 08:30. This time is represented by the following PowerBuilder time format:
hh:mm
To specify that PowerBuilder should use this format for the time datatype when it builds the SQL UPDATE statement:
Database profile Type the following in the Time Format box on the Syntax page in the Database Profile Setup dialog box:
hh:mm
Application Type the following in code:
SQLCA.DBParm="Time=' \''hh:mm\'' '"
What happens PowerBuilder builds the following SQL UPDATE statement to update the table:
UPDATE WORKHOURS
SET START='08:30'
To specify that PowerBuilder should use this format for the time datatype when it builds the SQL UPDATE statement:
Database profile Type hh:mm
in the Time
Format box on the Syntax page in the Database Profile Setup dialog
box.
Application Type the following in code:
SQLCA.DBParm="Time=' ''''hh:mm'''' '"
What happens PowerBuilder builds the following SQL UPDATE statement to update the table:
UPDATE WORKHOURS
SET START='08:30'