>Hello Cetin !
>
>The field does accept nulls !
>
>But i found it by myself:
>if empty(mydate)
>l_enddate = NULL
>else
>l_enddate = ctod(mydate)
>endif
>
>Nevertheless thank you for your quick answer.
>
>Best regards
>Albert
I see. Note that if you use SQLPrepare(lnHandle,lcSQLCmd) you could prevent recompilation each time SQLExec called.
Cetin