Re: Font point size & Dynamic query variables

[Don Mellen <donm@ONTKO.COM>]

On Wed, 12 Aug 1998, Erin Bagozzi wrote:

> 2) I am trying to use two dynamic variables in a select.
> I have done something like this before but for some reason I can't
> get this to work.  I keep getting the same error - #911 Invalid character.
> The code I am using is below.
>
> if $Profile_Opt = 'S'
>    let $var1 = 'and AP.ADM_APPL_NBR = $Adm_Appl_Nbr'
>    let $var2 = 'and AP2.ADM_APPL_NBR = AP.ADM_APPL_NBR'
> else
>    let $var1 = 'and AP.ACAD_CAREER = $Acad_Career'
>    let $var2 = 'and AP2.ACAD_CAREER = AP.ACAD_CAREER'
> end-if

Try removing the variables from the parenthesis, ie:

    let $var1 = 'and AP.ADM_APPL_NBR = ' || $Adm_Appl_Nbr
and
    let $var1 = 'and AP.ACAD_CAREER = ' || $Acad_Career

HTH,
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"