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
