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
>
>
