Re: Field vs. Cell in Filemaker
Re: Field vs. Cell in Filemaker
- Subject: Re: Field vs. Cell in Filemaker
- From: Guy Algot <email@hidden>
- Date: Wed, 14 Mar 2001 08:13:34 -0700
On 3/13/01 3:47 PM, David Graham sent:
>
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.
I found that the result is limited to the fields on the layout and not
ALL the fields in the database. Is there was a way to return ALL the
fields in the db vs just the ones on a layout?
>
... 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.
Bang on, David! Try 17,000+ records opened from Filemaker server. When I
reduced the found set to just 1 or 2 records, it works as you outlined.
Later,
Guy
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Guy Algot (780) 974-8538
email@hidden Edmonton, Alberta
"The higher, the fewer!" Mac consulting/4D development
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
'Remember that as a teenager you are in the last stage of your
life when you will be happy to hear that the phone is for you'
-- Fran Lebowitz