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

Groups > comp.databases.filemaker > #2095

Re: Processing Portal Data in a Script

Show key headers only | View raw

In article <1m162nd.1ls1qm81cmdqygN%csampson@inetworld.net>, Charles H.
Sampson <csampson@inetworld.net> wrote:
> Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:
> > In article <1m10vq4.1wio5y81i39lq2N%csampson@inetworld.net>, Charles H.
> > Sampson <csampson@inetworld.net> wrote:
> > >
> > > What is the process for processing data from a portal in a script when
> > > there's the possibility that there are no linked records? I'm using Go
> > > To Portal Row (First) and then asking if I'm at row 0. If I'm not, then
> > > I loop through the portal rows using Go To Record/Request/Page (Next)
> > > with Exit On Last. Things aren't working so using some carefully placed
> > > Show Custom Dialogs I find that I am indeed at portal row 0 when I enter
> > > the loop if the portal does have linked records. Here's a fragment to
> > > try to make that clear.
> > > 
> > > Go to Layout ["Layout With Portal"; Main Data]
> > > Go to Record/Request/Page [First]
> > > If [Get (PortalRowNumber) /= 0]
> > > # Here's where my Custom Dialog with Get (PortalRowNumber) goes.
> > > # It shows that the row number is 0 if there are portal rows.
> > >    Loop
> > >       ... Stuff that might take me away from Layout With Portal.
> > >       Go to Layout ["Layout With Portal"; Main Data]
> > >       Go to Portal Row [Next; Exit after last]
> > >    End Loop
> > > End If
> > > 
> > > Please forgive any typos. While waiting for responses, I'll be looking
> > > for pilot error.
> > > 
> > > I'm still using FMP8. My ancient desktop is showing signs of age and I'm
> > > frantically converting old databases from Reflex Plus to FMP before it
> > > completely dies and I have to move to a new machine.
> > 
> > I'm guessing that "/=" is simply your way of retyping "not equal"
> > within the confines of the text-based Newsgroups since it won't work in
> > FileMaker itself. (You can use "<>" instead, which also works in
> > FileMaker.)
> 
> You're right about /=. I meant to explain it and forgot. would have used
> <> if I had remembered it and avoided all confusion.
> 
> > There are various ways to test if there are not any related records:
> > 
> >     - Count(Relationship::KeyField) = 0
> > 
> >     - Relationship::KeyField = ""
> > 
> >     - IsEmpty(Relationship::KeyField)
> > ...
> 
> Several people have used the construct Relationship::Field in replies.
> As well as I can tell, relationships aren't named in FMP8. Is this
> something that came along later or do you all mean TableName::Field?
> 
> As usual, thanks for your help, Harry.

Sorry, I don't know what newer versions of FileMaker do / don't do ...
I'm still using mostly version 5.5.

It shouldn't matter since you don't have to type it in. It's really
just an easy way of saying to use the related record's KeyField via the
Relationship. When using a create calculation window there is a list of
field names in the window, and above that is a pop-up menu which in
older versions of FileMaker lists the relationships - it should be the
same process in newer versions. When you change the pop-up menu, the
related table's fields are listed instead. It's similar to putting
fields into the Portal on a Layout.

Helpful Harry  :o)

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

Thread

Processing Portal Data in a Script csampson@inetworld.net (Charles H. Sampson) - 2015-03-09 15:40 -0700
  Re: Processing Portal Data in a Script Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-03-10 13:13 +1300
    Re: Processing Portal Data in a Script csampson@inetworld.net (Charles H. Sampson) - 2015-03-12 10:39 -0700
      Re: Processing Portal Data in a Script Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-03-13 16:32 +1300
      Re: Processing Portal Data in a Script Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2015-03-12 20:58 -0700
  Re: Processing Portal Data in a Script clkaufmann@gmx.ch (Christoph Kaufmann) - 2015-03-10 07:42 +0100
    Re: Processing Portal Data in a Script Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2015-03-10 11:30 -0700

csiph-web