Re: Filemaker Basics
Re: Filemaker Basics
- Subject: Re: Filemaker Basics
- From: Bruce Robertson <email@hidden>
- Date: Mon, 9 Aug 2010 21:43:32 -0700
Agreed, context and completeness and accurate understanding of different objects are very important.
set d to "Customers"
set dbref to a reference to database d
set lref to a reference to layout "Data Entry" of window 1
get data cell "CustomerID" of current record of table "Customers" of dbref
-- error: there is no such thing as the current record of a table
-- there is no found set or sort order in a table
-- a table is the creation order list of all records
get data cell "CustomerID" of record 1 of lref
-- "240"
get data cell "CustomerID" of record 1 of table "Customers" of dbref
-- "101"
Bruce Robertson
On Aug 9, 2010, at 8:27 PM, Tim Mansour wrote:
>> get cell "fileName" --> returns value from record 1
>> get cell "fileName" of current record --> error "object not found"
>
> In the FileMaker object hierarchy (which, btw, is not necessarily
> obvious from reference material), Records belong to either Tables or
> Layouts so you need to explicitly state the context of the Record. For
> instance:
>
> get cell "fileName" of current record of layout "Details"
> -- keeping in mind that every layout has its own found set
>
> get cell "fileName" of record 1 of table "Files"
> -- keeping in mind that multiple tables may have the same field name
>
>
> --
> Tim Mansour <email@hidden>
> Neologica Print & Promotions ABN 63 904 335 408
> Certified FileMaker 10 Developer
> PO Box K1163 : Haymarket NSW 1240
> Mobile 0405 500 846 : Melbourne in-dial 03 9012 7441
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> AppleScript-Users mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
> Archives: http://lists.apple.com/archives/applescript-users
>
> This email sent to 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:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden