Re: With Transaction in FileMaker Pro
Re: With Transaction in FileMaker Pro
- Subject: Re: With Transaction in FileMaker Pro
- From: Matt Neuburg <email@hidden>
- Date: Sat, 01 Apr 2006 09:01:19 -0800
- Thread-topic: With Transaction in FileMaker Pro
On Wed, 29 Mar 2006 15:29:21 -0500, Bill Cheeseman
<email@hidden> said:
>The only way to know for sure whether With Transaction works in an
>application is to try to do what the With Transaction clause is supposed to
>prevent -- namely, make a change to the database from outside the With
>Transaction block while the With Transaction block is executing
Yup, I know, and I did that while testing. But whether I tested with
FileMaker Pro 8 specifically, I do not (as I said) remember. I certainly
tested using *some* Mac OS X version of FileMaker Pro, and it certainly did
resist the attempts of an outside script to send it commands while the
transaction was open. Whatever I was using, though, it was a demo version,
and it has expired, so I can't try it again. If you'll send me a serial
number for FileMaker Pro 8, I'll be glad to do some more tests! :)
There is no need, while testing, to "try to run a second With Transaction
clause"; it suffices to try to do *any* scripting of the app while a
transaction is open.
> Trying the former on FileMaker Pro 8 in Mac OS X, it blithely lets the
> second With Transaction clause access the database while the first With
> Transaction clause is still running
That doesn't quite prove what you want to prove, as AppleScript leaves it
completely open to applications to deal with the notion of a transaction.
Nonetheless, you are exactly right about what FileMaker used to do. In
FileMaker 5.5 (which I do have a serial number for), if I pause a script in
the middle of a transaction (using Script Debugger, yee-haa) and attempt
even to fetch a cell's value from another script, I get this error message
from FMP:
FileMaker Pro got an error: Data is being accessed by another user, script,
or transaction.
So if that isn't happening in FileMaker Pro 8, then something has indeed
changed (and I guess I didn't make the test I thought I was making). Maybe
they've abandoned transactions on the grounds that if you want that sort of
thing you have to buy the Server version, or something...? m.
--
matt neuburg, phd = email@hidden, <http://www.tidbits.com/matt/>
A fool + a tool + an autorelease pool = cool!
AppleScript: the Definitive Guide - Second Edition!
<http://www.amazon.com/gp/product/0596102119>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden