Re: dynamic FROM ??

["Ballesty, Lorraine" <lorraine.ballesty@ROCHESTER.EDU>]

I set up a program to use dynamic table names as follows:

    let $Plan_Table = 'ps_disability_ben'
....
    begin-select...
    ....
    from [$Plan_Table] P, accrual_work_tmp AW


SQR has always seemed a bit finicky about how whitespace is handled, so I'd
guess that it's probably not liking the space in your dynamic query
variable.

> -----Original Message-----
> From: Mario Mendoza [SMTP:mariom@FLAGSHIPCREDIT.COM]
> Sent: Wednesday, August 22, 2001 9:10 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: dynamic FROM ??
>
> The commas are with the variable, i.e.
> let $dt_bgl = 'business_group_lookup bgl,'
>
> Thanks
>
> Mario Mendoza
> 1-888-647-6472 x633
> mariom@flagshipcredit.com
>
> > -----Original Message-----
> > From: Kloprogge,F.J.M. (Frank) [SMTP:F.J.M.Kloprogge@FONTYS.NL]
> > Sent: August 22, 2001 8:59 AM
> > To:   SQR-USERS@list.iex.net
> > Subject:      Re: dynamic FROM ??
> >
> > It looks like your forgetting a comma after the dynamic tablenames.
> >
> >
> >
> > Frank Kloprogge
> > Fontys ICT-Services
> > DBA PeopleSoft
> > 08778-78710
> >
> >
> > -----Oorspronkelijk bericht-----
> > Van: Mario Mendoza [mailto:mariom@FLAGSHIPCREDIT.COM]
> > Verzonden: woensdag 22 augustus 2001 14:53
> > Aan: SQR-USERS@LIST.IEX.NET
> > Onderwerp: dynamic FROM ??
> >
> >
> > Good morning:
> >
> > Has anyone used a dynamic table_name in the FROM section? I have used
> > dynamic WHERE before but I am getting and invalid table name when I run
> > the
> > sqr. This is the code:
> >
> > from    ar_status_category_lookup ar,
> >         branch_lookup bl,
> >         [$dt_bgl]
> >         cash_posting c,
> >         company_loan,
> >         company_lookup cl,
> >         corporation,
> >         [$dt_dealer]
> >         loan l,
> >         payment_distribution pd,
> >         person p,
> >         pl_computed,
> >         pl_type_lookup,
> >         [$dt_territory_lookup]
> >
> > Many thanks
> >
> > Mario Mendoza
> > 1-888-647-6472 x633
> > mariom@flagshipcredit.com