PxPlus User Forum

Twitter Twitter Twitter

Author Topic: bsy/tim=0  (Read 876 times)

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 175
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
bsy/tim=0
« on: March 02, 2021, 09:23:49 AM »
Hi All,
i'm trying to check if someone is in a purchase order before reserving against it.
I found that if i set tim=0 on extract it does exactly what i want it to do with little to no lag:

extract (po_file,key=po_number$,bsy=*next,tim=0)

Does anyone see any harm in my doing this?

Jeff

Ken Sproul

  • Gold Member
  • ****
  • Posts: 60
    • View Profile
Re: bsy/tim=0
« Reply #1 on: March 02, 2021, 04:04:23 PM »
No real harm, but giving it a second would prevent unnecessary busy errors when someone tries to access a PO that just happened to be extracted but will be released in less than a second during say an update process.  Just something to consider.
Ken Sproul
DPI Information Service, Inc.
Pivotal Systems LLC

Jeffrey Ferreira

  • Diamond Member
  • *****
  • Posts: 175
  • I must have taken a wrong turn at Albuquerque.
    • View Profile
Re: bsy/tim=0
« Reply #2 on: March 05, 2021, 11:04:16 AM »
Thank you Ken.