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 to update data to newer version of a solution?

Featured Replies

I have a solution with several tables and each table with several fields, is there an easy way to import the data to the new solution version everytime I update the solution?

The best way is probably to separate the scripts, calculations, and rules of the system from the raw data. That way you would never have to worry about importing unless you actually changed a field definition (see the Separation Model forum for more information about this.) But if you didn't build your solution this way to begin with, this would require a major redesign of your database.

The simplest to implement in an existing solution would probably be a script that imports the data from the old version of each table into the new version. If you always rename the old version to a preset filename, this could be automated to a single button click. It would require a little effort to set up the first time, but you could then basically click a button and have the import run itself.

The biggest thing to beware of is accidentally changing database keys during the import process. Make sure you always uncheck the "Perform Auto Enter Operations" box when importing, or you may scramble your database relationships and lose historical information. Also make sure you Set Next Serial Value to a value higher than the current highest value for each auto increment field.

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.