Looks like I missed typing the [ in
Format('select .....',[DtrTable,CODE]);

Daniel Bertin wrote:

>
> Thanks
> Daniel
>
> At 02:55 PM 05/04/2002 -0700, you wrote:
> >Closest 'Dynamic' I can think of:
> >
> >Close;
> >SQL.Text := Format('SELECT * FROM %s ORDER BY %s',
> >DtrTable,CODE]);
> >Open;
> >
> >===================================================
> >
> > > SQL.Clear;
> > > SQL.Add('SELECT * FROM :TABLE');
> > > SQL.Add('ORDER BY :CODE');
> > > Parambyname('TABLE').asString := StrTable;
> > > ParamByName('CODE').asstring := CODE;
> > > Open;
> > > end;
> >
> >Daniel Bertin 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
> > >
>
> > > >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/>http://docs.yahoo.com/info/terms/>Y
> > ahoo! Terms of Service.
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > ib-support-unsubscribe@egroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> > <http://docs.yahoo.com/info/terms/>http://docs.yahoo.com/info/terms/
> >
> >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=1018043769%3eM=215002.1954253.3462811.1261774/D=egroupweb/S=1705115386:HM/A=1000239/R
> >1253b46.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]
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/