🚀 go-pugleaf

"Fridgerator" <lmoss@srcpmw.com> wrote:

>
>Environment:
>
>C++ Builder 6
>MS SQL Server
>Table Column allows null.
>
>Using TADOStoredProc
>
>I create a parameter:
>
>mADOStoredProc->Parameters->CreateParameter("@DtConfirmed", ftDateTime, pdInput, 8, NULL);
>
>I assign a NULL value
>
>mADOStoredProc->Parameters->ParamByName("@DtConfirmed")->Value = NULL;
>
>When I execute the stored procedure it is successful.  The problem lies in the fact that the field I want to be NULL now contains a default date.
>'1899/12/30'

According to the help, this is one way:

Variant vNull;
vNull.ChangeType(varNull);
mADOStoredProc->Parameters->ParamByName("@DtConfirmed")->Value=vNull;

Also, how do you know the parameter is not set to NULL as expected?

Do you receive "1899/12/30" back from TField() or do you see that in
your database query tool?

Remember, if the column is NULL, TField() will give you back a date
value of zero, which will show as "1899/12/30".