Set Zero when field is Null Value.

From: Nelson Chui (tychui_at_netscape.net)
Date: 12/26/04

  • Next message: Andrew Ryazanov: "Re: Set Zero when field is Null Value." 
    Date: Sun, 26 Dec 2004 12:25:09 +0800

    Hi,

    I have a D6 program to generate join-SQL (LEFT JOIN) statement at the
    run-time. Some fields returned from joined table may be NULL value.

    Database : MS Access XP

    I tried use NZ(field_1, 0) in MS Access Environment that is OK, but I
    code the SQL statement with NZ function in Delphi but raise an error
    message ( ... Undefined function NZ ... ) at the run-time.

    Which function can I use in Delphi 6 for fixing the above problem ?

    Regards,
    Nelson.

  • Next message: Andrew Ryazanov: "Re: Set Zero when field is Null Value."

    Relevant Pages

    • Re: Delphi Jobs
      ... I am a Delphi database programmer. ... Source Safe and Source Off Site on the server side and client side. ... design several pieces for the interactive website. ...
      (comp.lang.pascal.delphi.misc)
    • Re: Embarcaderos Director of Products Blog
      ... What indications were there that it was difficult to sell, ... but Delphi has ALWAYS been about database development. ... All of which DO make perfect sense and could be seen as having a home at ...
      (borland.public.delphi.non-technical)
    • Software specifications
      ... I have been frustrated in this project because my software and hardware is ... another programmer who has been my mentor in Delphi, ... me when it will be ready, as they are struggling with old MSDOS software ... could do the entire database project myself, ...
      (comp.lang.pascal.delphi.misc)
    • Database Landscape for future Delphi work.
      ... I'm a died-in-the-wool Delphi fan, and have been programming in Delphi since ... So I switched my database to Jet 4.0 and to using ADO via Delphi's ... Good support for syncing w/ SQL Server. ...
      (borland.public.delphi.non-technical)
    • Re: acucobol
      ... J have not any experience with cobol ... If there is something who let me to acces to this db with delphi j have solved the problem ... Do you in fact need to learn COBOL at all, or are you just interested in getting data from the DataBase to be used with another language. ... If that's the case, dependent upon the DB used in the AcuCOBOL application you should be able to EXPORT the data, and IMPORT the data into the Delphi DB - that might be your solution. ...
      (comp.lang.cobol)