• 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 pro 7 record ID issues
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: filemaker pro 7 record ID issues


  • Subject: Re: filemaker pro 7 record ID issues
  • From: Jake Pietrykowski <email@hidden>
  • Date: Fri, 21 Jan 2005 09:51:50 -0600

Phillip,

Yes. I get the same results. FileMaker 7 appears to give record numbers from
1.0-127.0, then is skips to 3.2768E+4 (or 32768), at the 128th record..

If you change the script to:

 get ID of last record as integer

..you will see the real number.

What I observe is that at the 128th record, the ID is 32768, and for every
record thereafter, the ID is incremented by 1.

Odd yes, I don't see why the jump in ID numbers, but I definitely get the
same thing.

QUESTION: May I ask this of you? When I run this script to create 1000
records, is it me or is FileMaker 7 much slower at creating records than its
predecessor FileMaker 6? It seems to take a great deal of time, and my DB
only had 1 field.

Best Regards,
Jake


On 1/19/05 4:31 PM, "Phillip Smith" <email@hidden> wrote:

> I am transitioning a database from fmp 6 to 7 and i have an on going issue
> with record ID's according to applescript not matching those given by the get
> record ID function  of FMP 7.
> could some one else test this for me.
>
> create a database with one field displaying the calculation result of get
> record ID
>
> use apple script to create  1000 records as below
>
> tell application "FileMaker Pro 7" -- renamed fmp 7 as running fmp6 on the
> same machine
>     repeat 1000 times
>         tell database 1
>             create new record
>
>         end tell
>
>
>     end repeat
> end tell
> use apple script to below to check id returned via applescript
> tell application "FileMaker Pro 7"
>     tell window 1
>         get ID of last record
>
>
>     end tell
>
>
> end tell
>
>
> on my machine i get something like
> 3.4642E+4
> where as the calulated field gives a different number more like the count of
> records
>
>
> cheers
>
>
> Phillip Smith
> Applied Evolution
> www.applied-evolution.co.nz
> email@hidden
>


 _______________________________________________
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

  • Follow-Ups:
    • Re: filemaker pro 7 record ID issues
      • From: Bruce Robertson <email@hidden>
References: 
 >filemaker pro 7 record ID issues (From: Phillip Smith <email@hidden>)

  • Prev by Date: Re: Problem Quark->opening fonts-> open document
  • Next by Date: Re: "Where is application ...?" dialog stopping automation
  • Previous by thread: Re: filemaker pro 7 record ID issues
  • Next by thread: Re: filemaker pro 7 record ID issues
  • Index(es):
    • Date
    • Thread