Re: Field vs. Cell in Filemaker
Re: Field vs. Cell in Filemaker
- Subject: Re: Field vs. Cell in Filemaker
- From: David Graham <email@hidden>
- Date: Tue, 13 Mar 2001 14:47:46 -0800
At 3:07 PM -0700 3/13/01, Guy Algot wrote:
Can anyone shed some light on the difference between these two lines of
Applescript...
tell application "Filemaker Pro" -- v5.0v3
name of every field
name of every cell
end tell
I thought that 'field' and 'cell' were interchangable. 'Name of every
cell' causes Filemaker to hang on me...
A cell is the intersection between a record and a field, and only
applies to the particular cell or range of cells that you specify (or
the current cell by default). Field refers to every cell for that
field.
FM probably isn't hanging, but it may take some time to process this request.
In this example your result will equal what you see in the define
fields dialog.
name of every field
-- {"test1", "test2", "test3"}
... however when you ask for the name of every cell, you are getting
every field name multiplied by the number of found records!
If you only had one record the result would be the same:
name of every cell
-- {"test1", "test2", "test3"}
If you had three records you would get this:
-- {"test1", "test2", "test3", "test1", "test2", "test3", "test1",
"test2", "test3", "test1", "test2", "test3"}
If you had 100 fields and 20,000 records you could see how easy it
could be to bury FileMaker with that type of request. Think of using
'field' as a replace function, whereby you can change the contents
for multiple records at once.
- Dave
--
==============================================================
David Graham Partnerships With Industry
MIS Manager 7540 Metropolitan Dr., #105
voice : 619.681.1999 San Diego, CA 92108
fax : 619.681.1990
http://www.pwiworks.org
AOL IM: dmgraham22
mailto:email@hidden
"We assist persons with disabilities to work in the community"
==============================================================