Ok,

My turn to ask a question. I have to fix one old Paradox application
and I am having problem with Paradox INSERT statement. I create one
simple example to present my problem

There are 2 tables:

(1)The first one:

CREATE TABLE test(
test_id CHAR(4),
test_str CHAR(4)
)

(2)and the second one:

CREATE TABLE test 01(
test id CHAR(4),
test str CHAR(4)
)

The only different they have is the table names“test” and “test 01”)
and the columns name( “test_id”, “test id” and “test_str” and “test
str”) The first one table contain underscore in column names and the
second one contain space in the column name.

The INSERT statement for the first table (test) is working just
perfect:

insert into test
(test_id, test_str)
values
("0002", "1111")

but I am having a problem to insert a record into second
table(test01”). The next INSERT statement is complain:

insert into "test 01" t
(t."test id", t."test str")
values
("0002", "1111")

Error:
Invalid use of keyword.
Token: t
(t."test
Line Number: 1

I am just wondering how to solve this problem. I can not change the
tables structure in my project (to avoid space in the tables name and
in the columns name) because is too complicated. The tables are shared
trough all the project. I am using Delphi 7 and BDE to connect to the
database.

I am running the IINERT statement in the Borland Database Desktop as a
separate query, there is not any primary or secondary indexes or any
relationship at all, just pure INSERT statement. I know that Borland
Database Desktop have some problem and I thing I have to look for some
ODBC driver from Corel.

I thing the solution could be very stupid, but I can not find an
answer for Paradox tables. This one should be working in any SQL, but
Paradox is a little different story.

Thank you very much.

Blagoy.

Asked and answered in -development.

You do not need to post the question more than once.

"Blagoy" <delphi_stuff (AT) yahoo (DOT) ca> wrote