Default value for Not Null Timestamp field if lookup fails?

[bandish]

Hi,

I need to know if there is any default value defined for a NOT NULL timestamp field when lookup fails. I get ************ when lookup fails for a Not Null Timestamp field.

For example: For a NOT NULL integer field default value is 0 if lookup fails.
Similarly,
If we are fetching a NOT NULL timestamp field from a reference table by performing lookup. What will be the default value for that timestamp field if lookup fails?

How do we handle it?

Thanks
Bandish

[ray.wurlod]

Welcome aboard. :D

This is not the first time this question has been asked, so it has been answered previously. Search the forum before posting questions; you will often get an answer faster than awaiting a reply.