>Hi,
>
>When using SQL Server and allowing NULL in empty dates I came across a small issue where EMPTY( date_field) returns .F. when the entry in date_field is NULL. And this of course breaks a lot of code where the program relied on the date field being empty. I am thinking of creating a simple function like this:
>
>Function MyEmpty
>lparameter tDate
>if empty( tDate) or isnull( tDate)
> return .T.
>else
> return .F.
>endif
>
>
>And replace everywhere in the program where I use
>
>if EMPTY( date_field )
>
>with
>
>if MyEmpty( date_field )
>
>
>Can anybody see a potential problem with the above approach? TIA.
IF EMPTY(nvl(datefield,{})).....
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"