LISTSERV - FMPRO-L Archives - LISTSERV.DARTMOUTH.EDU

FMPRO-L Archives

April 2012, Week 3

FMPRO-L@LISTSERV.DARTMOUTH.EDU

	LISTSERV Archives
	FMPRO-L Home
	FMPRO-L April 2012, Week 3

	Log In
	Register

	Subscribe or Unsubscribe

	Search Archives

Options:	Use Monospaced Font Show Text Part by Default Condense Mail Headers
Message:	[<< First] [< Prev] [Next >] [Last >>]
Topic:	[<< First] [< Prev] [Next >] [Last >>]
Author:	[<< First] [< Prev] [Next >] [Last >>]

Mime-Version:	1.0 (Apple Message framework v1084)
Content-Type:	text/plain; charset=us-ascii
Date:	Sat, 21 Apr 2012 02:03:54 +0200
Reply-To:	FileMaker Pro Discussions <[log in to unmask]>
Subject:	[ANN] Tip file: duplicating master and related records using ExecuteSQL and FM12
Content-Transfer-Encoding:	quoted-printable
Message-ID:	<[log in to unmask]>
Sender:	FileMaker Pro Discussions <[log in to unmask]>
From:	"G. Pupita" <[log in to unmask]>
Parts/Attachments:	text/plain (18 lines)

Hello --

It's a common procedure to duplicate a master record and its related records, though it's not a "native" FileMaker function: this implies  the need of creating a script that duplicates the master record and isolates its related records using a search or a relationship

The ExecuteSQL function introduced with FileMaker 12 now allows to create a completely modular procedure, a sort of "object" that can be re-used in any situation, just passing to the procedure tables and fields names.

Accessorily the procedure is deadly fast :)

Link: http://www.buliga.it/tipfile_execsql.html

(where you can also enjoy some aulic italian description of the file ...)


Ciao
G. Pupita
Certified FileMaker 10 Developer
FileMaker Business Alliance

ATOM RSS1 RSS2

LISTSERV.DARTMOUTH.EDU