When you update data in the DataWindow painter, DataWindow Designer builds a SQL UPDATE statement in the background. The Time parameter determines how DataWindow Designer specifies a time datatype when it builds the SQL UPDATE statement.
ADO.NET
OLE DB
TimeFormat ='time_format'
Parameter |
Description |
|---|---|
time_format |
The time format you want DataWindow Designer 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 User’s Guide. |
If no value is specified for the TimeFormat parameter, DataWindow Designer does not use a time datatype.
When you call stored procedures, the database server might not accept the time format built by DataWindow Designer. If this occurs, you can try to use another format. For example, for Microsoft SQL Server, try this format:
TimeFormat='\''hh:mm:ss\'''
Assume you are updating a table named Workhours by setting the Start column to 08:30. This time is represented by the following DataWindow Designer time format:
hh:mm
To specify that DataWindow Designer 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 tab in the Database Profile Setup dialog box:
hh:mm
Application Type the following in code:
SQLCA.DbParameter = "TimeFormat='hh:mm'"
What happens DataWindow Designer builds the following SQL UPDATE statement to update the table:
UPDATE WORKHOURS
SET START = '08:30'
