🚀 go-pugleaf

Try something like this, with m_pStp a pointer to a TADOStoredProc object
and m_pTbl a pointer to a TADOTable object :

m_pStp->Parameters->CreateParameter("paramTaxid", ftString, pdInput,
                                          20, NULL );

m_pStp->Parameters->Items[1]->Value =
        m_pTbl->FieldByName("Taxid")->AsString;

Note: The documentation states that when NULL is passed the size (i.e. 20)
must be greater than zero....
cristof wrote in message <3acb4eef_1@dnews>...
>Hi all !
>
>I'm looking for passing a null parameter to a stored proc, using ADO in
BCB4
>with a SQL Server database.
>I'm using a connection object, and then a command object, and then
parameter
>objects, but when i call the execute command and one of my params is null,
i
>does'nt work.
>What properties should i define in my Parameter object ?
>Thx if you have an idea or an example.
>
>