Hi formspider team,

How to implement change/save process?. When user exits the application without saving his changes, I want to issue a warning about unsaved changes. This process involves first finding out whether the user made any changes or not. If there is a tutorial, kindly direct me to there.

Thank you for your help.


asked 23 Feb '13, 22:45

George's gravatar image

accept rate: 0%

Hi George,

You use api_application.isDMLNecessary or api_application.isDirty APIs to check whether unsaved changes exist or not in your application. The difference between these two APIs is as follows:

api_application.isDMLNecessary API returns Y when any updatable datasources existing in the application has uncommitted changes. Updatable datasource means at least one of the delete/update/insert permissions should be checked on the datasource definition. The function returns N if the modified rows don't belong to any updatable datasource.

api_application.isDirty API always returns Y if any datasource existing in your application has modified rows. It doesn't check if this datasource is updatable or not.

To sum up, depending of your need, you can use api_application.isDMLNecessary API to check only the changes made on datasources which are subject of the DML opertions or api_application.isDirty API to check all datasources.

Best Regards,


answered 24 Feb '13, 05:06

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
accept rate: 25%

Hi Ibrahim,

Thank you. This will help me to implement the save process.



(24 Feb '13, 10:26) George
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 23 Feb '13, 22:45

Seen: 1,778 times

Last updated: 24 Feb '13, 15:04

© Copyright Gerger 2017