How to hold the data in table till the process gets completed.

(0) Share

Report

Posted on by Adam123

522

Hi guys,

I have one requirement.

Initially I was doing in a way like , I will be inserting few records in the temp table and I will be sending request(JSON) from the table.

Now I have changed table to regular because I need to run in the batch since temp table will not support in the batch.

So after I changed to regular table before insertion I will be deleting all the record, Now my problem is when multiple user sending at a same time only once user data we are getting and other user record in getting deleted. This is happening because we are writing /deleteFrom_table/.

Is there is any way that I can hold the records till that user completes it's process, it should not get deleted till then.

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

How to hold the data in table till the process gets completed.

Hi Adam123,

You can add a field to store the user ID or a current session reference. Then delete only the records for the current user or session to keep the records from other users untouched. The delete_from command is supporting the where clause.