Date

Description

When you update data in the Form painter, InfoMaker builds a SQL UPDATE statement in the background. The Date parameter determines how InfoMaker specifies a date datatype when it builds the SQL UPDATE statement.

Applies to

• JDB JDBC

• ODBC

• O90 Oracle9i

• O10 Oracle 10g

• ORA Oracle 11g

Syntax

The syntax you use to specify the Date 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 date format.

Date=' \''date_format\'' '

Date=' ''''date_format'''' '

Default

The default value for Date depends on the DBMS you are accessing, as summarized in the following table:

Examples

Assume you are updating a table named Employee by setting the Startdate column to 2006-04-23. This date is represented by the following 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'

Example 3

yyyy-mm-dd

What happens InfoMaker builds the following SQL UPDATE statement to update the table:

UPDATE EMPLOYEE

SET STARTDATE = '2006-04-23'

See also