INFO: KB Articles Answer Frequently-Asked FoxPro 2.x Questions

ID: Q121931

The information in this article applies to:

SUMMARY

This article is a reference to some of the most requested Microsoft Knowledge Base articles as well as to the online services available. The Knowledge Base articles listed here provide answers to some of the frequently asked questions about Microsoft FoxPro. However, this is just a small sample of the articles available in the Knowledge Base.

For additional information, you can query the complete Microsoft FoxPro Knowledge Base or you can obtain individual articles from the Internet.


MORE INFORMATION

FoxPro Resource Kit

You can also obtain the FoxPro Resource Kit. It is available as application note number FW1003.

To obtain this Application Note (number FW1003) and the files included with it, download FW1003.exe, a self-extracting file, from the Microsoft Software Library (MSL).

The following file is available for download from the Microsoft Software Library:

~ FW1003.EXE

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:
Q119591 How to Obtain Microsoft Support Files from Online Services



If you are unable to access the sources listed above, you can have this Application Note mailed to you by calling Microsoft Technical Support Monday through Friday, 6:00 A.M. to 6:00 P.M. Pacific time. If you are outside the United States, contact the Microsoft subsidiary for your area. To locate your subsidiary, please go to the following Microsoft Web site:
http://www.microsoft.com/worldwide/default.htm
For more information about the Resource Kit, please see the following article in the Microsoft Knowledge Base:
Q112311 FILE: Fw1003.exe FoxPro for Windows 2.5x Resource Kit

Some of the Available Microsoft Knowledge Base Articles

The following Knowledge Base articles are organized by category. These articles are available from the Internet and may be available on the FastTips service. If you are unable to access these sources, you can have these Knowledge Base articles faxed to you directly from Microsoft. Please give the Support Professional your fax number and the Q numbers of the articles you want.

NOTE: This list is only a small portion of the available articles. Even the articles listed here are subject to change. We frequently add new articles and update existing articles. As a result, the title of the article as well as the contents may change over time. Even if you have obtained one of these articles in the past, you may want to obtain the current version of the same article.

BROWSE Command


    Q Number  Title
    --------------------------------------------

    Q88491    Temporary Files Created by FoxPro
    Q88617    How to Browse for a Specific Character String
    Q88665    Sample Code Browses Fields and Accesses Scroll Bar
    Q95295    How to Have Two Browse Windows for the Same Database
    Q95380    Location of Screen and Command Windows Attributes
    Q97640    Combining GET Fields and a Browse in a Single Window
    Q98437    PRFOX: "Invalid File Descriptor" Error Occurs During Browse
    Q99095    How to Reset a Database Field to a Null Value in FoxPro
    Q102890   How to Calculate Running Totals in a BROWSE Command
    Q103610   PRB: Can't Move From Character to Character in BROWSE or GET
    Q104005   How to Coordinate Parent Data Window with Child Browse
    Q104593   Determining if Browse Window Activated/Deactivated
    Q107195   How to Browse with Mixed Read-Only and Read/Write Fields
    Q108632   How to Coordinate Browse Windows with Screens
    Q108682   Switching Between a Screen and Browse Using a Single Key
    Q111315   BROWSE Clauses Saved By PREFERENCE
    Q121027   How to Create a Modal Browse Window
    Q109791   How to Coordinate a Browse Window with a Control Screen
    Q108614   How to Create a Message Box for Fields in a Browse Window
    Q93350    How to Modify a Database Using the BROWSE Command

Coding and Special Functions


    Q Number   Title
    --------------------------------------------------------------

    Q97640     Combining GET fields and a browse in a single window
    Q95746     Bypassing automatic record locking with READ NOLOCK
    Q119230    How to create validation and selection popups for fields
    Q103645    How to change the default windows printer from FoxPro
    Q113011    How to hide a password and show entry position in FoxPro
    Q93587     How to Create a General-Purpose Thermometer Bar in FoxPro

_CUROBJ and Transferring Focus Between Screens



    Q Number   Title
    -------------------------------------------------------

    Q87683     Moving between multiple windows on the screen  
    Q96358     Using multiple screens for data entry with one read
    Q96356     Using CUROBJ with pushbuttons
    Q119692    How to keeps screens from flashing in a multiple-screen set
    Q117591    How to keep the cursor in GET object if data is invalid
    Q112599    How to hide deactivated screens in a screen set
    Q104347    Displaying unique messages for prompts in a button set

DDE and OLE Issues


    Q Number  Title
    -----------------------------------------------------------

    Q96352    How to Perform a DDE Link with Word For Windows
    Q95718    How to Close Microsoft Excel Using DDE Commands in FoxPro
    Q96351    How to Use Variables in a DDExecute() Command
    Q92966    Using a FoxPro Database in a Word For Windows Print Merge
    Q98701    Automatically Starting Microsoft Excel Macros Through OLE
    Q100444   How to Programmatically Embed and Link Part of a File
    Q100562   DDEInitiate() from a Client May Require a Pause
    Q101294   How to Edit OLE Objects on Screen with Active READ
    Q103087   How to Send Macro Commands to MS Excel Using DDEEXECUTE()
    Q107417   ERR: "Error Creating OLE Object" with APPEND GENERAL
    Q108681   Using DDE to Check If Another Windows Application Is Open
    Q109853   How to Set Up Asynchronous DDE Transactions
    Q112047   How to Perform DDE with DDEDATA.APP
    Q113443   How to Copy a General Field from One Record to Another
    Q114492   Using DDE and Macro Substitution with FoxPro and Word
    Q117587   How to Pass Data from FoxPro to Another Application
    Q132308   How to Use DDE from FoxPro to Control Windows Program Manager

Distribution Kit Issues


    Q Number  Title
    --------------------------------------------------------------------

    Q87695    PRB: Unable to build executable file from project
    Q93335    PRB: "Object file is wrong version" error
    Q94811    Common cause of "Feature not available" error
    Q132696   PRB: "File does not exist" Using Macro Substitution in EXE
    Q133358   PRB: Feature Not Available: Macro Substitution & Command 
                   Verbs

Foundation Read


    Q Number  Title
    -------------------------------------------------------------------

    Q87694    PRB: Menu Appears, Then Application Exits to Operating System
    Q107837   How to create a foundation read time-out
    Q119249   PRB: APP run from RUN MENU loses menu if no foundation read
    Q117786   How to build an application from an existing screen set
    Q109430   FILE: Fw0969.exe Coordinates Menus & Screens w/       
              Foundation READs
    Q93622    Events that trigger a foundation read

Gengraph Functionality


    Q Number  Title
    --------------------------------------------------------------------

    Q96304    RQBE Graph option not available if _GENGRAPH not set
    Q98771    Using GENGRAPH to update and display graphs
    Q99605    Passing date to a Foxgraph graph as a subtitle
    Q101597   Using UPDATEGRPH in GENGRAPH.APP
    Q103086   How to graph multiple data items using Microsoft Graph
    Q99841    Entering Microsoft Graph without the RQBE dialog box.
    Q98772    Using SHOWGRPH in GENGRAPH
    Q98770    Using REFRESHGRPH in GENGRAPH

Installation and Configuration Issues


    Q Number  Title
    --------------------------------------------------------------------

    Q97157    Changes to Windows during FoxPro for Windows installation
    Q111523   PRB: INSTALL /N adds a semi-colon (;) to beginning of PATH
    Q110116   ERR: Configuration portion of INSTALL /N fails
    Q110115   ERR: File"ADDUSER.APP" does not exist running "INSTALL /N"
    Q110114   PRB: INSTALL /N prompts for a floppy disk
    Q109651   Description of INSTALL /N (Workstation installation)
    Q101296   General information on workstation setup (INSTALL /N)
    Q101001   /A and /N switches for FoxPro for Windows network setup
    Q95713    Library Construction Kit Setup & Installation
    Q96170    FastTips for FoxPro For Windows: Installation Q & A
    Q97157    Changes to Windows during FoxPro for Windows installation
    Q96782    How to install FPW on a network
    Q98684    ERR: Invalid path message during SETUP /A on Novell network
    Q99537    ERR: Cannot change properties of FOXPROW.EXE file
    Q101298   Installing supplemental programs and optional components
    Q101881   FoxPro files that can be deleted to save space
    Q103772   How to change keyboard shortcuts in FPW
    Q105595   ERR: "CRC Error" occurs during setup
    Q109983   FoxPro uses more memory than specified with MEMLIMIT
    Q115423   PRB: FP for Win installation fails with Novell VLM.EXE 1.10
    Q115886   Disk space requirements for FoxPro For DOS
    Q115944   Comprehensive list of default main FoxPro directories
    Q116020   Disk space requirements for FoxPro for Windows
    Q117740   Setup & Configuration information for FPW
    Q114947   How to speed up installation/setup of FoxPro
    Q102787   How to configure FoxPro for Maximum Performance
    Q99606    Increasing startup speed of FPW
    Q101015   PRB: Foxdoc requires read/write access to FOXPROW directory
    Q99086    Available installation documentation

Internal Consistency Errors & GP Faults


    Q Number  Title
    --------------------------------------------------------------------

    Q119251   PRFOX: Relationship between tables may cause ICE or GPF
    Q95232    PRB: Video Card causes GP Faults or Display Problems

MEMVAR - Usage and General Information


    Q Number  Title
    --------------------------------------------------------------------

    Q99136    How to use the SCATTER and GATHER commands
    Q100564   How to create a custom search screen
    Q119792   How to change fields to use memory variables, not s

