When you update data in the Form painter, InfoMaker builds a SQL UPDATE statement in the background. The DateTimeFormat parameter determines how InfoMaker specifies a DateTime datatype when it builds the SQL UPDATE statement. (A DateTime datatype contains both a date value and a time value.)
OLE DB
SNC SQL Native Client for Microsoft SQL Server
DateTimeFormat='datetime_format '
Parameter |
Description |
|---|---|
datetime_format |
The datetime format you want InfoMaker to use when it builds a SQL UPDATE statement to update a data source in the Form painter. For more on display formats, see the Users Guide. |
If no value is specified for the DateTimeFormat parameter, InfoMaker does not use a datetime datatype.
When you call stored procedures, the database server might not accept the DateTime format built by InfoMaker. If this occurs, you can try to use another format. For example, for Microsoft SQL Server, try this format:
DateTimeFormat='\''yyyy-mm-dd hh:mm:ss.fff\'''
PowerBuilder parses the backslash followed by two single quotes (\'') as a single quote.
Assume you are updating a table named Files by setting the Timestamp column to 4/2/03 3:45 pm. This DateTime is represented by the following DateTime format.
To specify that InfoMaker should use this format for the DateTime datatype when it builds the SQL UPDATE statement, type the following in the DateTime Format box on the Syntax page in the Database Profile Setup dialog box:
m/d/yy h:mm am/pm
What happens InfoMaker builds the following SQL UPDATE statement to update the table:
UPDATE FILES
SET TIMESTAMP = '4/2/03 3:45 pm'
