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=1705115386:HM/A=1000239/R=0/*http://ads.x10.com/?bHlhaG9vaG0xLmRhd=1018040054%3eM=215002.1954253.3462811.1261774/D=egroupweb/S=1705115386:HM/A=1000239/R=1>faa2a6.jpg
>faa31e.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]