When you update data in the Form painter, InfoMaker builds a SQL UPDATE statement in the background. The Time parameter determines how InfoMaker specifies a time datatype when it builds the SQL UPDATE statement.
OLE DB
SNC SQL Native Client for Microsoft SQL Server
TimeFormat ='time_format'
Parameter |
Description |
|---|---|
time_format |
The time 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 TimeFormat parameter, InfoMaker does not use a time datatype.
When you call stored procedures, the database server might not accept the time format built by InfoMaker. If this occurs, you can try to use another format. For example, for Microsoft SQL Server, try this format:
TimeFormat='\''hh:mm:ss\'''
SQL
SQL
Assume you are updating a table named Workhours by setting the Start column to 08:30. This time is represented by the following InfoMaker time format:
hh:mm
To specify that InfoMaker should use this format for the time
datatype when it builds the SQL UPDATE statement, type hh:mm in
the Time Format box on the Syntax page in the Database Profile Setup
dialog box.
What happens InfoMaker builds the following SQL UPDATE statement to update the table:
UPDATE WORKHOURS
SET START = '08:30'
