Kbase P130777: How to insert an unknown value for date fields?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/22/2008 |
|
Status: Unverified
GOAL:
How to insert an unknown value for date fields?
GOAL:
Can I insert a NULL value via SQL92 client?
FACT(s) (Environment):
Windows
Unix
Progress 9.x
OpenEdge 10.x
FIX:
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.