Tagging records for exclusive use

[broche]

CL 10
NT 9.12

Application has a pool of documents waiting to be edited.
I want to allow users to tag multiple documents then commit them for editing to one editor.
I can make a simple tag field in the document table work but users are stepping on each other when they process the table.

Any suggestions welcome.

I thought that I could record the userid with the password then stop others tagging this record.  My worry is that records would start to get tagged and not cleared then never sent to edit etc.

[Robert Iliuta]

I did not understand exactly what your problems are related to tag records....but I keep in a memory table the SessionID and Guid of records tagged. Process them and then delete when needed based on SessionID.
If you want to block access to a tagged records then do it with a flag.


Robert

[Bruce]

yeah, what Robert said.
You need a "tagging" table, which contains a SessionID and GUID of the selected fields.
I _think_ the Tagging example behaves like this?

cheers
Bruce

[kevin plummer]

If you block it with a flag then you want to also ensure the flag can be removed automatically after a period of time so your record is not locked. One way is when the session is deleted it also deletes the tags (which it should anyway). I would also use a memory table as Robert suggested.