Re: ms sql null values


"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


.

Relevant Pages

  • Re: SQL vs. Access
    ... I can't say I know the rules in depth, but typically if you are using /linked/ tables in Access and you're not using a "pass-through" type query, then Access could be reading all the data it "thinks" is necessary to do the necessary joining/filtering, which may require a lot of data to pass between our SQL database and Access, which could I assume lead to behaviour which either looks like a hang or is a hang. ... Security. ... plain text logon/password information into your Word file or a .odc file. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Autonumber needed in form when new record opens
    ... > frustrating. ... >>> SQL database with Access Project ... can you update records in it? ... >> query? ...
    (microsoft.public.access.modulesdaovba)
  • Re: PDO Prepared Statements and WHERE .. IN
    ... feed the query a variable amount of parameters. ... I could inject the ... question marks into the query before preparing it. ...
    (comp.lang.php)
  • Re: Autonumber needed in form when new record opens
    ... >> SQL database with Access Project ... > query, can you update records in that query? ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Next vresion reporting
    ... consolidated updates available and many issues addressed... ... you can still use active data connectors to get data directly from Delphi ... > I'm totally amazed to see demand for Crystal Reports. ... > have to start over just to change the original query (and it deletes all ...
    (borland.public.delphi.non-technical)