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

[whitesox99]

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

 

[TonyMcGuire]

I have a java Web Services that do the insert/updates/deletes on the Paradox tables.

So you are actually asking a Java question?

.

Tony McGuire

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.

 

[whitesox99]

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

 

[TonyMcGuire]

Do an insert and delete in the same operation?

Tony McGuire

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.

 

[TonyMcGuire]

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

http://www.wjcitycouncil.com

"It's not about having enough time; we have the rest of our lives. It's about priorities.