Dan,
Based on the post under this one we are still working on making the
determination as to when data in a row has been changed. Once there we will
make the changes accordingly and will keep everyone posted..
Thought you might want to see how our application starts.
Our organization currently starts with tracking the user when they log onto the
production application. This is the code in the .dat file.
CONNECT posse_scw IDENTIFIED BY *******
SET NULL ' '
SET VAR vversion TEXT = (CVAL('VERSION BUILD'))
SET VAR vvconnections TEXT = (CVAL('CONNECTIONS'))
SET VAR vcomputer TEXT = 22
SET VAR vpossenme TEXT = 40
SET VAR vpossenme TEXT = 'The Posses of Sun City West'
SET VAR vguserid TEXT=NULL
SET VAR vggroupid INTEGER=NULL
SET VAR vcancel INTEGER=NULL
SET VAR vloginid TEXT = (CVAL('netuser'))
SET VAR vcomputer TEXT= (CVAL('COMPUTER'))
SET VAR vdateloggedin DATE = .#DATE
SET VAR vpassword TEXT = NULL
REFF eff_login_6.rff <This is where we test for a user name and password>
IF vcancel = 1 THEN
EXIT
ENDIF
---
CLS
SET TIMEOUT 60
REFF posse_desktop.rff <This is one of the main menus used after passing the
password check.>
---Who is logged on
SET VAR vpk INTEGER = NULL, vdatetime DATETIME = NULL
SELECT pk INTO vpk FROM whoisloggedon WHERE +
lusedid = .vloginid AND ccomputer = .vcomputer AND +
logdate = (SELECT MAX(logdate) FROM whoisloggedon WHERE +
lusedid=.vloginid AND ccomputer=.vcomputer)
---
UPDATE whoisloggedon SET logoffdate = .#now + <This is a table we use to track
who has logged on using what computer>
WHERE pk=.vpk
LABEL done
CLEAR VARIABLES iv%,rbti_%
Now to data in separate table(s).
There is an update performed – as I previous mentioned but not on a test for a
data change in a row of data in the table. Still working on it.
Yes, I didn’t answer your question per se but just wanted to let you know it is
still being worked on.
Myron
From: 'Dan Goldberg' via RBASE-L <[email protected]>
Sent: December 20, 2023 9:03 AM
To: [email protected]
Subject: [RBASE-L] - logging database value changes in a form
I have a requirement to keep a log(in a separate table) when someone changed
the data in a row in a form. This will include the old values and new values as
well as user/datetime stamp.
Has anyone done this before and can give me some pointers?
Happy Holidays
Dan Goldberg
--
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]
<mailto:[email protected]> .
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027EAF7EB79AAB93281A649D496A%40BY3PR19MB5027.namprd19.prod.outlook.com
<https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027EAF7EB79AAB93281A649D496A%40BY3PR19MB5027.namprd19.prod.outlook.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/018c01da341d%24e933c130%24bb9b4390%24%40gmail.com.
