Re: LOAD LOOK UP

[David Donnelly <Dave@ISISBIO.COM>]

This is a guess, I haven't tried it:

>If I don't set $where to '', I get an error that the where clause ($where)  has
>not been prepared.
>If I do, the where does not get compiled & does not get executed
>
> begin-procedure load-lookup-tbls($WHERE)
>
> LET $WHERE=''

This says to me that the you're trying to modify a variable that has been passed into this procedure.  Not sure why, since you seem to set it in this procedure.  Anyway, if you're trying to modify a passed variable, you need a colon, thusly:

> begin-procedure load-lookup-tbls(:$WHERE)

My guess is that SQR is modifying a local copy of $where, but it is not being passed back to the actual variable.  The load-lookup is then looking back at the actual variable, which is perhaps not defined?

But since you are apparently not using the passed-in value, why not try changing the formal parameter's name?  Or get rid of it entirely?

begin-procedure load-lookup-tbls($WHERECLAUSE)


Dave

Dave Donnelly           <dave@isisbio.com>  or  <isisdave@usa.net>
ISIS BioComp            phone (909) 677-2446      fax (909) 677-3991