That is exactly what I ending up doing. My boss slapped me in the back in the head and said you're looking more Homer Simpson every day. "Dooooh".
Thanks for the replies.
>Hi Dan,
>I naver use Alter table. I use the Select SQL to do the same thing because it faster.
>
>Ex:
>
>Use OldTable
>Select *,;
> space(10) as NewCfield1,;
> 000000.00 as NewNField2,;
> {} as NewDField3;
> from Oldtable ;
> into table NewTable
>
>
>This is faster then using a Alter Table...
>
>>Has anyone heard of issuing a number of alter tables against a table that has been created by a "Select ... Into Table ... " causing problems or bombing out.
>>
>>The table I create is about 178000 records.
>>I then re-open the table exclusively.
>>
>>I issue the following
>>1. Alter Table ...
>>2. Alter Table ...
>>3. Alter Table ...
>>4. Alter Table ...
>>5. Alter Table ...
>>
>>Sometimes the program bombs on .
>>Sometimes the program bombs on .
>>Sometimes the program works fine.
>>
>>In one example with a step on inside of my Error method, the table has been closed sometime between line 3 and line 4.
>>
>>I thought I was dealing with an out of memory problem but I am now logging the memory right after the error and the memory seems fine.
>>
>>The program works fine on small data sets. I have never seen problems with the smaller data sets. But with the large data set, about 1 out of every 3 runs, the program fails.
>>
>>I am running VFP 6.0 SP3 on a Windows NT Server SP4.
>>I have been able to duplicate the problem running an app within FoxPro.
>>
>>Please Help!!!!!!!!!
>>
>>TIA