[RBASE-L] - Re: Simple Syntax Question

[Rachael Malberg]

SET VARIABLE vThisCheckAdded currency = 0

Select Sum(PRHDR.DED14 + PRHDR.DED15) into vThisCheckAdded From PRHDR, 
EMPLOYEE401K Where PRHDR.EID = EMPLOYEE401K.EID 
  ----- Original Message ----- 
  From: Gray, Damon 
  To: RBASE-L Mailing List 
  Sent: Tuesday, November 25, 2008 2:24 PM
  Subject: [RBASE-L] - Simple Syntax Question


  I'm getting a syntax error on the below.  I need the CURRENCY value of DED14 
and DED15 to be summed and then assigned to vThisCheckAdded.  I can't seem to 
wrap my mind around how to get that done.  I've trued multiple permutations of 
the query below with no luck.  It's likely obvious and staring me in the face, 
but.

   

   

   

  SET VARIABLE vThisCheckAdded = Select Sum(PRHDR.DED14 + PRHDR.DED15) >From 
PRHDR, EMPLOYEE401K Where PRHDR.EID = EMPLOYEE401K.EID Group By EMPLOYEE401K.EID

   

   

                  Damon J. Gray

  Anvil Corporation Business Services

                     (360) 937-0770