Developer’s Guide

Using FileMaker Pro XML to deliver your data 7-9
Note The -max parameter returns 0 if the request returns no records.
Requests for adding records to a portal
When you make an –edit request or a –new request that includes data
for a portal of related database records, you must specify the layout
and the relationship name for the related database.
Note You can only add one record at a time to a portal, and therefore
must make separate –new requests to add more rows to the portal.
The following is an example of a –new request for adding a record to
a portal, where “Address::” is the name of the database relationship,
and “City.0” is the related field name in the portal:
FMPro?–db=employees.fp5&–lay=LayoutOne&FirstName=Sam
&LastName= Smith&Address::City.0=Seattle&–format= –fmp_xml&–new
Requests for editing multiple records in a portal
You only need to make one –edit request to edit multiple records in
a portal. You specify each row (or record) in the portal by adding a
period and a consecutive number (starting with number 1) to the end
of the related field name.
The following is an example of an –edit request for editing records
in a portal, where “Address::” is the name of the relationship,
“City.1” is the first row in the portal, and “City.2” is the second row
in the portal:
FMPro?–db=employees.fp5&–lay=LayoutOne&recid=11&
FirstName=Sam&LastName=Smith&Address::City.1=Seattle
&Address::City.2=New York&–format= –fmp_xml&–edit
The following is an example of another –edit request for editing
records in a portal, in an HTML form:
<FORM ACTION="fmpro" METHOD="POST">
<INPUT TYPE="HIDDEN" NAME="-db" VALUE="employees.fp5">
<INPUT TYPE="HIDDEN" NAME="-lay" VALUE="LayoutOne">
<INPUT TYPE="HIDDEN" NAME="-format" VALUE="-fmp_xml">
<INPUT TYPE="HIDDEN" NAME="-recid" VALUE="11">
<INPUT TYPE="TEXT" NAME="FirstName" VALUE="Joe">
<INPUT TYPE="TEXT" NAME="LastName" VALUE="Smith">
<INPUT TYPE="TEXT" NAME="Address::City.1" VALUE="San
Jose">
–modid (modification I.D.) Optional for –edit
–lop (logical operator) Optional for –find
–op (operator) Optional for –find
–max (maximum records) Optional for –find
–skip (skip records) Optional for –find
–sortorder (sort order) Optional for –find, –findall
–sortfield (sort field) Optional for –find, –findall
–script (perform script) Optional for –find, –findall
–script.prefind
(perform script before
–find)
Optional for –find, –findall
–script.presort (perform
script before sort)
Optional for –find, –findall
–styletype (stylesheet type) Optional for all requests
–stylehref (stylesheet
HREF)
Optional for all requests
–password Optional for –dbopen requests. Specifies the
database’s password.
field name (no hyphen) At least one field name is required for –new and
–edit. Optional for –find. See “field name (Name
of specific field)” on page B-10 for more
information.
Use these
parameter names To go with these requests