Our Contract with You, -- List of Chapters -- Table of Contents -- Acknowledgements -- About the Authors -- How to Download the Files -- Introduction -- Chapter 1: Project Manager Improvements -- Generating message logs during project build -- Change the Project Manager font -- Additional Project Manager shortcut menu items -- Modifying a class library from the Project Manager -- ProjectHook SCCInit and SCCDestroy methods -- Check out files -- Log source code control state -- Get latest version of files -- Summary -- Chapter 2: Controlling the Properties Window -- Cosmetic changes -- Specifying property values -- Customizing the Property Sheet -- The structure of _MemberData -- Setting attributes globally -- Inheriting _MemberData -- The MemberData Editor -- Replacing the MemberData Editor -- Playing favorites -- Creating property editors -- The bottom line -- Chapter 3: Writing Code -- IntelliSense improvements -- Enable IntelliSense in memo fields -- Give your users IntelliSense -- Saving IntelliSense settings -- IntelliSense in WITH and FOR EACH commands -- Background compilation -- Print selected text -- Copy code with formatting -- Find the highlighted text -- Better editing -- Chapter 4: Better Tools -- Changes to Options dialog -- Redirect Options dialog output -- View and Query Designers -- Spaces in table and view names in FROM clause -- Macro expansion based SQL clauses -- Class Designer and Form Designer changes -- Class/Form Designer Tab Order selection -- Keyboard shortcuts for adjusting object spacing -- Data Environment changes -- Enhancements to title bar descriptions -- Enhancements to Document View -- Builder behavior changes -- Integrate your own menu designer -- Debugger -- Constant support in Trace Window -- Watch Window errors -- Debug output window is mouse wheel enabled -- Reports can be debugged.

Class Browser is dockable -- Code References changes -- Task Pane Manager -- Use the Class Browser for PRG-based classes -- The Data Explorer -- Environment Manager - field mappings and form templates -- Replacing VFP native menu behavior -- New Property / New Method replacement -- New Dialog replacement -- Replacing native VFP shortcut menus -- GenDBC changes -- New Solution Samples -- Summary -- Chapter 5: Enhancements in the Reporting System -- Enhanced Report Designer -- Improved user interface -- Protection -- Design-time captions -- Design-time tooltips -- Absolute positioning -- Trim mode for character expressions -- Data grouping enhancements -- DataEnvironment handling -- International support -- Other new features -- Multiple detail bands -- Creating multiple detail bands -- Example 1: Multiple children -- Example 2: Pre-calculation of totals -- Record processing -- Enhanced run-time capabilities -- New reporting syntax -- New preview window -- Progress feedback -- HTML and XML output -- Graphic file output -- What about PDF? -- Other printing enhancements -- Summary -- Chapter 6: Extending the Reporting System at Design time -- ReportBuilder.APP -- Registering report event handlers -- The report event handling process -- Handler interfaces -- Event object -- FRXCursor helper object -- Creating report event handlers -- Report templates -- Custom dialog for new fields -- Generating cursors on the fly -- Summary -- Chapter 7: Extending the Reporting System at Run Time -- Report listener basics -- ReportListener -- Properties -- Report events -- Band events -- Object events -- Methods -- Registering listeners -- Utilities in the FFC -- _ReportListener -- UpdateListener -- _GDIPlus.VCX -- Creating your own listeners -- SFReportListener -- Report directives -- Directive handlers -- SFReportListenerGraphic -- Custom rendering.

