Microsoft KB Archive/98753

= ERR: &quot;Feature Not Available&quot;; MODIFY/CREATE QUERY in .EXE File =

Article ID: 98753

Article Last Modified on 12/1/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft FoxPro 2.5b
 * Microsoft FoxPro 2.5a
 * Microsoft FoxPro 2.0
 * Microsoft FoxPro 2.5b for MS-DOS
 * Microsoft FoxPro 2.5a

-



This article was previously published under Q98753



SYMPTOMS
The MODIFY QUERY and CREATE QUERY commands return &quot;Feature not available&quot; error messages when called from an executable file built with the FoxPro Distribution Kit.



CAUSE
The MODIFY QUERY and CREATE QUERY commands are intended only for use in the interactive development environment of FoxPro. End users must possess the full product in order to access these commands.



RESOLUTION
To work around this limitation, use the RQBE window to construct a SELECT- SQL statement, then copy the results from the See SQL window and paste them into a .PRG file. Using this method, you can also create a RQBE-like screen/window that contains variables that can be used in the SELECT-SQL statement.

The following sample code demonstrates this workaround: dbfname = space(12) value = space(12) fieldname = space(12)

@ 5,5 SAY &quot;Enter the database name: &quot; GET dbfname @ 7,5 SAY &quot;Enter the fieldname: &quot; GET fieldname @ 9,5 SAY &quot;Enter the value: &quot; GET value READ

fieldname = ALLTRIM(fieldname) dbfname = ALLTRIM(dbfname) value = ALLTRIM(value)

SELECT &fieldname from &dbfname ; && Macro expansion is OK here. WHERE &fieldname = (value) ; && Parentheses ARE required here. INTO cursor query BROWSE

Additional query words: VFoxWin FoxDos FoxWin SQL SELECT MODI QUERY errmsg err msg relational by example dk

Keywords: kberrmsg kbcode KB98753

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.