>I thought I'd take a shot at reorganizing the SP1 fix list published yesterday. I figured I couldn't make it any worse than it already was.
>
>Surprising too, given all the talk about GRID deficiencies earlier in the VFP9 cycle, that only 3 fixes appear to have any relationship at all to grids!
>
>Anyway, here it is:
>
>Bug fix list for the public beta of Service Pack 1 (SP1) for Visual FoxPro 9.0, September 23, 2005 (re-ordered)
>
>Olecontrol unable to use mouse to get focus to other controls from DHTML control
>ActiveX Controls - LeadTools ActiveX control makes 2 empty bars appear in Window menu
>Web Browser control: implementing DWebBrowserEvents2 causes parameter count mismatch
>
>OLEDB Provider - SYS(3050) should default to 128 MB in provider
>Unable to create dataset via the VFP OLEDB Provider
>Added support for adVarNumeric for ADO data source
>OLE DB Provider - Enable SYS(3055) inside provider
>OLEDB Provider - Provider changes current directory of calling ASP.Net application
>OLEDB Provider - GetSchema(string, string[]) failed to filter based on INDEX_NAME
>OLEDB Provider improperly handles binary parameters
>OLEDB Provider - DELETE VIEW and DELETE PROCEDURE
>OLEDB Provider - DBSCHEMA_PROCEDURES rowset returns obsolete procedures.
>OLEDB Provider - DBSCHEMA_PROCEDURES rowset returns incomplete procedure definition.
>OLEDB Provider - APPEND PROCEDURES ignores compilation errors in procedures.
>OLEDB Provider - when DBC doesn't have any tables CSchema_Indexes::Execute copies uninitialized strings, may cause buffer overrun
>
>Memory leak setting ActiveConnection property of ADO RecordSet object to NULL
>ADIR returns invalid file size for >2 gig files (virtual PCs)
>Language - "Menu manager internal consistency error." crash issuing CLEAR POPUPS
>Checkbox - Graphical checkbox and option button do not appear with darker backcolor when depressed with themes enabled
>MEMO values aren't translated when copied between tables with different code pages (SQL SELECT, APPEND FROM).
>Collections - removing items from collection with >=500 items crashes VFP under application verifier
>CommandButton - WEXIST() finds ToolTipText windows in VFP9, causing unexpected behavior in customer applications
>Combobox - "Data type mismatch" error setting value in dropdown when controlsource is null member property
>Control class doesn't resize anchored controls within itself.
>CursorAdapter - TABLEUPDATE(0) ignores SendUpdate setting for table buffered cursor.
>Data corruption when CursorAdapter bound to a Grid is updated in a TRANSACTION
>CursorToXML() doesn't output seconds for xsd:dateTime values if SET SECONDS is OFF (XMLAdapter may be affected as well).
>Unexpected error "Table has a file length / record count inconsistency" on END TRANSACTION
>Form - QUIT fired in DESTROY of form does not actually QUIT VFP9
>Form - Refresh problems on PageFrame in FormSet causes "ghosting" of a TextBox
>Form - Refresh issues in VFP9 only with various controls on a form
>Form - Orphaned form DataEnvironment causes VFP to crash when exited.
>Form - Internal Consistency Error modifying or running a form with object having invalid Zorder setting
>Toolbar not active with Modal Form inside Top Level Form
>Top Level form with contained modal form should be resizable, movable
>A formset object experiences memory corruption of user properties the second time it is run after a CLEAR ALL
>Unexpected Anchor behavior for values 256/512 and odd Width/Height.
>Wizard-generated forms fail when you try to add a record if the underlying tables have AutoInc field(s)
>GETOBJECT() has parameter limit based on file spec (261 chars)
>Grid loses data when selected alias is changed from one populating grid to alias of same table used again, and a CALCULATE command is used against 2nd alias
>Grid goes blank when custom method of parent formset is set as ControlSource of a grid column
>C0000005 exception pressing ENTER key when listbox ListIndex = 0
>C0000005 when accessing a free table in transaction if the table was made transactable (MAKETRANSACTABLE) in different data session.
>Pageframe with TabStretch=0 (multiple) and many tabs keeps growing when form is opened for edit
>Crash when Ctrl-Tab off disabled page on pageframe
>Picbtns class of Wizbtns.vcx displays warnings when used the CursorAdapter
>Converted form's READ gets released in 9.0, but not in earlier versions of VFP
>Engine - Fatal exception with REPLACE with undefined variable if row validation rule is present
>Report Preview - Different Print Preview Toolbar is opened when object assisted report is previewed than is opened when "Toolbar" is selected from Report Preview surface context menu
>Report Preview - "Go To Page" dialog opens out of visible range in when Preview Container TopForm property is .T. and windowstate is NORMAL
>Report Preview has incorrect title in some cases
>Object Assisted Report Preview - New-style Report Preview Toolbar inaccessible when report is previewed in SDI form without NOWAIT clause on REPORT FORM command
>Previewing a report with an image located on the disk causes a GDI handle leak each time the preview is refreshed
>REPORT PREVIEW GDI handles limitation with many pages
>Caclulated values in reports reset unexpectedly when 'reprint detail header' option is on
>ReportListener AdjustObjectSize and MaxHeightAvailable Properties do not work with floating objects
>ReportListener.OutputPage to HDC uses 96 DPI instead of printer DPI
>Report Output - HTML Listener - Object on report that is set to "Scale Contents, retain shape" appears differently between report preview and in an .HTM gen'ed by an HTMLListener
>Bug with Associated header and footer report option- Sequential detail records do not print across pages
>Multi detail bands do not display all records when starting on new page.
>Requery() on prepared remote view fails
>Engine - "Microsoft Visual C++ Runtime Library Buffer overrun detected!" followed by C0000005 crash running large SCAN loop
>SQLEXEC function allows reentrance for the same connection handle.
>Textbox - C0000005 Fatal Exception with AutoComplete textbox where textbox has ControlSource set to a field which allows NULLs
>Infinite loop when UNLOCK is executed.
>XMLToCursor and XMLAdapter fail to load values of type xsd:date if time portion is present (Whidbey includes time portion for date fields).
>Runtime - Status Bar or toolbar not visible in app run on Win98 SE
>Error "The procedure entry point GetLongPathNameA could not be located in the dynamic link library KERNEL32.dll" occurs running runtime app on NT4
>Language - C0000005 followed by "Mismatched pushjmp/popjmp call." executing program from "do " on Program Editor context menu when followed by call to EXESCRIPT()
>Wizards - SEARCH fails to find records when search performed against VarChar field
>
>Data engine no longer optimizes some queries involving DELETED() function and OR clauses
>Indexes on STR are penalized during Rushmore optimization if SET ANSI is OFF.
>Enable optimization for tables with non-current code page when ENGINEBEHAVIOR<90
>LOCATE fails to find a match when index on Currency is used for optimization and the right part of comparison is certain Numeric value.
>SQL - query returns incorrect result when correlated sub-query returning COUNT(*) is compared with 0.
>Unexpected "Subquery returned more than one record." error when aggregate is used in HAVING, but not in SELECT list.
>Unexpected "SQL: Error correlating fields." error with two EXISTS subqueries.
>Correlation is not verified to meet "correlation is supported only to immediate parent query" limit.
>Internal Consistency Error followed by fatal exception calling methods of object returned with GetObject("IIS://LocalHost/W3SVC/1")
>SELECT INTO ARRAY changes current work area if it uses sub-query in FROM.
>Index on table buffered cursor is corrupted after REPLACE with scope
>Unexpected "SQL expression is too complex" error with correlated subquery
>Unexpected "SQL expression is too complex" error on CREATE SQL VIEW over big tables.
>SQLCOLUMNS fails with complex names if at least one part of the name contains a space or other "illegal" character.
>Query returns incorrect result when ORDER BY+TOP N evaluation is merged with GROUP BY evaluation and TOP is optimized.
>SELECT COUNT(ICASE(.T.,1)) returns incorrect result.
>A Query with OUTER JOIN produces incorrect result if NOT EMPTY(...) is used in WHERE.
>Engine - CAST() to date of a blank datetime field returns datetime type
>Engine - ALTER TABLE ... ALTER COLUMN to change character field to integer changes value
>Engine - "Error building key for index..." error when indexing using str() on a NULL value
>Engine - Reopening or FLUSH of a table after a ZAP with SET TABLEVALIDATE >=8 gives "Table ... has become corrupted" error
>Engine - Fatal exception on REQUERY() after tableupdate() to remote view with batchupdatecount = -1 and table buffering
>Engine - Fatal exception on SQL SELECT when record size * record count is very high
>TOP N in subquery is ignored when UNION is used.
>
>Active Accessibility - Value for dropdown list style combobox does not appear in Accessible Event Viewer
>Saving form to an in-use file causes VFP to eventually crash
>Prompt for saving query references tmp file
>C0000005 in the View Designer with long expression
>VCX with properties seperated by CR will crash when building.
>Builders - MemberData Editor - Code bug in GetHierarchy() of MemberDataEditor.SCX causes MemberData Editor to get hierarchy wrong.
>Component Gallery - "Error building key for index" selecting "Clean Up" from context menu
>Editor - 100% CPU usage hang using Expression Builder from code editor window which contains nothing but two blank lines
>Two output-related FFC Loc files do not compile
>FFC - ReportListeners_Loc.h has stray string
>Form - Internal Consistency error then fatal exception editing form after adding relation to dataenvironment of form using aselobj() reference
>IDE - Tooltips appear in right monitor running VFP in left monitor in multi monitor setup where primary monitor is on right
>IDE - Access violation C0000005 activating Intellisense in the Program Editor
>IDE - "Browse table is closed" error message followed by unhandled exception (C0000005) when messing with Resource file during table browse
>On CHS Platform, reducing the width of a textbox which contains dbcs string will cause IDE to hang
>IntelliSense - C0000005 Access Violation exiting Class Designer after failed attempt to access LPARAMETER Intellisense for member method
>IntelliSense - Fatal exception in List Members after creating early binding mapi.session object with CreateObjectex()
>Language - C0000005 Fatal Exception working with a class library stored in a hidden folder
>Project Manager - Fatal exception building VFE sample app
>Project Manager - Fatal Exception (C0000005) changing font on Project Manager after Dock/Undock operation
>Project Manager - VFP hangs rebuilding app after error that classlib is in use
>Project Manager - New Project Managers do not remember their positions when "Override Individual Settings" is selected for the "Projects" type on the IDE Tab of the Options Dialog
>Properties Window - Fatal exception closing Zoom window with Enter key under App Verifier with SET KEYCOMP TO DOS
>Properties Window - Property Sheet crash closing Class Designer with CursorAdapter, XMLAdapter, XMLTable and XMLField after hitting ESC on a property, which is supposed to hold long (>255 characters) strings.
>Report Designer - Data Grouping limit for a report is listed as 74 in the help topic ""How to: Add Data Groups to Reports", but ReportBuilder.app limits you to 20
>ReportBuilder.app - Justification for numeric format is "Left justify". This differs from previous VFP versions and default Report Designer
>Report Builder - No error is given closing "Report Properties" dialog after setting "Initial Value" of a Report Variable to an invalid value
>Report Builder App - Open code window gets filled with garbage characters when one tries to close Report Designer and answers "NO" to "Do you want to save changes to ?" prompt
>Report Builder dialogs should respect regional settings
>Builders - Problems with Properties dialogs in ReportBuilder.app
>Report Previewer - Report Expression dialog for field with error is not displayed after error when you preview a report from designer while REPORTB = 90. It is when REPORTB = 80.
>RI builder uses incorrect syntax for UNLOCK command.
>
>COM obj Returning array loses array type
>Memory leak with IMPLEMENTS, COM servers
>IMPLEMENTS fails with Word.Application object with Office 2003
>COM Servers - Deadlock in REMClearConnect and csCritSectionEnter when COM+ recycles dllhost worker process
>
>Field types Blob and Varchar not showing right type in Watch Window
>Fatal exception when debugging a large code file
>DEBUGOUT outputs binary data as strings
>
>Miscellaneous changes to Xbase Reporting Components for VFP9 SP1

A good job Jim.

A true bug list has to have:
for every bug
an example where VFP9 the error is verified and VFP9SP1 it has disappeared.