I have an table with buffering set to 5 (optimistic table), which I wish to SCAN through and change some records. When I attempt to do this, VFP locks up on the following command:
LOCATE FOR MYTABLE.nForeignKey = lnForeignKey
I have a SCAN loop following the LOCATE which includes the same FOR condition, plus a couple other conditions. If I comment out the LOCATE, the SCAN statement locks up just as the LOCATE did.
Here are the conditions under which this operating:
1. I'm using VFP 5.0a with Service Pack 3, under Win95 (OSR1) on a local hard drive.
2. There is a BEGIN TRANSACTION in progress.
3. I did a SELECT MYTABLE immediately prior to the LOCATE.
4. Some records in MYTABLE have already been edited, but issuing TABLEUPDATE(.T.) prior to the LOCATE makes no difference.
5. lnForeignKey is a LOCAL variable, but declaring it PUBLIC makes no difference.
6. Running COMPILE CLASSLIB and PACKing the class library in which the code resides makes no difference.
7. Reindexing and packing the table (using Stonefield Database Toolkit) makes no difference.
8. VALIDATE DATABASE made no difference.
At this point I'm totally mystified. Any thoughts on this would be greatly appreciated.
Thanks,
Mike
Mike Potjer
Optimal Solutions, Inc.