HA, HA.
Tell the 'BOSS' to be more careful.
Concerning the backup message for the operator, I thought it would be more
informative to give the operator the number of users connected, like:
But, I can simply change the message to 'YOU HAVE OTHER USERS'.
As far as 'error' logs, I too utilize a 'Tracking' table, to log the time,
date, operator, function, etc, for entry and exit into the system.I also track
the description and 'operator entered' options for all major functions in the
system. This has proved to be invaluable when errors occur. The log or
tracking table is the largest table row-wise in the system.
Regards, Jim
On Tuesday, April 2, 2024 at 09:53:20 PM EDT, Steve Sweeney
<[email protected]> wrote:
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 <[email protected]>
Sent: Tuesday, April 2, 2024 6:05 PM
To: [email protected]
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
<[email protected]> 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 <[email protected]>
Sent: Tuesday, April 2, 2024 2:23 PM
To: 'jim schmitt' via RBASE-L <[email protected]>
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
<[email protected]> 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
[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/920496374.4843463.1712092238259%40mail.yahoo.com.
--
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
[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1711672630.3821035.1712092984286%40mail.yahoo.com.
--
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
[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/BYAPR03MB3718B1CDC371051562846AC3893E2%40BYAPR03MB3718.namprd03.prod.outlook.com.
--
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
[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2109224727.4940646.1712106276043%40mail.yahoo.com.
--
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/BYAPR03MB3718D0CF3F8B159E346F8749893D2%40BYAPR03MB3718.namprd03.prod.outlook.com.
--
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/771073940.5066041.1712140220783%40mail.yahoo.com.
