Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Error when using multiple SQL Statements with "where" clauses to access Paradox table

4 views
Skip to first unread message

new2this

unread,
Sep 25, 2002, 11:29:06 AM9/25/02
to
Hello:

I am accessing a Paradox (Version 7) table remotely from a client
application. The client is enterprise integration software that
exchanges data between disparate applications across a network. For
connectivity to the Paradox database, I've created a system DSN using
the Intersolv 3.11 32-bit Paradox File driver. I have no problems
accessing the Paradox table using a single "Select * from" statement.
But I would like to process the Paradox table using consecutive
update/select/delete SQL statements containing 'where' clauses.
Unfortunately, when executing the following code from the client
application, I get the following error:

SQL Code:
update <table> set flg = 'Y' where flg = 'N'
Select * from <table> where flg = 'Y'
Delete from <table> where flg = 'Y'

Error:
'keyword found more than once: Where'

As when executing the single "Select * <table> where flg = 'Y'"
statement, I expect to retrieve rows from the Paradox table as a
result of the above query.

Could the problem reside in the version of the Intersolv driver I'm
using, or am I just executing the wrong SQL code?..Please advise

0 new messages