On Jul 12, 2006, at 10:23 AM, Gary (Lists) wrote:

>     data order in the resulting list is field-order dependent, or,  
> rather
>         it is dependent on the layout which is targeted by the "tell",
>         meaning that any output row's column order needs to be  
> carefully
>         planned and the script executed toward/against that layout  
> always.
>         (This used to be able to be handled by the "tell layout 0"  
> method,
>          and FM 6 can take advantage of that feature.)
>
>          tell layout 0
>
>             [Mark's lively script]
>
>         end tell -- of 0
>
>
> This could really save the OP some time.  Good idea, Mark.

In my script I specified a layout to get the fields formatted and in  
the same order as the user sees them.

I actually sent Joe a database that had a specified export, a  
filemaker script and then an applescript which used both of them.

-Mark
Who keeps trying to learn SQL but never has the time.