At 11:07 PM 11/9/2009, John Engwer wrote:
UPDATE t2008 SET Receipt ='Y' FROM t2008 t1,t2007 t2 WHERE
t1.CUST_NO = t2.CUST_NO
Using V8, 11/02/2009 build
John,
Have you PACKed the INDEXes since you have applied the last update?
Using the latest update of R:BASE Turbo V-8 (Build: 8.0.22.31102 or
higher), try
the following:
01. Start RBG8 and CONNect dbname
02. At the R> prompt:
SET FEEDBACK ON
PACK INDEX
CLS
SET FEEDBACK OFF
03. Now CREATE the TEMPORARY table accordingly and do the UPDATE as
outlined above.
See what you get.
Very Best R:egards,
Razzak.