In order for this site to work correctly, and for us to improve the site, we need to store a small file (called a cookie) on your computer.
By continuing to use this website, you agree to our cookies and privacy policy.
  
Home page Home page Home page Home page
Pixel
Pixel Header R1 C1 Pixel
Pixel Header R2 C1
Pixel
Pixel Header R3 C1 Pixel
Pixel

RevMedia

  1. Volume 1
    Issue 1
    Issue 2
    Issue 3
    Issue 4
    Issue 5
    Issue 6
    Issue 7
    Issue 8
    Issue 9
    Issue 10
  2. Volume 2
  3. Volume 3
  4. Volume 4
 

  1. @Attack
  2. Bugs and PC's
  3. Miscellaneous
  4. QTIPS
  5. Readers Clinic
  6. Readers Forum
  7. RTP Series
  8. Uncommon Knowledge

 

  1. Full Article List

RTP Series - RTP31

The SUM processor. The valid delimiter range for sum seems to be CHAR(248) to CHAR(255) not CHAR(254) as documented. All elements of the array passed do not need to be numeric as non-numeric values are treated as 0. Thus an array containing order quantities and "N/A"s could quite happily be SUMmed.

(Volume 1, Issue 4, Page 5)
Pixel
Pixel Footer R1 C1 Pixel
Pixel
© The Sprezzatura Group 2019
Privacy Policy
Making Databases Happen
Registered Address: 12A Marlborough Place, Brighton, BN1 1WN
USA +1 215 939 3400
Pixel
Pixel