Subject Inserting a NULL value in a column
Author David Husarik
I am using Delphi Professional 4.0 with update pack 3
and IB Objects version 4.2Gc. In a parameterized
stored procedure, how do I insert a null value into a
field that can accept a null value. Would the folowing
code chunk do the trick.

if (locAddr = '') then
begin
parameterByName('LOC_ADDRESS').isNull;
end
else
begin
parameterByName('LOC_ADDRESS').asString := locAddr;
end;

Thanks in Advance,
David C. Husarik


__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com