Re: Nz Problem in ADO execute

Are you using Oracle to look at the initial value? Perhaps it looks
different, depending on which end you look from! (for some reason)

So personally, I would add a statement to display the existing value of
FINANCE, and of NZ(FINANCE,0), before I actually did the update. You
shpould also debug.print the sql string, just to make certain that it
is constructed the way you think it will be.

There are no problems with the NZ function AFAIK. It simply must be
something else.

HTH,
TC (MVP Access)
http://tc2.atspace.com

.

Relevant Pages

  • Problems connecting to Oracle DB on SLES
    ... Attempting to discover Oracle OCI build rules ... ORA-01756: quoted string not properly terminated (DBD ERROR: OCISessionBegin)) ... all skipped: no reason given ...
    (perl.dbi.users)
  • Re: Carbon, threads, and windows...
    ... Actually, CImgDisplay is declared as a struct (yes, I know that almost ... definitions, one of which is chosen, depending on preprocessor flags. ... to what I read- Cocoa can only be used by Objective-C applications. ... Cocoa applications run an Objective-C method, but there is no reason why ...
    (comp.sys.mac.programmer.help)
  • Re: Is OpenVMS certified yet for 64-way Hard partitions (GS1280 M64).
    ... Is OpenVMS certified yet for 64-way Hard ... Gee - I almost wonder if Oracle didn't sabotage the database so ... Absolutely no reason to do 8.2 vs 8.2-1, so I do not know what your ... Cerner refused to certify RAC. ...
    (comp.os.vms)
  • Re: Asynchronous Commit in Oracle Database 10g R2
    ... this running and the database goes down for some reason in the middle ... >> oracle would use DBMS_JOB instead of extproc. ... > The optimization is only a danger if there is a method ...
    (comp.databases.oracle.server)
  • Re: continuation...
    ... are not upgrading to 10gR2 because they are being bullied by some guy ... if they don't carefully consider the business impacts. ... of Oracle they are running. ... Likely the only reason they aren't leading ...
    (comp.databases.oracle.server)
Loading