Insert DATE NULL from PHP to Prgress

[openedge2010]

As I can insert a null date (00/00/0000) Progress in PHP.

The date format is in progress 99/99/9999.
The SQL query in PHP: SQL: INSERT INTO PUB.table_name VALUES(...,'00/00/0000').
Requires date is null, but if indicated, 00/00/0000, 99/99/9999, null,
NULL tells me error:
DATEVALUE = 00/00/0000 o 99/99/9999 o NULL, is error.
The error that tells me is:
[DataDirect] [ODBC Progress OpenEdge Wire Protocol driver]
[OpenEdge] Invalid date value (7496)



thanks

 

[Stefan]

Progress Knowledge Base P130777 seems to indicate that you need to insert NULL

ID: P130777
Title: "How to insert an unknown value for date fields?"
Created: 04/22/2008 Last Modified: 04/22/2008
Status: Unverified


Goals:
How to insert an unknown value for date fields?
Can I insert a NULL value via SQL92 client?


Facts:
Windows
Unix
Progress 9.x
OpenEdge 10.x


Fixes:
The SQL92 syntax allows one to enter unknown values by using the keywork NULL.

Example: INSERT INTO PUB.order ( orderNum, shipDate ) VALUES ( '10-100', NULL ).

In this example the shipDate field is stored as an unknown (?) value.