Detecting database changes

This article has not been rated yet. After reading, feel free to leave comments and rate it.

Do you need to determine if a user has changed any of the fields of a displayed record, but hasn't yet posted the record?
If so, you can check the current state of the database via the datasource associated with it. To do so, simply write the following code:

	if (Datasource1.State in dsEditModes) then {...code you want to execute...}

If the datasource's State property is dsEdit, dsInsert or dsSetKey, this statement will evaluate as true.
Content-type: text/html

Comments:

2015-02-01, 03:55:16

anonymous from United States

That's a cunning answer to a chligenalng question

2015-02-01, 10:04:09

anonymous

You've maganed a first class post

NEW: Optional: Register   Login Email address (not necessary): Rate as Off-topic Very Helpful Helpful Ok article Not useful Very bad	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option, or post under a registered account.
	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material. Add a picture: