Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #299

Re: GTRR in scripts

Show all headers | View raw

On 3/07/11 3:14 PM, Christoph Kaufmann wrote:
> FMP 10 Adv: When using GTRR in a script, you want to be sure in what
> context/layout you land. Which test works best for you?
>
> - use the count function to check whethe related records exist
> - use a get function after the GTRR to check what the underlying table
> is
> - get last error after GTRR
> - others?
>
> I used the first method so far, but it's no use if I have to go to the
> related recods of all the records in my found set.
>
> I tried the third option - get last error - but I get error 101 (missing
> record) even though lots of records were found and GTRR worked as
> expected. I assume I get error 101 when there's at least one record in
> the found set with no related records (which is irrelevant).
>
> Meaning I have check for context and found records after the GTRR. I
> don't like it because it means I have to hard code the name of the TO in
> the test.


conditionally test IsValid( rel)  BEFORE going anywhere



If [ IsValid( Diagnoses_children::diagnosis_id) ]
Go to Related Record
[ From table: “Diagnoses_children”; Using layout: <Current Layout> ]
[ Show only related records ]
Else
Show Custom Dialog [ Message: "No children"; Buttons: “OK” ]

End If



As for network speed, I would suspect that FM is downloading ALL records 
that match the GTRR criteria to the CLIENT, and performing the find AND 
sort, on the CLIENT. Could be wrong on this.

This was/(is) the case however with External Data Sources.  I 
encountered something similar on a very slow multi-criteria filtered 
portal ( FM table to FM table) just last Friday, that appeared to be 
downloading the entire (small c. 68,000) related record set) to 
establish the portal set and then sort.

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

GTRR in scripts clk@tele2.ch (Christoph Kaufmann) - 2011-07-03 07:44 +0200
  Re: GTRR in scripts David Jondreau <david@wingforward.net> - 2011-07-03 10:31 -0700
    Re: GTRR in scripts David Jondreau <david@wingforward.net> - 2011-07-03 19:35 -0700
    Re: GTRR in scripts clk@tele2.ch (Christoph Kaufmann) - 2011-07-04 06:04 +0200
  Re: GTRR in scripts cortical <cb@corticaldata.com.au> - 2011-07-04 12:02 +0930
  Re: GTRR in scripts clk@tele2.ch (Christoph Kaufmann) - 2011-07-04 06:09 +0200

csiph-web