[FX.php List] Design for Locked Records?

[Head Honcho]

Hi Jonathan,

I haven't bothered with this (yet), as the case of it happening is  
remote, however, "remote" isn't a very reliable variable! So, it is a  
good point.

I'd trap for error 301 (Record is in use by another user) and  maybe  
302 (Table is in use by another user) and if you're paranoid 303  
(Database schema is in use by another user).

If this is the case, the decision has to be made to programatically  
"try again", eg in a timed loop; store the data in a session variable  
to try again later (either manually or programatically), or manually  
try again.  In each case, a message to the user would be useful.  
"Database being used... trying again" or some such.

Minor issues can be taken care of, but the major one of someone  
leaving their cursor in a field, and then going out to lunch/home,  
could be a real issue, if that field/record is likely to be hit from  
elsewhere.

Food for thought!

Regards

Michael Ward
--
Head Honcho
CustoMike Solutions
Member, FileMaker Business Alliance
Member, FileMaker Technical Network
FileMaker 7 Certified Developer
FileMaker 8 Certified Developer
FileMaker 9 Certified Developer
FileMaker 10 Certified Developer
10 Wandoo Crt
Wheelers Hill, 3150
ph 0414 562 501
headhoncho at customikesolutions.com




On 06/01/2010, at 10:55 AM, Jonathan Schwartz wrote:

> Any takers?
>
> I'm developing a solution where the client employees are interacting  
> with the same db that the online system uses.  It is possible that  
> an office worker might be "in" a record while the online customer is  
> trying to update.
>
> What to do?
>
> Error out?
> Try again?
> Send a message to the office worker?  (possible?)
> Save the data to another file?
>
> Just looking for ideas.
>
> J
>
>
> Happy New Year Folks,
>
> Does anyone design for the instance where an fx.php transaction  
> tries to update a record that is being used by a native FileMaker  
> user, and thus is locked?
>
> If so, how do you handle?
>
> Thanks
>
> J
> -- 
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-370-5011
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
> -- 
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-370-5011
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list