NetTalk Central

Author Topic: Tagging records for exclusive use  (Read 3857 times)

broche

  • Sr. Member
  • ****
  • Posts: 336
    • View Profile
    • Email
Tagging records for exclusive use
« on: September 21, 2016, 09:34:18 AM »
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.
Brian

Robert Iliuta

  • Sr. Member
  • ****
  • Posts: 472
    • View Profile
    • Email
Re: Tagging records for exclusive use
« Reply #1 on: September 21, 2016, 11:56:06 PM »
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: Tagging records for exclusive use
« Reply #2 on: September 22, 2016, 01:21:43 AM »
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

  • Hero Member
  • *****
  • Posts: 1195
    • View Profile
    • Production Accounting and Software Payroll
Re: Tagging records for exclusive use
« Reply #3 on: September 25, 2016, 04:27:04 PM »
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.