Devart Forums

Posted: **Mon 21 Nov 2016 13:22**

Hi.

How to insert NULL as parameter for TMSSQL ?

For example I have code like that :

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

Posted: **Tue 22 Nov 2016 10:14**

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;
}

Posted: **Tue 22 Nov 2016 10:29**

In Delphi also works great,thank you

Posted: **Wed 23 Nov 2016 09:26**

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.

Devart Forums

Inserting NULL

Inserting NULL

Re: Inserting NULL

Re: Inserting NULL

Re: Inserting NULL