I believe FIBPlus has the facility to manipulate table names in sql
text via macros, and I'm sure IBObjects must has something very
similar (sorry, I've yet to user either, but others here are experts
with both). Of course this does not help you if you are stuck with
your current IB access component, but at least you know it can be
done.

Regards,
Andrew Ferguson

--- In ib-support@y..., Daniel Bertin <bertin@s...> wrote:
>
> Hi,
> I seems that you are right, I cannot pass the table name this way,
after
> changing the query to;
> with QRYT do
> begin
> Close;
> SQL.Clear;
> SQL.Add('SELECT * FROM :TABLE');
> SQL.Add('ORDER BY :CODE');
> Parambyname('TABLE').asString := StrTable;
> ParamByName('CODE').asstring := CODE;
> Open;
> end;
>
> I get the error;
> error 335544569
> SQL error = -104
> token unknown line1, char 15
> TIBOInternaldataset...
>
> Is there another way?
>
> Thanks
> Daniel
>
>
>
>
> At 04:41 PM 05/04/2002 -0400, you wrote:
> >At 05/04/2002 04:42 PM, you 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?
> >
> >The table name has to be known and it can't be a parameter.
> >
> >
> >Daniel Rail
> >Senior System Engineer
> >ACCRA Group Inc. (www.accra.ca)
> >ACCRA Med Software Inc. (www.accramed.ca)
> >
> >
> >Yahoo! Groups Sponsor
> >ADVERTISEMENT
>
><http://rd.yahoo.com/M=215002.1954253.3462811.1261774/D=egroupweb/S=1
705115386:HM/A=1000239/R=0/*http://ads.x10.com/?
bHlhaG9vaG0xLmRhd=1018040054%
3eM=215002.1954253.3462811.1261774/D=egroupweb/S=1705115386:HM/A=10002
39/R=1>faa2a6.jpg
> >faa31e.jpg
> >
> >To unsubscribe from this group, send an email to:
> >ib-support-unsubscribe@e...
> >
> >
> >
> >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]