BUG: LOOKUP() Function with SET RELATION Causes Crash
ID: Q108635
The information in this article applies to:
- Microsoft FoxPro for MS-DOS, versions 2.5, 2.5a, 2.5b, 2.6
SYMPTOMS
In the Extended (32-bit) version of FoxPro for MS-DOS (FOXPROX.EXE), using the LOOKUP() function with a SET RELATION command may cause the system to terminate abnormally. In the Standard (16-bit) version of FoxPro for MS-DOS (FOXPRO.EXE), the above commands may cause an "Internal Consistency Error."
CAUSE
This problem arises while using LOOKUP() on a related table.
RESOLUTION
To work around this problem, do one of the following:
- Use a SEEK routine to move the record pointer to the desired record, then retrieve the contents of a specified field in the record.
-or-
- Release the relation before using the LOOKUP() function with either SET RELATION OFF TO or SET RELATION TO.
STATUSMicrosoft has confirmed this to be a problem in FoxPro versions 2.5, 2.5a, 2.5b, and 2.6 for MS-DOS. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATIONSteps to Reproduce ProblemWARNING: Close all files and save your data before completing the following procedure.
The following program will generate the error message:
CREATE TABLE city (fc_number n(10), name c(10))
INSERT INTO city VALUES(1,"Toledo")
INDEX ON fc_number TAG fc_number
SELECT 0
CREATE TABLE person (pe_number n(10), fc_number n(10))
INSERT INTO person VALUES (1,1)
SET RELATION TO fc_number INTO city
? LOOKUP(city.name,1,person.pe_number)
Additional reference words: FoxDos 2.50 2.50a 2.50b buglist2.50 buglist2.50a buglist2.50b exit quit fail 2.60 buglist2.60 KBCategory: kbprg kbbuglist KBSubcategory:
Last Reviewed: April 18, 1995
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.
| |