Doug,
Thanks for the suggestion, I’ll try it weekend.
Happy Holidays to all.
Myron
From: rbase-l@googlegroups.com On Behalf Of Doug
Hamilton
Sent: December 21, 2023 8:32 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Know when data has been changed in a row of data in a
table.
Myron, when potentially updating a row using a form, I project a temp
table for that row and perform maintenance on the temp table.
When exiting the form, I update the permanent table from the temp table.
To detect if changes were made, I use the AUTOROWVER Operating
Condition; see:
To all – Thank you for sharing your knowledge.
I will keep you in the loop as I work this through.
Myron
From: rbase-l@googlegroups.com On Behalf Of
myron.fineg...@gmail.com
Sent: December 3, 2023 8:26 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Know when data has been changed in
I would use the table's "on save eep". If the EEP is triggered, then you know
the user made some kind of change. In the EEP you would then write the
name/date to the columns.
Karen
On Sunday, December 3, 2023 at 09:25:44 AM CST,
wrote:
Subject: Know when data has been changed in
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
Myron,
I think the solution would be to do what R:BASE is doing under the surface when
it performs “concurrency control” when saving the date. If I’m not mistaken,
R:BASE makes a copy of the “original” data and stores it before bringing a
second copy of the same data into the screen form.
Subject: Know when data has been changed in a row of data in a table.
Background:
1. Using a form to enter or change data that is in a row in a table.
2. The application has code in place to record who is logged into the
system.
3. When exiting, with or without data changes to the
7 matches
Mail list logo