Jim, Since you are not using temp tables another approach would be to utilize the task scheduler on your server to call an RBase command file and update your table and then the users are just looking a data that's already there.
Jan -----Original Message----- From: Jim Belisle <[email protected]> To: "[email protected]" <[email protected]> Date: Tue, 15 Nov 2016 21:09:20 +0000 Subject: RE: [RBASE-L] - triggers? Thanks, Jan. It makes sense to use that approach. I will test that. James Belisle Making Information Systems People Friendly Since 1990 From:[email protected] [mailto:[email protected]] On Behalf Ofjan johansen Sent: Tuesday, November 15, 2016 3:06 PM To: [email protected] Subject: RE: [RBASE-L] - triggers? correct -----Original Message----- From: Jim Belisle <[email protected] [mailto:[email protected]]> To: "[email protected] [mailto:[email protected]]"; <[email protected] [mailto:[email protected]]> Date: Tue, 15 Nov 2016 21:00:28 +0000 Subject: RE: [RBASE-L] - triggers? Jan, If the other forms run off of a main form, then as long as the application is up, that custom form action would run based on the timer, correct? James Belisle Making Information Systems People Friendly Since 1990 From:[email protected] [mailto:[email protected]] [mailto:[email protected] [mailto:[email protected]]] On Behalf Ofjan johansen Sent: Tuesday, November 15, 2016 2:53 PM To: [email protected] [mailto:[email protected]] Subject: Re: [RBASE-L] - triggers? Jim, Do you use a Form as your main menu? If so, you could try creating a custom form action to do want you want. Call the form action every 1-2 minutes using the form timer. Jan -----Original Message----- From: Jim Belisle <[email protected] [mailto:[email protected]]> To: "[email protected] [mailto:[email protected]]"; <[email protected] [mailto:[email protected]]> Date: Tue, 15 Nov 2016 19:41:14 +0000 Subject: [RBASE-L] - triggers? WE use RBASE 9.5. I want to use a table (we will call it table1) to gather work punches from the shop. Then at let’s say every minute I want to update other tables based on this gathered info. This would be instead of doing it each time a row is added to table1. What would be the most efficient way to do this? I looked at triggers, but it seems they would be based on each time a row is added. I am not sure if I want to go that route. James Belisle Making Information Systems People Friendly Since 1990 -- 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]]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- 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]]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- 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]]. For more options, visit https://groups.google.com/d/optout [https://groups.google.com/d/optout]. -- 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]. For more options, visit https://groups.google.com/d/optout.
