When you update data in the Form painter, InfoMaker builds a SQL UPDATE statement in the background. The DateFormat parameter determines how InfoMaker specifies a date datatype when it builds the SQL UPDATE statement.
OLE DB
SNC SQL Native Client for Microsoft SQL Server
DateFormat='date_format '
Parameter |
Description |
|---|---|
date_format |
The date 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 User’s Guide. |
If no value is specified for the DateFormat parameter, InfoMaker does not use a date datatype.
When you call stored procedures, the database server might not accept the date format built by InfoMaker. If this occurs, you can try to use another format. For example, for Microsoft SQL Server, try this format:
DateFormat='\''yyyy-mm-dd\'''
Assume you are updating a table named Employee by
setting the Startdate column to 2006-04-23. This date is represented
by the date format yyyy-mm-dd.
To specify that InfoMaker should use this format for the date datatype when it builds the SQL UPDATE statement, type the following in the Date Format box on the Syntax page in the Database Profile Setup dialog box:
yyyy-mm-dd
What happens InfoMaker builds the following SQL UPDATE statement to update the table:
UPDATE EMPLOYEE
SET STARTDATE = '2006-04-23'
