Re: Dynamic Table name.. need syntax help

["Bencke, Gina" <GBencke@KICHLER.COM>]

Cathlin,

The FROM [ TABLE1 : $tablename ] allows SQR to actually compile the
Select paragraph during the compile phase ensuring that the fields exist
in TABLE1.  Then during the execution phase SQR recompiles the select
statement using the value of $tablename.

The FROM [$tablename] is not compiled until execution.

Both will work assuming the fields you are selecting exist in both
TABLE1 and $tablename.

Gina Bencke
Bencke Consulting Corporation
-----Original Message-----
From: Cathlin DeRosa [mailto:cathlind@NSIGHTINC.COM]
Sent: Wednesday, November 17, 1999 5:10 PM
To: Multiple recipients of list SQR-USERS
Subject: Dynamic Table name.. need syntax help


The FROM statement in my SQL clause looks like this

FROM [ TABLE1 : $tablename ]

what the heck is going on here???
this I would understand
FROM [$tablename]

but the other one has me baffled and I can't
find a referance to it in the manuals.

Thnks