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.

Import Source File Opening problem.

Featured Replies

I am using FM 12 adv on windows and mac

 

As part of my import script, I need to determine if the Source File has particular Tables and/or Fields.

 

Also, as part of my import script the user 'browses' to whatever prior version of my application they need to import.  Therefore, until the import script is executed, I do not know the path or filename.

 

Also, as part of my import script I have determined the full file path and filename ($$Path) and have picked off the FM File Name:  ($$Filename).  This works.

 

So, I've been trying to get up to speed with Execute SQL and I think the Filemaker_Tables and Filemaker_Fields are what I need to make that determination.

 

The problem:

I need to OPEN $$Filename prior to using the Execute SQL command to make the determination. 

 

It looks like OPEN FILE does not allow me to specify $$Filename but 'assumes' that the file is all ready present.

 

Surely this problem has been addressed by more advanced developers?

 

Thank you

 

Ron

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.