Hi Jim, Yes, the number of users would be nice to know. I do have a UserLog table in most of my applications. I have a routine called RBOnline.CMD showing all users who have either not logged out, or exited ungracefully so as to not post a log-out time.
This just happened 10 minutes ago – the BOSS was on the program! 😊 All the best! Steve From: 'jim schmitt' via RBASE-L <rbase-l@googlegroups.com> Sent: Tuesday, April 2, 2024 6:05 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - CVAL CONNECTIONS Thanks, Steve: Good to hear from you...The only thing I really like with the 'CVAL(''connections'))' option is that it responds with an integer # (of connections), but when it's incorrect it doesn't do any good. Although, sometimes it is the correct number (of connections). Your method is what I used to use, but I thought it would be better to inform the operator of exactly how many users are connected, and need to exit. Thanks and regards. On Tuesday, April 2, 2024 at 06:05:50 PM EDT, Steve Sweeney <steve_swee...@addesigns.com<mailto:steve_swee...@addesigns.com>> wrote: I always: DISCONNECT SET MULTI OFF CONNECT {dbname} If there are NO errors (if I CAN connect) then we are good to go with a backup. Also, I stop any web services connecting through Oterro – this seems to have a persistent connection, as well. Steve From: 'Karen Tellef' via RBASE-L <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> Sent: Tuesday, April 2, 2024 2:23 PM To: 'jim schmitt' via RBASE-L <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> Subject: Re: [RBASE-L] - CVAL CONNECTIONS What I've noticed (within my non-network-understanding limits) is that the connections don't necessarily decrease when they exit RBase, but rather when they log out of the network. It seems the network thinks they have RBase connections still open, but not RBase itself. Karen On Tuesday, April 2, 2024 at 04:10:45 PM CDT, 'jim schmitt' via RBASE-L <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> wrote: Hello, group: i am using cval('connections') in a backup routine to test and insure that all users are out of the system before starting the backup. Some of my users appear to have more connections than they have computers. One user who has 1 three user network had 26 connections. Does the connections get reduced as each user exits ? Just wondering what most of you are using to insure that all users are out of the database before performing a backup. Any enlightenment would be helpful. Thanks, jim 1-614-361-3942 -- 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/920496374.4843463.1712092238259%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/920496374.4843463.1712092238259%40mail.yahoo.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/1711672630.3821035.1712092984286%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/1711672630.3821035.1712092984286%40mail.yahoo.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/BYAPR03MB3718B1CDC371051562846AC3893E2%40BYAPR03MB3718.namprd03.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/BYAPR03MB3718B1CDC371051562846AC3893E2%40BYAPR03MB3718.namprd03.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/2109224727.4940646.1712106276043%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/2109224727.4940646.1712106276043%40mail.yahoo.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/BYAPR03MB3718D0CF3F8B159E346F8749893D2%40BYAPR03MB3718.namprd03.prod.outlook.com.