Null AnsiString Parametre in IBStoredProc

[Giò]

Hi,
I have these statements:

AnsiString Name;
....
IBStoredProc->StoredProcName = "MyProc";
IBStoredProc->Prepare();
IBStoredProc->ParamByName("ROOM")->AsString = Name
IBStoredProc->ExecProc();

When Name is a null String I would like the field to be NULL.
There is a way to di this without modify oricedure inside Dartabase?

[Jeff Overcash (TeamB)]

Post by Giò
Hi,
AnsiString Name;
....
IBStoredProc->StoredProcName = "MyProc";
IBStoredProc->Prepare();
IBStoredProc->ParamByName("ROOM")->AsString = Name
IBStoredProc->ExecProc();
When Name is a null String I would like the field to be NULL.
There is a way to di this without modify oricedure inside Dartabase?

There is no such thing as a NULL string. There is the empty string, but NULL is
the absence of any value, the empty string is a string of length 0. They are
totally different things. You need to call Clear on the parameter and the set
bound = true. Look at the TParam.Clear online help.