Myron:

Perhaps test for the value of system variable RBTI_DIRTY_FLAG before running the update routine.

R:Syntax:
"Returns 1 if any DB Control value(s) in form were changed or 0 if nothing was changed."

Great confabbing with you in Vegas, Bruce

Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203

[email protected]
(909) 238-9012 m

------ Original Message ------
From [email protected]
To [email protected]
Date 12/3/2023 7:25:39 AM
Subject [RBASE-L] - Know when data has been changed in a row of data in a table.

Subject: Know when data has been changed in a row of data in a table.

Background:

Using a form to enter or change data that is in a row in a table.
The application has code in place to record who is logged into the system. When exiting, with or without data changes to the row of data, the form has code in the exit button that uses an update command to take the logged in username and update the column in the row of data ‘last updated by’.
Goal: only do that update if the data has actually been changed.
R:Base has a way to check if data has been changed in a row of data when a table is opened and a column in a row has been changed. The save button on the bottom of the screen (the check mark) changes from grey to a color.

Is there a way to know, using code, if the data in a row in a table has changed? This would allow control over the update statement on exit.

Thanks in advance.

Myron Finegold




--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/012801da25fc%24f9748400%24ec5d8c00%24%40gmail.com <https://groups.google.com/d/msgid/rbase-l/012801da25fc%24f9748400%24ec5d8c00%24%40gmail.com?utm_medium=email&utm_source=footer>.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/em9b8227f3-3236-40ff-b721-a044cf90537c%403a6c7f86.com.

Reply via email to