Apr 21, 2012; 02:03
G. Pupita
[FMPro] [ANN] Tip file: duplicating master and related records using ExecuteSQL and FM12
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
#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>
Apr 20, 2012; 19:23
Mike Dano
Re: [FMPro] [ANN] Tip file: duplicating master and related records using ExecuteSQL and FM12