ms sql null values

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;

I do not want 0 to show in the table. 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).

I have tried
InjoistmasterQ.params[0].clear and get the same thing.

I have even tried creating a varaible and setting it equal to null and then
using that as my input value and that does not work.

Thanks
Aaron Masser



.

Relevant Pages

  • Re: Database Independance
    ... > writing a Delphi application and where you desire database independance ... > with SQL database. ...
    (borland.public.delphi.non-technical)
  • Re: ms sql null values
    ... MS SQL database table from Delphi 7. ... Are you preparing to do a query with the above line? ...
    (borland.public.delphi.database.ado)
  • Saving Image/Picture to Database using ADO
    ... Can someone help with loading a JPG image into an SQL database using Delphi ...
    (borland.public.delphi.database.ado)
  • Blob Data
    ... I am in need to stream TIF images into a MS SQL database. ... Delphi 7 and am more familiar with ADO then any of the other DB components ...
    (borland.public.delphi.database.ado)