Thx that looks like a good idea. do it at the table level. I will play with that.
Dan Goldberg MIS Manager 43120 Venture Street Lancaster, CA 93535 T (661) 949-3322 x 252 LanceCamper.com<http://lancecamper.com/> [cid:image001.png@01DA33DF.20062C50]<https://www.lancecamper.com/> [signature_619742412] <https://www.facebook.com/LanceCamper> [signature_287766426] <https://www.youtube.com/user/LanceTrailer> [signature_512365786] <https://www.instagram.com/lancecamper/> [signature_321439517] <https://www.pinterest.com/lancecamper/> Confidentiality Notice: This e-mail, including any files transmitted with it, is the property of REV. It is confidential and is intended for the use of the individual/entity, to whom the e-mail is addressed. If you are not a named recipient, or otherwise have reason to believe that you have received this message in error, please delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Ken Shapiro Sent: Thursday, December 21, 2023 7:06 AM To: rbase-l@googlegroups.com Subject: [EXTERNAL] Re: [RBASE-L] - logging database value changes in a form You don't often get email from kens...@gmail.com<mailto:kens...@gmail.com>. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification> Myron, I think you can use triggers to capture when data changes. You can use an on before update trigger which can be set in the table definition. A stored procedure has to be created first. With the store procedure is created a trigger can be created on the table. There are virtual tables sys_old and sys_new than can be referenced within the trigger: select list_of_db_columns into INTO list_of_variables FROM table WHERE CURRENT OF SYS_OLD SELECT list of db columns INTO list of variables FROM table WHERE CURRENT OF SYS_NEW IF some old var <> some new var UPDATE another table SET t_c = .#DATE WHERE 'where clause' ENDIF Ken On Thu, Dec 21, 2023 at 9:56 AM <myron.fineg...@gmail.com<mailto:myron.fineg...@gmail.com>> wrote: 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 <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> Sent: December 20, 2023 9:03 AM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 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 rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>. 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 rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/018c01da341d%24e933c130%24bb9b4390%24%40gmail.com<https://groups.google.com/d/msgid/rbase-l/018c01da341d%24e933c130%24bb9b4390%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 rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CADeqk-5coV6kCKEB3jYENbOOqTkumrUgTr2ZfC56L6n6MttS%2Bw%40mail.gmail.com<https://groups.google.com/d/msgid/rbase-l/CADeqk-5coV6kCKEB3jYENbOOqTkumrUgTr2ZfC56L6n6MttS%2Bw%40mail.gmail.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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027DB787EE5CE2F62693D06D495A%40BY3PR19MB5027.namprd19.prod.outlook.com.