I have used RBAdmin to kick users off and that is in Linux, if you were in MS-Server you could send them a alert I recall. It might help.
Sincerely, Paul D. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Sent: Thursday, February 11, 2010 11:10 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Speed issues Yah, You are right. I did that this morning, Kicked everyone out... 7 dispatchers didn't like that. and I connected multi off, changed reloaded, and then let them in. Better not do that again soon.... .:) Thanks I will heed your advice. I did however make a COPY of the table, made the required changes, and tested. Seems that is the trick. Thanks to all. At 11:05 AM 2/11/2010, you wrote: >Dan, > >For my $0.02, the only safe way to make structure changes is with MULTI OFF. > >Emmitt Dove >Manager, Converting Applications Development >Evergreen Packaging, Inc. >[email protected] >(203) 214-5683 m >(203) 643-8022 o >(203) 643-8086 f >[email protected] > > >-----Original Message----- >From: [email protected] [mailto:[email protected]] On Behalf Of Dan >Sent: Thursday, February 11, 2010 10:57 >To: RBASE-L Mailing List >Subject: [RBASE-L] - Re: Speed issues > >Thanks everyone. I will let you know if this fixes it. Right now the >table is locked and If I kick all 15 users off again today, they will >get ticked. I will come in tonight after hours and turn off the >unique setting on the table and make a primary key. > >Unless someone knows a way to unlock a table that is locked in multi user >mode? > > >At 10:38 AM 2/11/2010, you wrote: > >If you are sure that the data obeys the rule - and, presumably, you > >are - try setting rules off before you do the reload. > > > >Don't forget to turn them back on when you've finished! > > > >Regards, > >Alastair. > > > >-------------------------------------------------- > >From: "Dan" <[email protected]> > >Sent: Thursday, February 11, 2010 2:18 PM > >To: "RBASE-L Mailing List" <[email protected]> > >Subject: [RBASE-L] - Re: Speed issues > > > >>sure, > >>No Triggers, > >> No functions, > >> 3 indexes Custno, Invno, IDTrans (all unique numbers) > >> 1 rule: Ardetail.INVNO IS NOT NULL AND NOT Ardetail.INVNO IN ( > >>SELECT INVNO FROM Ardetail #T1 WHERE #T1.INVNO = Ardetail.INVNO ) > >> > >> Table: Ardetail No Lock(s) > >> > >> No. Column Name Attributes > >> --- ------------------ > >> ------------------------------------------------------ > >> 1 CUSTNO Type : TEXT 6 > >> Index : SINGLE-COLUMN > >> 2 INVNO Type : TEXT 12 > >> Index : SINGLE-COLUMN > >> 3 SDATE Type : DATE > >> 4 IDTRANS Type : TEXT 20 > >> Index : SINGLE-COLUMN > >> 5 INVAMT Type : CURRENCY > >> Default: 0 > >> 6 INVCUR Type : CURRENCY > >> Default: 0 > >> 7 PAYCUR Type : CURRENCY > >> Default: 0 > >> 8 PAYAMT Type : CURRENCY > >> Default: 0 > >> 9 CHKNO Type : TEXT 20 > >> 10 CHKDATE Type : DATE > >> 11 CREDIT Type : CURRENCY > >> Default: 0 > >> 12 SVCHARGE Type : CURRENCY > >> Default: 0 > >> 13 CURBAL Type : CURRENCY > >> Default: 0 > >> 14 AFTER30 Type : CURRENCY > >> Default: 0 > >> 15 AFTER60 Type : CURRENCY > >> Default: 0 > >> 16 AFTER90 Type : CURRENCY > >> Default: 0 > >> 17 OVER120 Type : CURRENCY > >> Default: 0 > >> 18 SCDROPPED Type : CURRENCY > >> Default: 0 > >> 19 TOTSVCH Type : CURRENCY > >> Default: 0 > >> 20 INVBAL Type : CURRENCY > >> Default: 0 > >> 21 MONTHNO Type : INTEGER > >> 22 SC_OK Type : TEXT 1 > >> Default: Y > >> 23 Posted Type : TEXT 1 > >> 24 SYEAR Type : INTEGER > >> 25 SPERIOD Type : INTEGER > >> 26 batchno Type : INTEGER > >> Current number of rows: 100476 > >> > >> > >> > >> > >>At 09:07 AM 2/11/2010, you wrote: > >>>Please post the structure of your table, including a list of > >>>indexes, rules, triggers, and constraints that apply. > >>>-- > >>>Larry > >> > > > > > > > >> > >>No virus found in this incoming message. > >>Checked by AVG - www.avg.com > >>Version: 9.0.733 / Virus Database: 271.1.1/2681 - Release Date: > >>02/11/10 07:35:00 > > > >
