PRB: "SQL Column '<Memvar>' Not Found" and Empty RQBE Window
Article ID: 112837
Article Last Modified on 12/3/2003
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft FoxPro 2.5b
- Microsoft FoxPro 2.5a
- Microsoft FoxPro 2.5b
- Microsoft FoxPro 2.0
- Microsoft FoxPro 2.5b for MS-DOS
- Microsoft FoxPro 2.5a
- Microsoft FoxPro 2.5b for MS-DOS
- Microsoft FoxPro 2.5b for Macintosh
This article was previously published under Q112837
SYMPTOMS
When you are opening or modifying a previously saved query, the error
message "SQL Column '<variable name>' Not Found" appears. After the error
message is displayed, the query will open, but everything except the
table(s) used will be lost (including selected fields and WHERE
conditions).
CAUSE
This behavior is caused by referring to a variable in a query and then
opening or modifying the query when the variable is not in memory.
RESOLUTION
Make sure the variable is defined in memory before opening or modifying the
query. Make sure not to save the changes to the query after it opens up
empty. The error message will indicate the variable that needs to be in
memory.
STATUS
This behavior is by design.
Additional query words: VFoxWin FoxMac FoxDos FoxWin missing errmsg err msg
Keywords: kberrmsg KB112837