Inserting NULL

[bdkacz]

Hi.

How to insert NULL as parameter for TMSSQL ?

For example I have code like that :

Code: Select all

if (some if statement)  then
aqZapisz.ParamByName('p1').AsInteger := 1
else
aqZapisz.ParamByName('p1').Value := Variants.null

but I receive error that I need to use convert to insert nulll..
The column is defnded as int type with allow nulls

[asc]

In C++ works something like:

Code: Select all

void SetNullParam(
    TMSQuery * query,
    String const & parameterName,
    TFieldType parameterTyp)
{
    query->ParamByName(parameterName)->Clear();
    query->ParamByName(parameterName)->Bound = true;
    query->ParamByName(parameterName)->DataType = parameterTyp;
}

[bdkacz]

In Delphi also works great,thank you

[azyk]

Calling the Clear method and value setting to the DataType property to ftInteger for dataset parameter is a correct way to set a NULL value to the int parameter.