Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to simultaneously do Insert/Update/Delete on one Table

Status
Not open for further replies.
Sep 5, 2006
37
US
Hi,

I am new to Paradox. As Paradox is a file based and I have a web based application that inserts/updates/deletes records off the Paradox tables. Now I have scenario and don't know how to handle this where several hundred requests come at the same time and do inserts/updates/deletes on the same one table. I am trying find a solution where I can do inserts/updates/deletes at the same time when several requests come through. I am using Paradox v5. Any idea on how and what is the best way to tackle this issue. I have a java Web Services that do the insert/updates/deletes on the Paradox tables.

Thanks
 
The problem is I am not able to do insert simultaneously on the same table. SO wondering if Paradox does allow to do simultaneous inserts on the same table.

Thanks
 
Part of the answer lies in how you are trying to do this.

Are you passing the data from the Web Services to Paradox to handle?

I would NOT attempt to try a query that inserts/deletes/edits all at once; do 3 queries. If you MUST, however, try a multi-line query where each line is a distinct operation.

Otherwise, what limitation/error are you experiencing? Does the Java stuff not work in conjunction with Paradox?

Sorry, but I'm having a hard time grasping your question, and grasping what the problem/issue is.

Tony McGuire
"It's not about having enough time; we have the rest of our lives. It's about priorities.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top