🚀 go-pugleaf

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
>
>