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