anothersmurf

Truncate Table script step pastes incorrectly

Discussion created by anothersmurf on Aug 15, 2017
Latest reply on May 15, 2018 by TSGal

Product and version (e.g. FileMaker Pro 14.0.3) FileMaker Pro Advanced 16.0.2.205

OS and version MacOS 10.11.6

Browser and version (for WebDirect only)

Hardware Mac Pro

Description When you copy the "Truncate Table" script step and paste it to another DB, the incorrect table is pasted.

How to replicate

1. You need two databases, with multiple tables in each DB. The DBs should have at least one same-name table ("commontable") and several different-name tables.

2. In DB1, create a script which includes the script step Truncate Table(Table:"commontable")

3. Copy that script step. (Or copy a group of script steps including that one, or copy the script itself.)

4. Paste into DB2.

5. Observe that that Truncate Table script step is truncating a different table (not "commontable"). There's no highlighting to indicate a problem.

Workaround (if any) Restore all your lost table data from backup.

Outcomes