🚀 go-pugleaf

>it does not matter you apply () or
> [] or any other combinations to the table names

This depends on DBMS - MS SQL Server may have one behaviour, Oracle another
etc.

----------------------------------------------------------------
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:3da59e8c$1@newsgroups.borland.com...
> 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
> > >
> > >
> >
> >
>
>