Normal Topic Procedures questions (Read 613 times)
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Procedures questions
Sep 18th, 2010 at 5:02pm
Print Post Print Post  
In an invoice application, similar to the Sesame Seasons Sample ap. Is it 'safe' for several users to be viewing and making slight edits to the LineItems database in table mode, while another user updates existing invoices and add new invoices?

The user editing invoices is noticing line item data disappearing and we think it's caused by the other users in the LineItems database. (data is being replaced by search specs)

Any thoughts?

Steve
  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Procedures questions
Reply #1 - Sep 19th, 2010 at 2:06pm
Print Post Print Post  
I haven't seen this before, but I'll have Support check it out and see if the can make it happen.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: Procedures questions
Reply #2 - Sep 20th, 2010 at 5:34pm
Print Post Print Post  
Erika, thanks. Ben asked me to send in my ap, which I will do soon.

My .02 cents; the user working in the Invoice form (User A) is being 'locked out' by another user in the LineItems form whenever User A runs Formfieldvalue() and FormCommit() commands on the LineItems subform.

Can we easily allow User A to maintain priority over their subrecords and keep them locked to other users until they close the form?

Sincerely,
Steve
  
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Procedures questions
Reply #3 - Sep 20th, 2010 at 6:45pm
Print Post Print Post  
Steve_in_Texas wrote on Sep 20th, 2010 at 5:34pm:
Can we easily allow User A to maintain priority over their subrecords and keep them locked to other users until they close the form?

Not that I know of, Steve. Record locking locks a single record for each database at a time. Depending on what you are doing, it may be possible to add custom checks using SBasic.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged