thank you for that observation, you are correct.

Thanks
Daniel


At 12:37 PM 05/04/2002 -0800, you wrote:

>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/>http://taxes.yahoo.com/
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://rd.yahoo.com/M=178320.1964497.3448863.1261774/D=egroupweb/S=1705115386:HM/A=879172/R=0/*http://www.fastweb.com/ib/yahoo-75f>f10aa8.jpg
>
>f10b7b.jpg
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.

[Non-text portions of this message have been removed]