Re: ms sql null values

John
I am using an IBQuery to insert values into a ms sql table. If I have a
float value of 0, I want the field value to be null.
InJoistMasterQ is an IBQuery component

Aaron

"John Herbster" <herb-sci1_at_sbcglobal.net> wrote in message
news:44b7d9c9$1@xxxxxxxxxxxxxxxxxxxxxxxxx

"Aaron Masser" <amasser@xxxxxxxxxxxxx> wrote

Does anyone know how I can send a null value into an
MS SQL database table from Delphi 7.
I am using the following line of code
InjoistmasterQ.params[0].asfloat := 0;

Aaron,

Are you preparing to do a query with the above line?


What kind of component is InjoistmasterQ?

I do not want 0 to show in the table.

Show or contain? TDataSets don't show. Only graphic controls show.

I want the value to be null, but
if I try
InjoistmasterQ.params[0].isnull
then I get "Could not covert variant of type (Null) into type
(Double).

Do you mean to use Params or Fields?

I think that it would help, if you were to show more code.

Regards, JohnH



.