Re: Dynamic Table name.. need syntax help

[David Donnelly <Dave@ISISBIO.COM>]

Cathlin,

The compiler has to be able to look up the types, etc., of all your column variables at compile time, before you've filled in $tablename.  So TABLE1 is used as the model ... it has to have at least the same columns that the table you eventually name has, and the fields have to be the same type, etc.

You can have a purely dynamic table, but then all the columns have to be dynamic too.

In v4 manuals, this is explained in the sections on dynamic SQR.

Dave

At 02:09 PM 11/17/1999 -0800, you wrote:
>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
>

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