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