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.

Table and Field creation using FM 7 script engine

Featured Replies

  • Newbies

Hi,

My company has developped an application using FM 6. They want to migrate to version 7, but their application is not easy to convert since it is splitted in multiple files (mainly due of the file size limitation). The converted application in FM 7 is REALLY slow and is still fragmented in multiple files.

Basically, by using XML export operations in FM 6 and some Java, I want to build a FM script that will be able to create the tables I need with their fields relations. I know that you can use SQL statements with the script engine, still a lot of fields or even data type cannot be created by using only SQL. Any suggestion about it or any hint about how I could use FM script to complete my tasks?

Thanks,

IB

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.