Article ID: 135627
Article Last Modified on 3/24/2000
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
This article was previously published under Q135627
SYMPTOMS
Logical Fields are unavailable in Step 4 - Filtering of the Query Wizard.
WORKAROUND
Step 4 of the Query Wizard is used to filter your data. Because logical fields are unavailable, the Query Designer must be used to modify and execute the query. On the Final step of the Query Wizard, Finish, select the 'Save query and modify it in the Query Designer' option. In the Query Designer, in the Selection Criteria tab, drop down the Fields list and select the desired logical field. Select the filter criteria, and enter the example (.T. or .F.). Then execute the query.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Visual FoxPro 3.0b for Windows.
MORE INFORMATION
Steps to Reproduce Problem
- Create a table containing logical fields or open an existing table that has logical fields.
- On the Tools menu, click Wizards and then Query. Open the Query Wizard.
- On Step 1, select the desired table. Then select the desired fields, including a logical field.
- On Step 4, the logical field will not be available for filtering.
Additional query words: 3.00 VFoxWin fixlist3.00b buglist3.00
Keywords: kbbug kbfix KB135627