RE: [RBASE-L] - CVAL CONNECTIONS

2024-04-02 Thread Steve Sweeney
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 – th

Re: [RBASE-L] - CVAL CONNECTIONS

2024-04-02 Thread 'jim schmitt' via RBASE-L
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

Re: [RBASE-L] - CVAL CONNECTIONS

2024-04-02 Thread 'jim schmitt' via RBASE-L
Thanks, Karen I believe what you have said is true. I just wanted to see how other RB users determine if all are users are disconnected. Thanks.  Jim On Tuesday, April 2, 2024 at 05:23:07 PM EDT, 'Karen Tellef' via RBASE-L wrote: What I've noticed (within my non-network-unders

RE: [RBASE-L] - CVAL CONNECTIONS

2024-04-02 Thread Steve Sweeney
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. Stev

Re: [RBASE-L] - CVAL CONNECTIONS

2024-04-02 Thread 'Karen Tellef' via RBASE-L
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

[RBASE-L] - CVAL CONNECTIONS

2024-04-02 Thread 'jim schmitt' via RBASE-L
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 connec