Re: load-lookup problems

[Sayre John <John_Sayre@GAP.COM>]

Yes, am using a local () procedure





Victor Loghin <vgl_ca@HOTMAIL.COM> on 12/12/2000 12:25:23 PM

Please respond to sqr-users@list.iex.net



  To:          SQR-USERS@list.iex.net

  cc:          (bcc: John Sayre/SB/GAPINC)



  Subject      Re: load-lookup problems
  :






John,

Are you using a local procedure?

The follwoing code works for me.

  let $ACF-Where = 'LANGUAGE_CD=''CFR'''

  load-lookup
     name         = AccomplishmentsCFR
     rows         = {ACF-LookUpRows}
     extent       = {ACF-LookUpExtent}
     table        = 'PS_ACCOMP_TBL_LANG'
     key          = ACCOMPLISHMENT
     return_value = DESCR
     where        = $ACF-Where


Victor Loghin
VGL Consulting Inc.
vgl_ca@hotmail.com


----Original Message Follows----
From: john sayre <john_sayre@GAP.COM>
Subject: load-lookup problems
Date: Mon, 11 Dec 2000 11:02:53 -0800

I am trying to use a variable for the where clause for a load-lookup &
get a message
that the variable $wherepgm is not defined.  I do define it prior to the
load-lookup
( which is not in the setup section & can't be because of the variable)

it is defined as :

let $wherepgm = '(p1.pgm_desc=ps.pgm_desc' ||
                           ' and p1.prd_key=p2.prd_key'||
                           ' and s.prd_key=p2.prd_key'||
                           ' and s.tm_key='||$tm_key||')'

I can hard code most of that in the where clause of the
load lookup, but I really need time key

Why does this do that?

_____________________________________________________________________________________

Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com