Report Writer


    Q Number  Title
    --------------------------------------------------------------------

    Q88885    Using the IIF function in FoxBASE+ or FoxPro
    Q88237    Stretch vertically and float as band stretches
    Q88602    PRB: Report duplicates parent records in one-to-many
    Q88667    Creating a running calculation using the report writer
    Q89000    How to edit the FoxPro P_CODES database
    Q95313    How to group data by yearly quarters
    Q97059    How to underline fields in the report writer
    Q119233   How to Underline Objects in a Report Form
    Q98924    How to change the band height in the report writer
    Q99634    Error when printing report to a file: "Printer not ready"
    Q99907    Duplicated lines printing report to text file.
    Q100552   Total of report bands cannot exceed page length
    Q106659   How to sum or count specific fields in a report
    Q107082   Searching for a series of matches in a field for a report
    Q111323   How to change the report writer's default font
    Q111998   How to use the report writer to preview or print graphs
    Q112838   How to dynamically change the page length of a report
    Q113754   "Syntax error" when verifying UDF() in report writer
    Q114248   How to print specific number of records in detail band
    Q120517   PRB: Empty report band won't close
    Q121053   Using Printer Driver Setup when running FPD report
    Q119354   How to group child records in a report detail band
    Q117214   PRB: Printing general fields produces black output
    Q114187   PRFOX: "Print to file" checkbox is ignored.
    Q114135   How to print check boxes instead of  Y/N in FoxPro reports
    Q114130   Creating a printer driver setup user procedure
    Q113178   Creating a report for a one-to-many relationship
    Q109152   How to create a data grouping on every Nth record
    Q108624   PRB: Report page preview appears briefly, then closes
    Q104885   PRB: Remove line if blank option doesn't work in report
    Q102934   Creating a report with highlights on every other line
    Q97053    How to create floating text objects in report writer
    Q88666    Troubleshooting printing problems in FoxPro 2.0 and 2.5

SQL Functionality



    Q Number  Title
    ------------------------------------------------------------------

    Q95670    Join using SELECT - SQL does not return any records
    Q98355    How to update a master table from a transaction file
    Q98434    Using wild cards in SQL statements
    Q102892   UNION in an SQL - SELECT produces only distinct records.
    Q101592   Support for the AS clause in RQBE
    Q110920   How to use wild cards and macro substitution in SELECT - SQL
    Q114123   SQL differences between dBase and FoxPro
    Q114672   PRB: Using SELECT SQL INTO CURSOR with same filename
    Q120472   PRB: SELECT SQL using CMONTH() function truncates month text
    Q119354   How to group child records in a report detail band
    Q118491   PRB: SELECT SQL command ignores SET FILTER condition
    Q109580   Causes of common SELECT SQL error messages

Outer Joins



    Q Number  Title
    -------------------------------------------------------------------

    Q89181    Outer Join syntax example for SELECT-SQL statement
    Q100069   Outer join with three or more data tables
    Q119901   How to use the UNION clause in a FoxPro Select statement
    Q124589   How to Create a Left-Right Outer Join in FoxPro for Windows

Wizards



    Q Number  Title
    -----------------------------------------------------------------

    Q114260   How to programmatically call the wizards dialog box
    Q114356   Description and availability of wizards on each platform
    Q114457   List of wizards and general instructions
    Q114983   Wizards and catalog manager can not be distributed
    Q115329   How WIZARD.APP locates files
    Q118802   FILE: Fw1022.exe Demonstrates Using FoxPro for Windows 
              Wizards
    Q119600   How colors are specified for the wizards
    Q119594   PRB: Cannot use wizards to modify screen, label or query
    Q115540   PRB: Running 2.6 wizard-created screen on another platform

Screen and Font Issues



    Q Number  Title
    ------------------------------------------------------------------

    Q97057    PRB: Sample Applications Display Greek Characters
    Q99090    PRB: Incorrect Font Appearance in Windows 3.0
    Q100441   PRB: Windows Are in Different Positions When Executable Is 
                   Run
    Q100558   Transporting Guidelines to Follow When Creating Screens
    Q103580   How Pictures Work with GET Fields and Proportional Fonts
    Q103583   Screen Fonts Varying in Size When in Different Resolution
    Q107830   Description of FOXPRO.INI Settings
    Q108826   Fonts Available on All Windows Systems
    Q110772   PRB: Window Sizes in .EXE Change w/ MODIFY WINDOW SCREEN FONT
    Q114476   PRB: "Position Is off the Screen" Error When Loading FoxPro
    Q114490   PRB: Transporting Screen Formats All Objects in a Single Font
    Q117569   FoxPro for Windows Interface Tips and Tricks
    Q111745   PRB: "Position off Screen" in FoxPro for Macintosh 
              Application
    Q117774   How to Identify the Font Types Available on the Macintosh

Additional query words: Questions Fax Top Hot Issues Q A DSKBGuide kblist commonly faxed novel faq kbsweepnext 


Keywords          : kbfile kbMAC kbVFp kbGrpFox kbDSupport FoxDos FoxWin 
Version           : MACINTOSH:2.5b,2.5c,2.6a; MS-DOS:2.0,2.5,2.5a,2.5b,2.6,2.6a; WINDOWS:2.5,2.5a,2.5b,2.6,2.6a
Platform          : MACINTOSH MS-DOS WINDOWS 
Issue type        : kbinfo

Last Reviewed: July 20, 1999