Brian Dunning's FileMaker Custom Functions

GetNthRecordXML ( theFields ; recNum ; encodeFlag )

Returns record data in XML format for nth record

  Average rating: 4.5 (31 votes) Log in to vote

Bruce Robertson   Bruce Robertson

Share on Facebook Share on Twitter

  Sample input:
GetNthRecordXML( fieldNames( get(fileName); "Audit"); 3; 0)
  Sample output:
R14
4/3/2007
12
Elfish
12:00:00

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Similar to my getNthRow function, this returns data for all the specified fields, for the Nth record of a found set or relationship. Fields must be in a return separated list. If no match is found the result is empty.

Inspired by Andy Knasinski's GetFieldsAsXML custom function.

ADDED: encodeflag option. If encodeflag is set to 1, data is encoded in so that characters like XML pointy brackets are encoded; otherwise all field data is passed without any changes.

Updated 4/14/07

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.