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.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.