General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Alter Table - Bugs?
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only