🚀 go-pugleaf

Thanks a lot for the advise. The ParamCheck works like a charm. What I found
is that once the ParamCheck is disabled, it does not matter you apply () or
[] or any other combinations to the table names. Further, the
ParamCheck=false must be before the SQL string is added. Thanks again.

Lee Gan

"Vassiliev V.V." <news@vassilievvv.mtu-net.ru> wrote in message
news:3da53264@newsgroups.borland.com...
> Try set ParamCheck in TADODataset (TADOQuery, TADOTable etc.) to false.
You
> should also use brackets ([abc:def...]).
>
> ----------------------------------------------------------------
> Regards,
> Viatcheslav V. Vassiliev
> http://www.oledbdirect.com
> The fastest way to access MS SQL Server and MS Jet (MS Access) databases.
>
>
> "Lee Gan" <leegan@hotmail.com> �������/�������� � �������� ���������:
> news:3da4aa48$1@newsgroups.borland.com...
> > I posted this message sometime ago on this forum and did not get a
> workable
> > answer. Now I am trying again.
> >
> > I have an Access 97 database which has a table named something like
> > abc:def:gh. Then I try to query against the table using a TADOQuery. The
> SQL
> > statement looks like
> >
> > SELECT * FROM abc:def:gh WHERE conditions
> >
> > No problem with compilation and linking. However, whenever this SQL is
> > executed, an error message pops up asking me to specify parameters abc,
> def
> > and gh. This is simply because the compiler treats the table name as
three
> > parameters. I have tried to put "abc:def:gh", 'abc:def:gh',
[abc:def:gh],
> > {abc:def:gh} and many other things for the table name, no success. This
> > problem goes away when I manually change the table name to abcdefgh.
> >
> > Can anybody help me? Many thanks in advance. BTW, I use BCB 6 Pro.
> >
> > Lee Gan
> >
> >
>
>