Good Morning!

Looks like you cleared the sql statement that had
the parameters then added a new statement. Try moving
the paramByName's to after the Sql.Add.

HTH...Dan'l


--- Daniel Bertin <bertin@...> wrote:

> Hi all,
> Why can I not execute this query? I get unknown
> table name error. but if I
> replace the params with the values it's ok. what am
> I missing?
>
> StrTable := 'ManuFact';
> NAME := 'MANNAME';
>
> begin
> with QRYT do
> begin
> Close;
> Parambyname('TABLE').asString := StrTable;
> ParamByName('NAME').asstring := NAME;
> SQL.Clear;
> SQL.Add('SELECT * FROM :TABLE');
> SQL.Add('ORDER BY :NAME');
> Open;
> end;
>
> Thanks
> Daniel
>
>

=====
____________________________________
Every day is a Great day, but
some days are GREATER than others!

__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/