🚀 go-pugleaf

I must be missing something but OleVariant(VT_NULL) is not assignable to:

mADOStoredProc->Parameters->ParamByName("@DtConfirmed")->Value

I'm assuming that is what you meant by your reply.  Does the parameter need to be defined as DateTime or String or some other type in order for this to occur.  I tried Variant(VT_NULL) but this gave the same erroneous results for the date.

Leonard Moss

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote:
>NULL is integer with value 0 in C++. You should set OleVariant with type 
>VT_NULL.
>
>
>"Fridgerator" <lmoss@srcpmw.com> �������/�������� � �������� ���������: 
>news:4207da7b$1@newsgroups.borland.com...
>>
>> 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'
>>
>> If I change the above create parameter statement to:
>>
>> mADOStoredProc->Parameters->CreateParameter("@DtConfirmed", ftString, 
>> pdInput, 50, NULL);
>>
>> and assign it to:
>>
>> mADOStoredProc->Parameters->ParamByName("@DtConfirmed")->Value = "";
>>
>> Execute the stored proc the value for this field is now the sql default 
>> date:
>> '1900/01/01'
>>
>> What I really want is for this parameter to set to NULL in the table.  Is 
>> there anyway to pass this via a stored procedure parameter so that the 
>> value in the table is NULL.  I have tried varied attemps to pass NULL and 
>> other things but short of modifying the stored proc to look to see if the 
>> value is some default date and explicitly writing setting the field to 
>> NULL I cannot figure out how this can be done programtically.
>>
>> Any help would be appreciated.
>>
>> Leonard Moss
>> lmoss@srcpmw.com
>>
>> 
>
>