Accessing Paradox using multiple SQL statements

With what client application are you executing the sql statements, that are connecting to the Paradox tables?

Paradox the application, or another program?

You might try posting the actual sql statement so someone who knows sql might be able to debug it.

Sorry, I know near nothing about SQL.

It just sounded like maybe you weren't using Paradox the program as the client, and I wanted to get that out in the open for anyone else who might be able to help.

There are various flavors of SQL, and which client application you are using might make a difference.

To be clear, can you tell us the name of the program your client systems are using? What programming language it is in?

Actually, Paradox (the application) can directly update the Access table as it updates its own (Paradox) table format.

But my specific knowledge of this is limited. You use ODBC, and there are specific drivers that are better than others. I don't remember the details, and I'm not allowed to point you to the series of articles on how to do it.

Perhaps someone else has the info?

Jedstar:

Thanks for replying back...The client is a program that uses an SQL panel that allows you to (1) enter SQL code, very much like MS Query or (2) enter a call to a stored procedure within a RDBMS database, such as Paradox. The SQL statements I'm using updates a flag on a table, then selects rows on that table by that same flag, and then deletes the rows on that table by yet the same flag. Below is the code I'm using:

Update set flg = 'Y' where flg = 'N'
Select * from where flg = 'Y'
Delete from where flg = 'Y'

If possible, I wouldn't mind calling a procedure from the Paradox database that can perform this same SQL, as long as a result set is returned from the Paradox database. As I said before, when I perform a single "Select * from where flg = 'N'", rows are being returned to the client program with success. It's only when I add the "Update..where" and "Delete...where" that I'm having a problem. Can you provide a sample Paradox procedure that can perform the Update/Select/Delete for me?? Please advise..

Posted 22 years ago (Thread Starter)

Comment Quote

About new2this Visit Profile Membership pending. Member subscribes to this thread but email is NOT VERIFIED. Email Not Verified! Once email is verified, we will review and approve the account. Web Presence Hidden. Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc. Post ID #7641 (Level 1.4)  Reply to 7638 Reply Posted 9/24/2002 7:16:00 AM

Location=-- USA 

Joined=22 years ago   MB Posts=3