Subject | Inserting a NULL value in a column |
---|---|
Author | David Husarik |
Post date | 2002-09-08T21:40:02Z |
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
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