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