David

Stange one. Why do enclose LOTSTEMP in parenth.? Surely just

COPY STRUCTURE TO LOTSTEMP WITH CDX

would do?

The following is a much simpler version:

use LOTS in 0
COPY STRUCTURE TO LOTSTEMP WITH CDX
use LOTSTEMP in 0

select LOTS
GO TOP

SCAN
  SCATTER MEMVAR MEMO
	
  SELECT LOTSTEMP
  APPEND BLANK
  GATHER MEMVAR MEMO
ENDDO

Terry



>I am receiving a fata error (C0000005) when trying to create a 'good' copy of a table. This occurs when I try to create the new table using the 'COPY TO' command, so I then try to create and populate the table using the following code:
>
>
>****
>use LOTS
>COPY STRUCTURE TO 'LOTSTEMP' WITH CDX
>use LOTSTEMP in 0
>
>select LOTS
>GO TOP
>
>DO WHILE !EOF('LOTS')
> SELECT LOTS
>
> SCATTER MEMVAR MEMO
>
> SELECT LOTSTEMP
> APPEND BLANK
> GATHER MEMVAR MEMO
>
> SELECT LOTS
> SKIP
>ENDDO
>****
>
>The error is occurring on the GATHER command on specific records. Once I know which records are offensive, I can proceed by skipping (not GATHERing) records that cause the crash, but there are so many that it almost becomes a moot point to try to recover.
>
>I have two questions:
>
>1) What in the world causes this corruption?
>
>and, most importantly
>
>2) How can I recover my data?
>
>Thanks very much for any help.