[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] dynamic SQL syntax question
- Subject: Re: [sqr-users] dynamic SQL syntax question
- From: "Don Mellen" <donm@ontko.com>
- Date: Fri, 29 Feb 2008 13:39:32 -0500
- Delivery-date: Fri, 29 Feb 2008 13:41:46 -0500
- In-reply-to: <47C84EEC.9050301@uwaterloo.ca>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- References: <47C84EEC.9050301@uwaterloo.ca>
This is so the sql can be compiled (pre-compiled?) against a known table of
the same structure as the dynamic table.
On Fri, Feb 29, 2008 at 1:29 PM, Andrew Ward <amward@uwaterloo.ca> wrote:
> I've just stumbled on a dynamic sql substitution that looks like:
>
> begin-SELECT
> ...
> FROM [TABLENAME:$tablename]
> WHERE ...
> end-SELECT
>
>
> I've never seen this syntax before, and can't find any info about it.
>
> Can anyone help out with an explanation?
>
> Thanks,
>
> Andrew
>
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
--
-----------------------------------------------------------------------
Donald Mellen | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com | "In the beginning, there was nothing, which exploded"
(Terry Pratchett)
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users