Previewing reports -- New SYS() functions -- Summary -- Chapter 8: SQL Changes -- VFP 9 has no limits -- Lots of tables -- Nearly unlimited IN list -- Nested Subqueries -- More flexible subqueries -- Derived tables-Subqueries in the FROM clause -- Computing fields with a subquery -- Computing replacements in UPDATE -- Correlated subqueries and grouping -- Using TOP n in subqueries -- Correlated updates -- Correlated DELETEs -- A more perfect UNION -- Use names in ORDER BY with UNION -- Insert data from UNIONed result -- No parentheses with UNION -- Combining DISTINCT and ORDER BY -- Optimization changes -- Fully optimize LIKE with "%" -- Better speed for TOP n -- Improved performance with OR -- Filtering and temporary indexes -- Correlating faster -- Logging optimization results -- SELECT from buffered tables -- Turn off new behavior -- The bottom line -- Chapter 9: New Data and Index Types -- Varchar -- Varbinary -- Blob -- Specifying the data type of variable length values -- How the new data types affect DBF files -- Binary indexes -- Summary -- Chapter 10: Managing XML -- Creating nested XML -- RespectNesting -- lAutoNest -- New errors -- XMLTable enhancements -- Consuming nested XML -- XPath expressions for XML documents -- XMLNameIsXPath -- SelectionNamespaces -- DeclareXMLPrefix -- More new errors -- Non-Dataset XSD schema support -- Multi-language support -- Data type support -- Summary -- Chapter 11: Working With Remote Data -- SQL Pass-Through enhancements -- Temporarily disconnecting from a database -- Rollback on disconnection -- Get count of records affected by SQL Pass-Through -- Other SQL enhancements -- Detecting delayed memo fetching -- Monitoring fetch progress -- Map remote Unicode data to ANSI in memo fields -- Determining what connections are open -- ADO enhancements -- ADO bookmark support -- Cancel ADO fetch.

CursorAdapter changes -- Conflict checking -- Auto-refresh -- Timestamp support -- On-demand record refresh -- Set default values for CursorFill -- Delayed memo fetch -- Disable automatic transactions -- Specify code page for XML data -- CHECK constraints and default values for all data sources -- MapBinary and MapVarchar -- Logical data type conversions -- Increased size of property values -- VFP OLE DB enhancements -- XML support -- EXECSCRIPT() support -- Return ADO recordset from a stored procedure -- Summary -- Chapter 12: Other Data Changes -- Transaction support -- BLANKing data -- The last generated value -- REFRESHing your data -- Flushing your data -- AUSED() -- SET TABLEPROMPT -- SET("REPROCESS") -- Data conversion -- International issues -- Long type name support -- Behavior changes -- TABLEREVERT() -- Indexes -- Summary -- Chapter 13: Forms and Controls -- Controlling forms -- Docking user forms -- Anchoring controls -- Maximum form size -- Displaying graphical elements -- Rotating labels -- Creating and rotating complex shapes -- Managing toolbar separators -- Combining labels and themes -- Dealing with pictures -- Controlling pictures and captions -- Using GDI+ to specify images -- Helping users -- Auto-complete text boxes -- New formatting options -- Controlling focus -- Managing tooltips -- Better combos and listboxes -- Basing a combo or list on a collection -- Control the dropdown portion of a combo -- Controlling the scrollbar in listboxes -- Click fires more in listboxes -- Mouse support -- Memo and field tips -- Controlling the mouse pointer in grids -- Determine accurate mouse position -- Grid improvements -- Optimize filtered grid performance -- ControlSource reset with RecordSource -- Odds and ends -- WordWrap for checkboxes and option buttons -- No deletion in grid used as listbox -- Set index order in the data environment.

More control over added properties and methods -- The bottom line -- Chapter 14: Language Improvements -- Fewer limits -- Improved string handling -- TRIM(), RTRIM(), LTRIM(), and ALLTRIM() -- ALINES() -- TEXT -- STREXTRACT() -- Object-related functions -- Windows message events -- Internationalization issues -- Other enhanced commands and functions -- SET PATH -- TYPE() -- INPUTBOX() -- SYS(1104), SYS(3056), and SYS(2019) -- FFLUSH() -- SET DOHISTORY -- MROW() and MCOL() -- EXECSCRIPT() -- SCATTER -- BINTOC() and CTOBIN() -- Other new commands and functions -- ICASE() -- CAST() -- SYS(2910) -- Tablet PC support -- Clearing error information -- Summary -- Chapter 15: Setup and Deployment -- New run-time files -- New run-time dependencies -- Minor operating system requirements change -- SET COVERAGE command available at run time -- Improved performance and support detecting Terminal Server -- Updated Dr. Watson error reporting to 2.0 -- New configuration settings -- FoxRun.PIF change -- InstallShield Express FoxPro Limited Edition -- Installation -- Project Assistant -- Redistributable Downloader -- DemoShield Browser Wizard -- Help -- Product functionality changes -- InstallShield X Express -- Summary -- Index.