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.

How would you do this?

Featured Replies

Is there any way to send data to a SQL sproc from FM GO?

 

Calling the sproc directly seems to be out since you can't use EXEC SQL from the mobile client. So, I thought we would insert data in to a sql table and feed it to the sproc with a trigger. Then we discovered this nasty problem:  

 

http://help.filemaker.com/app/answers/detail/a_id/7870/kw/ESS%20best

 

ISSUE
Using ESS with SQL Server you have a view setup in SQL Server that includes a trigger to the view so that if someone does an insert into the table, it will add the proper records in the proper places. 

When trying to create a new record from FileMaker, you receive the following error:

The target table '<example>' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.

NOTE: Changing or deleting data works fine.  Using a trigger with UPDATE works fine.

FileMaker, Inc. is aware of this issue with the FileMaker products listed.

 

 

 So, I am out of ideas and turning to these esteemed forums.  Any thoughts are appreciated.

Thanks,

John

 

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.