Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Resulting found set error on import.

Featured Replies

I am running a script that imports records from one table ( Table A ) into another ( Table B ) in the same database file.

Here's what the script does:

 

1) Navigates to the table with the source records ( Table A ) and performs a find to pull out the records that will be imported into the other table ( Table B ).

2) Navigates to the destination table ( Table B ) and performs the [show All Records] script step

3) From Table B it imports (updating matching records) the found set from Table A. At this point I can see through the import dialogue that the records being imported are the correct found set. In this case a single (1) record.

4) Upon completion of the import, rather than the resulting found set being just the records that were imported/updated, that single (1) record, it is ALL RECORDS with the newely added record included.

 

I have stepped through the script with debugger, no other scripts are being triggered by any fields or layouts. Filemaker simply tells me it is importing 1 record and then shows me ALL records as the resulting found set.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.