• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: FileMaker 7 AppleScript problems...
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: FileMaker 7 AppleScript problems...


  • Subject: Re: FileMaker 7 AppleScript problems...
  • From: Jake Pietrykowski <email@hidden>
  • Date: Fri, 07 Jan 2005 13:14:34 -0600

This has plagued me for some time, since I started sharing databases with
FileMaker 5. (for the record, its not JUST a FM7 issue ;-)

Using the following:

> tell app "filemaker pro"
>   tell database "databasename" to save
> End tell

This will only work for the 'local' instance of the database. While a viable
solution, yes, the problems still exists if another client is editing a
given record, how then can I force the 'client' instance of the database to
save, and thus take the focus off a particular field for the given record?
For that a solution has yet to be found.

(David, I feel your pain...especially when some comic users KNOW this and
continue to do it, as an intentional annoyance to me, that is, leave records
open in an 'edit' state, just to prevent access to the record.)

I've tried GUI scripting FileMaker Pro to keystroke return, but that only
affects the front window in FileMaker. Not much help if multiple
databases/windows are open. ;-)

I guess that is the beauty of developing a ASStudio GUI for FileMaker
databases. Records are accessed without focal points, and without the need
for a 'current record', rather can be referenced by ID. This results in NO
GUI access to the FileMaker databases, and thus...no focus on fields. Sweet.

Cheers,
Jake

On 1/7/05 4:26 AM, "Wim Melis" <email@hidden> wrote:

> This trick gets the focus off any fields, so the cells become accessible for
> writing to them:
>
> tell app "filemaker pro"
>   tell database "databasename" to save
> End tell
>
>> Another problem I am finding with FileMaker 7 is that I can't update
>> the current record if the cursor is in a field of the record (even if
>> the record has not been changed). I get the error "Data is being used
>> by another user, script or transaction".
>>
>> This presumably is a record locking problem. Perhaps some people have
>> developed good ways to deal with this that they would like to share.
>


 _______________________________________________
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

References: 
 >Re: FileMaker 7 AppleScript problems... (From: Wim Melis <email@hidden>)

  • Prev by Date: Re: Date computation
  • Next by Date: FTP Server to dynamically create users
  • Previous by thread: Re: FileMaker 7 AppleScript problems...
  • Next by thread: Re: FileMaker 7 AppleScript problems...
  • Index(es):
    • Date
    • Thread